Client Interfaces Guide > TIBCO SSIS Components for TDV > Connection Properties
 
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.
A path to the directory that contains the schema files defining tables, views, and stored procedures.
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.
Other
Property
Description
Specifies whether to enable fast execution of queries.