Missing SalesForce System Columns when connected with SQL Li

For viewing Audit columns like CreatedOn, Created By, etc. you need to set Config Options connection option to AuditColumns=AuditOnly as per knowledgebase.progress.com/.../9906

The DataDirect Salesforce ODBC driver maps the system columns names. If you would like the driver to not map the system column names, you need to set Config Options connection option to MapSystemColumnNames=0 as per knowledgebase.progress.com/.../000031259.

After making any data source changes, ensure that you set Create Database=1 - Force New and make a test connection and then switch back to the default setting for Create Database so that the new changes take effect or you will get an error that the configuration options do not match as per  knowledgebase.progress.com/.../000032070

Stop and restart any application that is using the ODBC driver for the data source changes to take effect.

For adding mutilple values to the Config Option connection option, separate the values by a semicolon as AuditColumns=AuditOnly;MapSystemColumnNames=0

You can also find this information in the User's Guide documentation under Part 4: The Connect XE Drivers : The Salesforce Driver : Connection Option Descriptions : Config Options at www.progress.com/.../books-and-readme-file

Regards,

Rashmi

Thanks Rashmi that helped. As per the document I was thinking the default value for AuditColumns is All but after specifying the configuration explicitly it returned all columns including system columns.

After export we noticed few fields are missing on Opportunity Line Items & Quote Line Items.

ProductId is missing on Quote Line Items & ProductCode is missing on Opportunity Line Items. Is there any configuration option we have specify in order to get all the columns.

Here is our current configuration.

AuditColumns=All;MapSystemColumnNames=0;CustomSuffix=Include;PersistMetadata=true;