Part 4: The Connect XE Drivers : The Salesforce Driver : Connection Option Descriptions : Config Options

Config Options
Attribute
ConfigOptions (CO)
Purpose
Determines how the embedded database and the mapping of the remote data model to the relational data model is configured, customized, and updated.
Notes
Valid Values
{ key = value [; key = value ]}
where:
key
is one of the following values: AuditColumns, CustomSuffix, LocalTables, MapSystemColumnNames, NumberFieldMapping, PersistMetadata, or UppercaseIdentifiers.
The value is a set of key value pairs separated by a semicolon (;). The value must be enclosed in curly brackets. For example:
{AuditColumns=AuditOnly;UppercaseIdentifiers=false}
AuditColumns: Determines whether the driver includes audit fields, which Salesforce adds to all objects defined in a Salesforce instance, as table columns when it defines the remote data model to relational table mapping.
The audit columns added by Salesforce are:
IsDeleted
CreatedById
CreatedDate
LastModifiedById
LastModifiedDate
SystemModestamp
Salesforce also adds the field MasterRecordId.
Valid values for AuditColumns are:
The default value for AuditColumns is None.
In a typical Salesforce instance, not all users are granted access to the Audit or MasterRecordId columns. If AuditColumns is set to a value other than None and the driver cannot include the columns requested, the connection fails and the driver generates a SQLException with a SQLState of 08001.
CustomSuffix (Custom objects and fields only): Determines whether the driver includes or strips the "__c" suffix from the table and column names when mapping the remote data model to the relational data model. Salesforce adds the suffix to all custom objects and fields.
Valid values for CustomSuffix are:
The default value for CustomSuffix is Strip.
KeywordConflictSuffix: Specifies a string of up to five alphanumeric characters that the driver appends to any object or field name that conflicts with a SQL engine keyword. For example, if you specify KeywordConflictSuffix=TAB, then the driver maps the Case object in Salesforce to CASETAB.
Do not use a string that matches the suffix of a custom table, for example, CASEOFICE. If you specify KeywordConflictSuffix=OFICE, a name collision occurs with the Standard object CASE and the custom table CASEOFICE, or a table with a column called CASEOFICE. In this situation, the standard object CASE is returned. The custom object is ignored.
Valid values for KeywordConflictSuffix are:
The default value for KeywordConflictSuffix is an empty string.
MapSystemColumnNames: Determines how the driver maps Salesforce system columns. Valid values for MapSystemColumnNames are:
Field Name Mapped Name
The default value for MapSystemColumnNames is 1.
NumberFieldMapping: Defines how the driver maps fields defined as NUMBER in Salesforce. The Salesforce API uses DOUBLE values to transfer data to and from NUMBER fields, which can cause problems when the precision of the NUMBER field is greater than the precision of a DOUBLE value. Rounding can occur when converting large values to and from DOUBLE. By default, the driver maps smaller fields (precision of 9 or less) to the INTEGER SQL type when the scale of the NUMBER field is 0 and maps all other NUMBER fields to the DOUBLE SQL type to match the type that Salesforce transfers the value to or from the driver. This key can be used to direct the driver to map all NUMBER fields to DOUBLE regardless of the precision of the field.
Valid values for NumberFieldMapping are:
The default value for NumberFieldMapping is 1.
UppercaseIdentifiers: Defines how the driver maps identifiers. By default, the driver maps all identifier names to uppercase.
Notes
Valid values for UppercaseIdentifiers are:
The default value for UppercaseIdentifiers is true.
Default
AuditColumns=none;CustomSuffix=strip;KeywordConflictSuffix=;
MapSystemColumnNames=1;NumberFieldMapping=1;PersistMetadata=true;
UppercaseIdentifiers=true;
GUI Tab
Advanced tab

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.