Client Interfaces Guide > TIBCO SSIS Components for TDV > Miscellaneous
 
Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
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.
Authentication values that can be packaged for delivery.
Values are true or false. Default value is false. If true, the client will validate the server's cert.
Values are true or false. Default value is false. If true, the client will validate the server's hostname.