skip to main content
Using the driver : Using Connection Properties : Mapping Properties
  

Try DataDirect Drivers Now

Mapping Properties

The following table summarizes connection properties involved in mapping the remote Salesforce data model to a local schema map used to support SQL queries against Salesforce.
Table 4. Mapping Properties
Property
Characteristic
Determines how the mapping of the remote Salesforce data model to a local schema map can be configured, customized, and updated.
The default is:
(AuditColumns=all;CustomSuffix=include;
KeywordConflictSuffix=; MapSystemColumnNames=0;
NumberFieldMapping=emulateInteger; UppercaseIdentifiers=true)
Specifies whether the driver creates a new map of the Salesforce data model when establishing the connection.
If set to forceNew, the driver deletes the current schema map specified by the SchemaMap property and creates a new one at the same location.
If set to notExist, the driver uses the current schema map specified by the SchemaMap property. If one does not exist, the driver creates one.
If set to no, the driver uses the current schema map specified by the SchemaMap property. If one does not exist, the connection fails.
The default is notExist.
Specifies the fully qualified path of the configuration file where the map of the Salesforce data model is written. The driver looks for this file when connecting to a Salesforce instance. If the file does not exist, the driver creates one.
The default varies based on your environment:
For Windows:
application_data_folder\Local\Progress\DataDirect\SForce_Sch
ema\user_name.config
For UNIX/Linux:
~/progress/datadirect/SForce_Schema/user_name.config