skip to main content
Connection Option Descriptions : Config Options : AuditColumns (Config Option)
  

Try DataDirect Drivers Now

AuditColumns (Config Option)

Attribute

AuditColumns

Purpose

Determines whether the driver includes audit fields, which Salesforce adds to all objects defined in a Salesforce instance, as table columns when it defines the remote data model to relational table mapping.
The audit columns added by Salesforce are:
*IsDeleted
*CreatedById
*CreatedDate
*LastModifiedById
*LastModifiedDate
*SystemModstamp

Valid Values

All | AuditOnly | MasterOnly | None
The value for this option is specified as a key=value pair in the Config Options field. See "Config Options" for details.

Behavior

If set to All, the driver includes the all of the audit columns and the master record id column in its table definitions.
If set to AuditOnly, the driver adds only the audit columns in its table definitions.
If set to MasterOnly, the driver adds only the MasterRecordId column in its table definitions.
If set to None, the driver does not add the audit columns or the MasterRecordId column in its table definitions.

Default

All

Notes

*In a typical Salesforce instance, not all users are granted access to the Audit or MasterRecordId columns. If AuditColumns is set to a value other than None and the driver cannot include the columns requested, the connection fails and the driver generates a SQLException with a SQLState of 08001.

GUI Tab

The value for config options are specified in the Config Options field on the Advanced tab.

See also

Config Options