AuditColumns (Configuration Option)
- Last Updated: May 25, 2018
- 1 minute read
- DataDirect Connectors
- JDBC
- Salesforce 6.0
- Documentation
Purpose
Determines whether the driver includes audit fields, which Salesforce adds to all objects defined in a Salesforce instance, as table columns when mapping the Salesforce data model.
The audit columns added by Salesforce are:
- IsDeleted
- CreatedById
- CreatedDate
- LastModifiedById
- LastModifiedDate
- SystemModstamp
Valid Values
all | auditOnly |
masterOnly | none
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.
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.
Default
all