Custom Fields and Objects
Schemas for standard Oracle Sales Cloud tables are internally stored in CData JDBC Driver for Oracle Sales Cloud and used to minimize the amount of sent requests and payload received. By default, CData JDBC Driver for Oracle Sales Cloud will use these tables and not expose any of your instance's custom fields or objects.
The CData JDBC Driver for Oracle Sales Cloud supports dynamically retrieving schemas for custom fields and objects from within your Oracle Sales Cloud specific instance following the steps described below.
Including Custom Fields
In case your schema needs to include custom fields (columns) added to Oracle Sales Cloud standard objects (tables), you can use the IncludeCustomFields connection property. Setting this property to true will result in one or more extra calls being issued and will affect CData JDBC Driver for Oracle Sales Cloud behavior in the following ways:
- Custom fields will be retrieved and listed along with the rest of the columns in your schema.
- All internally stored columns will be replaced with dynamically generated columns based on the latest API version.
Including Custom Objects
In case you need to access custom objects (tables), created to your Oracle Sales Cloud instance, you can use the IncludeCustomObjects connection property. By default, this property is set to false, and when queries are attempted on custom objects, they will fail to execute due to the internal schema being used. Similarly to IncludeCustomFields, setting this property to true, will issue one or more extra requests.
Generating Schema Files
If you need to regularly work with custom fields and/or custom objects, you can use the GenerateSchemaFiles connection property to store locally a dynamically generated schema and avoid constantly using IncludeCustomFields and IncludeCustomObjects, which in return will decrease execution time and payload.
Note: Setting GenerateSchemaFiles=OnStart/OnUse alone, will only generate a schema containing custom fields for all standard tables but not any custom tables. Using GenerateSchemaFiles combined with IncludeCustomObjects enables you to generate a schema containing both custom fields and objects.