Connectors and Connections

Back Next

Advanced settings

The following table describes the advanced connection properties:

Property	Description
Tenacity	Amount of time, in hours, that the Teradata PT API continues attempting to log in again when the maximum number of operations runs on the Teradata database. Specify a positive integer. Default is 4.
Max Sessions	Maximum number of sessions allowed for the Teradata PT API to establish connection with the Teradata database. Specify a positive, non-zero integer. Default is 4.
Min Sessions	Minimum number of Teradata PT API sessions required for the Teradata PT API job to continue. Specify a positive integer between 1 and the value specified in the Max Sessions field. Default is 1.
Sleep	Amount of time, in minutes, that the Teradata PT API waits before it attempts to log in again when the maximum number of operations run on the Teradata database. Specify a positive, non-zero integer. Default is 6.
Data Encryption	Enables full security encryption of SQL requests, responses, and data. Default is disabled.
Block Size	Maximum block size, in bytes. Teradata PT API uses this property to read the data block size from source through the Export operator. Maximum is 16775168 bytes for Teradata database version 16.20 and later. If the Teradata database version is earlier than 16.20, Teradata scales down the block size from 16775168 bytes to the maximum allowed value. The block size 16775168 is not allowed in the Spool mode. For more information, see the Teradata logs and verify the Teradata documentation of the same version.
Metadata Advanced Connection Properties	The optional properties for the JDBC driver to fetch the metadata from Teradata. For example, tmode=ANSI.
Enable Metadata Quotification	Determines if a Teradata connection reads reserved words used in table or column names from the Teradata database. Select the Enable Metadata Quotification checkbox for the Secure Agent to read reserved words from Teradata.