The driver automatically maps Salesforce objects and fields to tables and columns the first time it connects to a Salesforce instance. The driver maps both standard and custom objects and includes any relationships defined between objects. You can use the SQLForeignKeys and SQLPrimaryKeys functions to report relationships among objects.
Schema Map
The driver uses a local schema map to instantiate the mapping of the remote Salesforce data model as tables and the metadata associated with those tables. By default, the driver creates a schema map for each user. The schema map is created in each user's application data folder and uses the user ID specified for the connection as the name of the schema map file. If the user ID contains punctuation or other non-alphanumeric characters, the driver strips those characters from the user ID to form the name of the schema map file. The driver includes a SchemaMap connection option that allows you to override the default setting for the name and location of the schema map file.
Identifiers
When mapping the remote data model, the driver converts unquoted identifiers to uppercase by default. You can use the UppercaseIdentifiers configuration option to map identifiers to use the case of the remote object.
Audit Columns
Salesforce adds audit fields to all the objects defined in a Salesforce instance. By default, the driver includes corresponding audit columns in table definitions when mapping the remote data model. The AuditColumns configuration option can be used to exclude or limit audit columns.
Custom Objects and Fields
Salesforce appends custom objects and fields with a standard "__c" suffix. By default, the driver includes the standard "__c" suffix when mapping the remote data model. You can use the CustomSuffix configuration option to strip the "__c" suffix.
System Fields
Salesforce includes system fields in a Salesforce instance. By default, the driver uses the name of the system field when mapping the system fields as columns. You can use the MapSystemColumnNames configuration option to make it evident that the columns in a table correspond to system fields.
