Connection Properties
The connection properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection settings for this provider. Click the links for further details.
For more information on establishing a connection, see Establishing a Connection.
Authentication
Property |
Description |
The name of the server running TDV Server. |
|
The port of the TDV server. |
|
The TDV domain to which the DataSource belongs. |
|
The name of the TDV data source. |
|
The username provided for authentication with TDV Server. |
|
The user's password. |
|
Specifies whether to encrypt the connection using SSL. |
|
The single-sign-on (SSO) type to use to authenticate. |
|
Authentication values that can be packaged for delivery. |
Kerberos
Property |
Description |
The Kerberos Key Distribution Center (KDC) service used to authenticate the user. |
|
The Kerberos Realm used to authenticate the user with. |
|
The Service Principal Name for the Kerberos Domain Controller. |
|
This setting determines if the platform's Kerberos API is used. |
SSL
Property |
Description |
The TLS/SSL client certificate store for SSL Client Authentication (2-way SSL). |
|
The type of key store containing the TLS/SSL client certificate. |
|
The password for the TLS/SSL client certificate. |
|
The subject of the TLS/SSL client certificate. |
|
The certificate to be accepted from the server when connecting using TLS/SSL. |
Logging
Property |
Description |
A filepath which designates the name and location of the log file. |
|
The verbosity level that determines the amount of detail included in the log file. |
|
Core modules to be included in the log file. |
|
A string specifying the maximum size in bytes for a log file (for example, 10 MB). |
|
A string specifying the maximum file count of log files. |
Schema
Property |
Description |
A path to the directory that contains the schema files defining tables, views, and stored procedures. |
|
This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC. |
|
This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC. |
|
Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC. |
Miscellaneous
Property |
Description |
Uses the URL to set an alternate security credentials value for client authorization when using TDV with a client restricted license. |
|
Specifies case sensitivity in the request values. |
|
The name of the catalog to use. |
|
Specifies the behavior if a commit fails. |
|
Specifies the behavior if a commit is interrupted. |
|
The correcting behavior. |
|
The time-out for initial connection, in seconds. |
|
The default catalog for a specified connection. |
|
The default schema for a specified connection. |
|
Values are true or false. Default value is true. If true, the server will constantly send data, filling the network buffer.Useful for larger result sets. |
|
Specifies cluster reconnection behavior. |
|
The maximum number of rows to fetch for a batch based on batch size, in bytes. |
|
Maximum number of rows to fetch for a batch. |
|
Specifies whether to ignore trailing spaces at the end of values. |
|
Value that defines the user's language and country. |
|
Limits 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. |
|
Blocks return of result-set metadata during query execution. |
|
Specifies whether to optimize prepare requests sent to TDV. |
|
These hidden properties are used only in specific use cases. |
|
Controls the behavior of OUT parameters for stored procedures. |
|
This option passes the query to the TDV server as is. |
|
You can use this property to enforce read-only access to TDV from the provider. |
|
Specifies how to handle output cursors. |
|
The time-out for query commands and other requests, in seconds. |
|
Session inactivity time-out, in seconds. |
|
Uses the URL to set a session token value for client authorization when using TDV with a client restricted license. |
|
Values are true or false. Default value is true. If true, the server will detect duplicate CHAR/VARCHAR columns in subsequent rows, and will not re-transmit the data across the wire. |
|
Determines whether decimal result values are to be returned with trailing zeroes removed. |
|
The absolute directory to save the trace file. |
|
The level of information to log. |
|
The username provided for authentication with TDV Server. |
|
Validate Remote Hostname | Values are true or false. Default value is false. If true, the client will validate the server's hostname. |
Other
Property |
Description |
Specifies whether to enable fast execution of queries. |