The following tables describe the connection properties by functionality.

Authentication properties

The following table summarizes connection properties related to authentication.

Property Default
User No default value
Password No default value
SecurityToken No default value

Mapping properties

The following table summarizes connection properties involved in mapping the Salesforce data model to a SQL model.

Property Default
AuditColumns all
CustomSuffix include
KeywordConflictSuffix No default value
MapSystemColumnNames 0 (no changes to column names)
NumberFieldMapping emulateInteger
UppercaseIdentifiers true (identifiers mapped to uppercase)

Bulk fetch properties

The following table summarizes connection properties related to support for the Salesforce Bulk API.

Property Default
BulkFetchThreshold 30000 (rows)
EnableBulkFetch true
EnablePKChunking true
PKChunkSize 100000 (rows)

Web service properties

The following table summarizes Web service connection properties.

Property Default
FetchSize 100 (rows)
StmtCallLimit 100 (Web service calls)
StmtCallLimitBehavior errorAlways
WSFetchSize 0 (maximum of 2000 rows)
WSRetryCount 0 (no retries for timed-out requests)
WSTimeout 120 (seconds)

Additional properties

The following table summarizes additional connection properties.

Property Default
ReadOnly false
ServerName login.salesforce.com