skip to main content
Connection Option Descriptions
  

Try DataDirect Drivers Now

Connection Option Descriptions

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.
The following table lists the connection string attributes supported by the Salesforce driver.
Table 18. Salesforce Attribute Names
Attribute (Short Name)
Default
None
1 (Enabled)
USERIDPASSWORD
30000 (rows)
0 (Disabled)
1024
1 (Parallel)
None
10
None
4000 (rows)
0
None
None
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
0 (Disabled)
Note: The CreateDB option has been replaced by CreateMap.
None
2 (NotExist)
None
Note: The Database option has been replaced by SchemaMap.
None
None
1 (Enabled)
1 (Enabled)
100
login.salesforce.com
IANAAppCodePage UNIX ONLY
4 (ISO 8559-1 Latin-1)
Empty string
For the 32-bit driver when the SQL Engine Mode is set to 2 (Direct):
-Xmx256m
For all other configurations:
-Xmx1024m
install_dir\java\lib\sforce.jar
0
Empty string
15
Note: Support for the LogonDomain connection option has been deprecated. The full user name, including the domain, is now specified using the User Name option.
None
None
100
0
None
0 (Disabled)
Empty string
Empty string
Empty string
Empty string
0 (Disabled)
Note: Support for the RefeshDirtyCache option has been deprecated.
NA
0 (Disabled)
None
0 (Ignore Errors)
For Windows:
application_data_folder\Local\Progress\DataDirect\Salesforce Schema\user_name.config
For UNIX/Linux:
~/progress/datadirect/salesforce_schema/logonid.config
Empty string
For the 32-bit driver:
19938
For the 64-bit driver:
19937
For Windows:
0 (Auto)
For UNIX/Linux:
The SQL engine runs in Direct mode by default.
100
1 (ErrorAlways)
0 (No Transactions)
0
1
0
120
This section includes the following topics:
* Access Token
* Application Using Threads
* Authentication Method
* Bulk Fetch Threshold
* Bulk Load Asynchronous
* Bulk Load Batch Size
* Bulk Load Concurrency Mode
* Bulk Load Poll Interval
* Bulk Load Threshold
* Bulk Load Timeout
* Client ID
* Client Secret
* Config Options
* Connection Pooling
* Connection Reset
* Create Database
* Create Map
* Data Source Name
* Database
* Description
* Enable Bulk Fetch
* Enable Bulk Load
* Enable Primary Key Chunking
* Fetch Size
* Field Delimiter
* Host Name
* IANAAppCodePage
* Initialization String
* JVM Arguments
* JVM Classpath
* LoadBalance Timeout
* Log Config File
* Login Timeout
* Logon Domain
* Max Pool Size
* Min Pool Size
* Password
* Primary Key Chunk Size
* Proxy Host
* Proxy Password
* Proxy Port
* Proxy User
* Read Only
* Record Delimiter
* Refresh Dirty Cache
* Refresh Schema
* Refresh Token
* Report Codepage Conversion Errors
* Schema Map
* Security Token
* Server Port Number
* SQL Engine Mode
* Statement Call Limit
* Statement Call Limit Behavior
* Transaction Mode
* User Name
* WSFetch Size
* WSPoolSize
* WSRetry Count
* WSTimeout