Part 4: The Connect XE Drivers : The Salesforce Driver : Using DataDirect Bulk Load With the Salesforce Driver : Using Column Mapping

Using Column Mapping
The Salesforce driver can use the DataDirect functions LoadTableFromFile (for an ANSI application) and LoadTablefromFileW (for a Unicode application) to support mapping of the column names defined in the input file to columns defined in the Salesforce table.
To take advantage of this feature, create a list of columns that are not auto-generated by Salesforce and specify a string argument of the format:
TableName(ColumnName[,ColumnName[,ColumnName]...])
for the TableName parameter of the LoadTableFromFile(W) function.
By default, the driver requires a one-to-one mapping of the columns defined in the input file to the columns defined in the Salesforce table. Because Salesforce tables contain several auto-generated key columns, it is not possible to achieve the required one-to-one mapping. Use only columns that were not auto-generated in the column list for which the data file defines the data that you want to load.
Refer to "DataDirect Bulk Load" in the DataDirect Connect Series for ODBC Reference for details.

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