Common Properties

The following table and the sections below lists and explains the connection properties that are common to all data sources:

The name of the data source.

string

""

A URL to connect to the physical data source.

String

“”

TDV does not validate modifications. The data source adapter might not validate changes. Refer to the datasource specific connection properties section for details.

The login name used to authenticate the data source connection,

string

“”

None

The password used to authenticate the data source connection,

string

""

Flag to indicate whether pass-through login is enabled or not.

string

""

Disabled (default)—This allows automated provisioning of a connection pool. Open connection threads can be used by authorized users after the validation query verifies connection status. If pass-through login is disabled, the Save Password check box is not available.

Enabled—A new connection to the data source uses the credentials supplied by the client when data is requested from that data source for the first time. Subsequent requests by the same user reuse the existing connection. When another user attempts to connect to a data source, a new connection is created.

See “Managing Security for TDV Resources” in the TDV Administration Guide for details.

Indicates the type of authentication used by the data source.

String

BASIC

Following are the available Authetication types:

BASIC

KERBEROS

NTLM

NEGOTIATE

See the TDV Administration Guide for more information about Kerberos authentication.

The degree to which transactions are isolated from data modifications made by other transactions.

string

NONE

Valid values are:

Lets you specify property-value pairs to pass to the data source. For example:

String

“”

Maximum number of connections (both active and idle) allowed for the data source. When the maximum is reached, new requests must wait until a connection is available.

Numeric

100

If the maximum number of connections is in use when a request comes in (even with pass-through authentication), the new request is blocked and queued until a connection is available or the Connection Pool Idle Timeout is reached.

If no connection was made available within the specified timeout, a check is made for an available connection by the same user. If none is available, the least recently used connection for another user is dropped and a new connection is opened.

Studio reuses pooled connections if they continue to be valid after changes (such as connection name), but JDBC requests are forced to use new connections if any part of the data source connection configuration has changed.

Minimum number of connections in the pool even when the pool is inactive.

Numeric

0

When a connection has been idle, a validation query is used to verify whether an open connection is still valid just prior to submission of a request. If the connection is invalid, the connection is discarded and another is used.

Number of seconds that a connection can remain idle without being dropped from the pool when there are more than the minimum number of connections.

Numeric

30

The number of minutes that a connection that was returned to the pool persists if there are more open connections than the minimum pool size.

Numeric

30

The duration is calculated from connection creation. Default value is 60 minutes. Set a smaller value if the pool is likely to run out of connections. Be sure to add a validation query. Set a larger value if you want the connections to be held for a longer period. Set a value of 0 to keep connections alive indefinitely.

A data-source-specific query that the TDV query engine sends to see if the data source connection is valid. This query is executed every time a connection is checked out from the pool. Enter a query that returns quickly.

string

""

If this query returns a non-error result, the data source connection is considered valid. If this query fails, the connection is discarded and a new connection is checked out from the available pool.

No one SELECT statement works with all data sources. To verify that TDV is running and that it can connect to the data source, devise a query against a published table from that data source.

The number of seconds an execution query on the data source can run before being canceled.

Numeric

0

None

Lets a SELECT statement be executed using a new connection from the connection pool, and committed immediately after completion. INSERT and UPDATE, statements are executed using the same connection as part of the transaction.

Bool

True

None

A procedure that returns a valid SQL statement that can be used to initialize the connection.

string

""

The signature of the initialization procedure should be:

Give the full path to the procedure in the Connection Check-out Procedure box.

Time that a connection doing a checkout can remain idle without being dropped.

Numeric

45

None

Following flags can be used to manage the rules of the string comparison.

Data source Name	The name of the data source.
Complete Connection URL String	A URL to connect to the physical data source.
Login	User name and password required to access the data source. When the data source is used as a target for cache tables or data ship, the user must also have permission to create tables, execute DDL, and perform other required tasks. Refer to the individual data source descriptions for details.
Pass-through Login	Flag to indicate whether pass-through login is enabled or not.
Authentication Type	The type of authentication used by the data source.

Transaction Isolation	The degree to which transactions are isolated from data modifications made by other transactions.
Connection Attributes
Connection Pool Maximum Size	Maximum number of connections (both active and idle) allowed for the data source. When the maximum is reached, new requests must wait until a connection is available.
Connection Pool Minimum Size	Minimum number of connections in the pool even when the pool is inactive.
Connection Pool Idle Timeout	Number of seconds that a connection can remain idle without being dropped from the pool when there are more than the minimum number of connections.
Maximum Connection Lifetime	The number of minutes that a connection that was returned to the pool persists if there are more open connections than the minimum pool size.
Connection Validation Query	A data-source-specific query that the TDV query engine sends to see if the data source connection is valid. This query is executed every time a connection is checked out from the pool. Enter a query that returns quickly.
Data source driver doesn’t support query timeout	Select or clear the check box. If cleared, specify an Execution timeout value in seconds
Execution Timeout	The number of seconds an execution query on the data source can run before being canceled.
Execute SELECTs in separate transactions from INSERTs and UPDATEs	Lets a SELECT statement be executed using a new connection from the connection pool, and committed immediately after completion. INSERT and UPDATE, statements are executed using the same connection as part of the transaction.
Connection Checkout Procedure	A procedure that returns a valid SQL statement that can be used to initialize the connection.
Connection Checkout Timeout	Time that a connection doing a checkout can remain idle without being dropped.
String Comparison Parameters	Multiple Parameters that can be set to control String manipulation by the data source.

Case sensitivity mismatch between TDV and data source can be ignored	Check to ignore case mismatches.
Ignore trailing space mismatches between TDV and the data source	Check to ignore trailing spaces.
Honor trailing spaces for string comparison	Check to honor trailing spaces.
Case insensitive string comparison	Ignore case.