Administrator
- Administrator
- All Products
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 run 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
| The size of each data block, in bytes, that the Teradata PT API reads from the Teradata
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 about the block size, 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. If you add multiple properties, make sure to separate
each property with a comma. For example,
tmode=ANSI,JAASCONFIG=<path to
JAASCONFIG>/TeraJDBC.config. The following snippet is
an example of JAASCONFIG with mandatory
attributes:
|
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.
|