skip to main content
Connection option descriptions
  

Try DataDirect Drivers Now

Connection option descriptions

The connection option descriptions in this section 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 the option topics.
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 following tables 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 by their attribute names.
The following tables provide a summary of supported connection options by functionality, including their attribute names, short names, and default values.
General options
OAuth 2.0 options
NTLM options
Mapping options
SQL Engine options
Proxy server options
Web service options
Timeout options
Additional Options

General options

The following table summarizes general connection options that can apply to all connections that use data sources.
Table 3. General options
Attribute (Short Name)
Default
No default value
No default value
No default value

OAuth 2.0 options

The following table summarizes options used for OAuth 2.0 authentication. The OAuth 2.0 options you must specify depend on the grant type used in your environment. If you are unsure of the grant type or its requirements, contact your system administrator. For details on supported grant types, see OAuth 2.0 authentication.
Table 4. OAuth 2.0 options
Attribute (Short Name)
Default
No default value
24 (OAuth2)
No default value
No default value
No default value
No default value
No default value
No default value
No default value

NTLM options

The following table summarizes options used for NTLM authentication.
Table 5. NTLM authentication options
Attribute (Short Name)
Default
24 (OAuth2)
No default value
No default value
No default value
No default value

Mapping options

The following table summarizes connection options involved in mapping the Dynamics 365 data model to a SQL model.
Table 6. Mapping options
Attribute (Short Name)
Default
4 (OnChange)
1 (Include)
No default value
No default value
0 (false)
Default value depends on environment

SQL engine options

The following table lists the options used to configure the SQL engine.
Table 7. SQL Engine options
Attribute (Short Name)
Default
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\dynamics365.jar
install_dir\jre\bin\java.exe
No default value
No default value
No default value
No default value
No default value
For Windows:
0 (Auto)
For Linux:
The SQL engine runs in Direct mode by default.
No default value

Proxy server options

The following table summarizes proxy server connection options.
Table 8. Proxy server options
Attribute (Short Name)
Default
No default value
No default value
0 which means that the default value is determined by whether the value specified for the Proxy Host (ProxyHost) option is an HTTP or HTTPS URL.
For HTTP: 80
For HTTPS: 443
No default value

Web service options

The following table summarizes Web service connection options, including those related to timeouts.
Table 9. Web service options
Attribute (Short Name)
Default
0 (inactive connections are kept open)
0 (the query does not time out)
0 (no limit)
1 (ErrorAlways)
0 (Compress)

Timeout options

The following table summarizes timeout connection options.
Table 10. Timeout Options
Attribute (Short Name)
Default
0 (inactive connections are kept open)
0 (the query does not time out)

Additional options

The following table summarizes additional connection options.
Table 11. Additional Options
Attribute (Short Name)
Default
1 (True)
200
0
1 (second)
No default value
100 (rows)
IANAAppCodePage (Linux only)
4 (ISO 8559-1 Latin-1)
No default value
ddlogging.properties
0 (false)
0 (Ignore Errors)
0 (NoTransactions)
This section includes the following topics:
* Access Token
* Application Using Threads
* Authorization URI
* Authentication Method
* Batch Update Chunk Size
* Client ID
* Client Secret
* Connection Retry Count
* Connection Retry Delay
* Create Map
* Custom Prefix
* Custom Prefix Name
* Data Source Name
* Description
* Extended Options
* Fetch Size
* IANAAppCodePage
* Initialization String
* JVM Arguments
* JVM Classpath
* JVM Path
* Keyword Conflict Suffix
* Log Config File
* Login Timeout
* NTLM Domain
* Password
* Proxy Host
* Proxy Password
* Proxy Port
* Proxy User
* Query Timeout
* Read Only
* Refresh Schema
* OAuth Refresh Token
* Report Codepage Conversion Errors
* Schema Map
* OAuth Scope
* Server Port Number
* Server Proxy Host
* Server Proxy Password
* Server Proxy Port
* Server Proxy User
* Service URL
* SQL Engine Mode
* SQL Service
* Statement Call Limit
* Statement Call Limit Behavior
* Token URI
* Transaction Mode
* User
* Web Service Compress Data