The following connection option descriptions are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name.

In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.

Also, a few connection string attributes, for example, Password, do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.

Note: The driver does not support specifying values for the same connection option multiple times in a connection string or DSN. If a value is specified using the same attribute multiple times or using both long and short attributes, the connection may fail or the driver may not behave as intended.

The following table lists the connection string attributes supported by the Salesforce driver.

Table 1. Salesforce Attribute Names
Attribute (Short Name) Default
AccessToken (AT) None
ApplyToLabel (ATL) 0 (Disabled)
Authentication Method (AM) USERIDPASSWORD
BulkFetchThreshold (BFT) 30000 (rows)
BulkLoadAsync (BLA) 0 (Disabled)
BulkLoadBatchSize (BLBS) 1024
BulkLoadConcurrencyMode (BLCM) 1 (Parallel)
BulkLoadJobSize (BLJS) 150000
BulkLoadPollInterval (BLPI) 10
BulkLoadThreshold (BLTH) 4000 (rows)
BulkLoadVersion (BLV) V1
ClaimsIssuer (CLISS) None
ClaimsSubject (CLSUB) None
ClientID (CI) None
ClientSecret (CS) None
ConfigOptions (CFGO)
Important: The configuration options have been deprecated. However, the driver will continue to support them until the next major release of the driver.
 Empty string
ConnectionReset (CR) 0 (Disabled)
CreateMap (CM) 2 (NotExist)
DataSourceName (DSN) None
Description (n/a) None
EnableBulkFetch (EBF) 1 (Enabled)
EnableBulkLoad (EBL) 1 (Enabled)
EnablePKChunking (EPKC) 1 (Enabled)
FetchSize (FS) 100
HostName (HOST) login.salesforce.com
InitializationString (IS) Empty string
JVMArgs (JVMA) For the 32-bit driver when the SQL Engine Mode is set to 2 (Direct):

-Xmx256m

For all other configurations:

-Xmx1024m
JVMClasspath (JVMC) install_dir\java\lib\sforce.jar
JWTCertAlias (JWTCA) None
JWTCertPassword (JWTCP) None
JWTCertStore (JWTCS) None
LoadBalanceTimeout (LBT) 0
LogConfigFile (LCF) Empty string
LoginTimeout (LT) 15
MaxPoolSize (MXPS) 100
MinPoolSize (MNPS) 0
Password (PWD) None
Pooling (POOL) 0 (Disabled)
ProxyHost (PXHN) Empty string
ProxyPassword (PXPW) Empty string
ProxyPort (PXPT) Empty string
ProxyUser (PXUN) Empty string
ReadOnly (RO) 0 (Disabled)
RefreshSchema (RS) 0 (Disabled)
RefreshToken (RT) None
ReportCodepageConversionErrors (RCCE) 0 (Ignore Errors)
SchemaMap (SMP) For Windows:
  • User Data Source:

    user_profile\AppData\Local\Progress\DataDirect\ Salesforce_Schema\user_name.config

  • System Data Source:

    C:\Users\Default\AppData\Local\Progress\ DataDirect\Salesforce_Schema\user_name.config

For UNIX/Linux:

~/progress/datadirect/salesforce_schema/ LogonID.config
SecurityToken (STK) Empty string
ServerPortNumber (SPN) For the 32-bit driver:

19938

For the 64-bit driver:

19937
StmtCallLimit (SCL) 100
StmtCallLimitBehavior (SCLB) 1 (ErrorAlways)
SQLEngineMode (SEM) For Windows:

0 (Auto)

For UNIX/Linux:

The SQL engine runs in Direct mode by default.

TransactionMode (TM) 0 (No Transactions)
WSFetchSize (WSFS) 0
WSPoolSize (WSPS) 1
WSRetryCount (WSRC) 0
WSTimeout (WST) 120

This section includes the following topics: