ConfigOptions
- Last Updated: February 24, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- Salesforce 6.0
- Documentation
Purpose
Determines how the mapping of the remote Salesforce data model to a local schema map can be configured, customized, and updated.
Notes
This property is primarily used for initial configuration of the driver for a particular user. It is not intended for use with every connection. By default, the driver configures itself and this option is normally not needed. If ConfigOptions is specified on a connection after the initial configuration, the values specified for ConfigOptions must match the values specified for the initial configuration.
Valid Values
(
key
=
value
[;
key
=
value
])
where:
- key
- is one of the following configuration options:
AuditColumnsCustomSuffixKeywordConflictSuffixMapSystemColumnNamesNumberFieldMappingUppercaseIdentifiers
- value
- specifies a setting for the configuration option.
When specifying configuration options in a connection string, key value pairs must be enclosed in parentheses and separated by a semicolon. For example:
ConfigOptions=(AuditColumns=none;CustomSuffix=strip;KeywordConflictSuffix=;
MapSystemColumnNames=1;NumberFieldMapping=emulateInteger;
UppercaseIdentifiers=true)
Data Source Method
setConfigOptions
Default
AuditColumns=all;
CustomSuffix=include;
KeywordConflictSuffix=;
MapSystemColumnNames=0;
NumberFieldMapping=emulateInteger;
UppercaseIdentifiers=true
Data Type
String