JDBC Driver for Salesforce

Build 22.0.8462

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.


PropertyDescription
AllOrNoneA boolean indicating if you would like all inserts, updates, or deletes to fail in a request if even a single record fails.
ArchiveModeBoolean indicating whether to include deleted and archived records with a standard SELECT query.
ConnectionLifeTimeThe maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.
ConnectOnOpenThis property specifies whether to connect to the Salesforce when the connection is opened.
ContinueOnAlterExceptionWhether you want to continue after a ALTER statement has failed.
ExposeConceptualEntitiesBoolean determining if the Salesforce record types / conceptual entities should be exposed as tables.
FilterScopeOptional scope to limit the records returned from queries.
IncludeMetadataDescriptionSet this property to a value other than NONE if you want to retrieve the descriptions for columns, tables or both of them from the Metadata API.
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
OtherThese hidden properties are used only in specific use cases.
PoolIdleTimeoutThe allowed idle time for a connection before it is closed.
PoolMaxSizeThe maximum connections in the pool.
PoolMinSizeThe minimum number of connections in the pool.
PoolWaitTimeThe max seconds to wait for an available connection.
PseudoColumnsThis property indicates whether or not to include pseudo columns as columns to the table.
QueryPassthroughWhether to accept SOQL queries.
ReadonlyYou can use this property to enforce read-only access to Salesforce from the provider.
RemoveBOMCharacterSpecifies whether to remove the BOM character (char)0xfeff from the content.
ReplaceInvalidUTF8CharsSpecifies whether to replace invalid UTF8 characters with a '?'.
RTKThe runtime key used for licensing.
ServerSideAggregationA boolean determining if server side aggregation should be used.
SessionTimeoutThe time in minutes for which a Salesforce login session is reused.
SkipFormulaFieldsSet to true if formula fields should be skipped when listing columns.
SortColumnsSet to true to sort table columns instead of reporting them in the Salesforce order.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseConnectionPoolingThis property enables connection pooling.
UseDisplayNamesBoolean determining if the display names for the columns should be used instead of the API names.
UserDefinedViewsA filepath pointing to the JSON configuration file containing your custom views.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462