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 1. Mapping Properties
Property Characteristic
ConfigOptions 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)
CreateMap 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.

SchemaMap 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