TDV Adapter for REST

Build 22.0.8462

Fine-Tuning Data Access

The Generic REST Adapter enables the granular control useful in more complex deployments or network topologies; you can use the following connection properties to fine-tune data access, connect through a firewall, or troubleshoot connections.

Fine-Tuning Data Access

You can use the following properties to gain greater control over how the adapter parses the XML data into rows. You can also customize the schemas detected based on the connection string.

  • RowScanDepth: This property determines the number of rows that will be scanned to detect column data types when generating table metadata.
  • XPath: Explicitly specify the paths to nested object arrays, instead of detecting them during the row scan.
  • GenerateSchemaFiles: This property enables you to persist table metadata in static schema files that are easy to customize, to persist your changes to column data types, for example. Set this property to "OnStart" to generate schema files for all tables in your database at connection. Or, set this property to "OnUse" to generate schemas as you execute SELECT queries to tables. The resulting schemas are based on the connection properties you use to configure Automatic Schema Discovery.

    To use the resulting schema files, set the Location property to the folder containing the schemas. See Customizing Schemas for more information.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462