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

Host

The name of the server running TDV Server.

Port

The port of the TDV server.

Domain

The TDV domain to which the DataSource belongs.

DataSource

The name of the TDV data source.

User

The username provided for authentication with TDV Server.

Password

The user's password.

Encrypt

Specifies whether to encrypt the connection using SSL.

SSO

The single-sign-on (SSO) type to use to authenticate.

UserTokens

Authentication values that can be packaged for delivery.

Kerberos

Property

Description

KerberosKDC

The Kerberos Key Distribution Center (KDC) service used to authenticate the user.

KerberosRealm

The Kerberos Realm used to authenticate the user with.

KerberosSPN

The Service Principal Name for the Kerberos Domain Controller.

UsePlatformKerberosAPI

This setting determines if the platform's Kerberos API is used.

 

SSL

Property

Description

SSLClientCert

The TLS/SSL client certificate store for SSL Client Authentication (2-way SSL).

SSLClientCertType

The type of key store containing the TLS/SSL client certificate.

SSLClientCertPassword

The password for the TLS/SSL client certificate.

SSLClientCertSubject

The subject of the TLS/SSL client certificate.

SSLServerCert

The certificate to be accepted from the server when connecting using TLS/SSL.

Logging

Property

Description

Logfile

A filepath which designates the name and location of the log file.

Verbosity

The verbosity level that determines the amount of detail included in the log file.

LogModules

Core modules to be included in the log file.

MaxLogFileSize

A string specifying the maximum size in bytes for a log file (for example, 10 MB).

MaxLogFileCount

A string specifying the maximum file count of log files.

 

Schema

Property

Description

Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.

BrowsableSchemas

This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.

Tables

This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.

Views

Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Miscellaneous

Property

Description

Alternate Security Credentials

Uses the URL to set an alternate security credentials value for client authorization when using TDV with a client restricted license.

Case Sensitive

Specifies case sensitivity in the request values.

Catalog

The name of the catalog to use.

Commit Failure

Specifies the behavior if a commit fails.

Commit Interrupt

Specifies the behavior if a commit is interrupted.

Compensate

The correcting behavior.

Connect Timeout

The time-out for initial connection, in seconds.

Default Catalog

The default catalog for a specified connection.

Default Schema

The default schema for a specified connection.

Enable Flood

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.

Enable Reconnect On Error

Specifies cluster reconnection behavior.

Fetch Bytes

The maximum number of rows to fetch for a batch based on batch size, in bytes.

Fetch Rows

Maximum number of rows to fetch for a batch.

Ignore Trailing Spaces

Specifies whether to ignore trailing spaces at the end of values.

Locale

Value that defines the user's language and country.

Max Rows

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.

No Metadata

Blocks return of result-set metadata during query execution.

Optimization Prepare

Specifies whether to optimize prepare requests sent to TDV.

Other

These hidden properties are used only in specific use cases.

Param Mode

Controls the behavior of OUT parameters for stored procedures.

Query Passthrough

This option passes the query to the TDV server as is.

Readonly

You can use this property to enforce read-only access to TDV from the provider.

Register Output Cursors

Specifies how to handle output cursors.

Request Timeout

The time-out for query commands and other requests, in seconds.

Session Timeout

Session inactivity time-out, in seconds.

Session Token

Uses the URL to set a session token value for client authorization when using TDV with a client restricted license.

Strip Duplicates

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.

Strip Trailing Zeros

Determines whether decimal result values are to be returned with trailing zeroes removed.

Trace Folder

The absolute directory to save the trace file.

Trace Level

The level of information to log.

Validate Remote Cert

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

EnableFastExec

Specifies whether to enable fast execution of queries.