- Specifies the behavior of the target connector component
- Configures how data is transformed
- Configures the underlying link data transportation layer
Links are named configurations that include the target connector. If the same property is set for a link and a connector, the link setting overrides the connector setting.
| Name | Default | Description | Overridable? Property Name |
|---|---|---|---|
| Character Set | AL32UTF8 | Database character set for CHAR, VARCHAR, and CLOB. This property is available for users who do not have permission to access the dictionary views that can provide this information dynamically. The default is UTF8 if a value is not provided. |
|
| Collect Metrics | False | Collect query metrics from the Oracle Resource Manager for QueryGrid metadata and run queries. | ● collectMetrics |
| Connection Evict Frequency | 30 minutes |
Frequency of eviction checks. Connection objects from the pool are checked, closed, and removed if the idle time (current time - last time of use) of a connection object is greater than the Connection Max Idle Time setting. Reduce the time between checks if there are multiple concurrent users running queries to clear the connections more frequently. Valid values are 1–1440 minutes. |
|
| Connection Max Idle Time | 86400 seconds |
The maximum idle time for the connection cache object, after which the object is closed and removed from the cache. Use this property when there are multiple concurrent users and queries running on the system that might lead to starvation of connection objects. Valid values are 1–86400 seconds. |
|
| Connection Pool Size | 100 |
Maximum number of connection objects that can be stored in a connection pool. When acquiring a new connection, the connector checks for an available space in the pool. If no space is available in the connection pool, the connection fails after 5 minutes. Only one connection pool and username per connector configuration is allowed. Valid values are 1–10000. |
|
| Database Version | None |
The database version property is certified for Oracle database version 12.1.0.2 and later. This is a string data type and you have the option to try it with versions of Oracle that are not certified to run on QueryGrid. Use this property for internal implementations of features such as length of temporary table name when running an export clause. This property is required and available for users who do not have permission to access the dictionary views that can provide this information dynamically. |
|
| Default Binary Size | 64000 bytes | The VARBINARY truncation size. Valid values are 1–2097088000 bytes. |
● defaultBinarySize |
| Default String Size | 3200 characters | The VARCHAR truncation size. The value represents the maximum number of Unicode characters to import, and defaults to 32000 characters. Teradata QueryGrid truncates the string columns at the default value set in defaultStringSize if less than the actual column size. Valid values are 1–1048544000 characters. |
● defaultStringSize |
| Enable Logging | None |
Logging level for the connector or link properties. User level log settings can be explicitly set through the add or edit link page in the QueryGrid portlet. Valid values are NONE, WARN, INFO, DEBUG, and VERBOSE. |
|
| Encryption | None |
Encryption mechanism. Valid values are NONE, SSL, and NNE. |
|
| Fetch Size | 1000 |
Number of rows JDBC can pull from a database at a time. Valid values are 1–10000. |
● fetchSize |
| Keystore Password | None | The keystore password is applicable when SSL authentication is on the server or both the server and target system. | |
| Keystore Path | None | The keystore path is applicable when SSL authentication is on the server or both the server and target system. | |
| Keystore Type | JKS |
The keystore type is applicable when SSL authentication is on the server or both the server and target system. Valid values are JKS, PKCS12, and SSO. |
|
| Keytab | None | Absolute path for the Kerberos keytab file. | |
| Link Buffer Count | 4 | Maximum number of write buffers available on a single channel at one time. Link Buffer Count overrides the default internal fabric property shmDefaultNumMemoryBuffers.
Valid values are 2–16. |
● linkBufferCount |
| Link Handshake Timeout | 30000 | Handshake and ACK timeout in milliseconds for the shared memory channel setup. Valid values are 5000–300000. |
|
| Link Heartbeat Interval | 60000 | Maximum interval in milliseconds for the heartbeat signal on a channel between the connector and the fabric instance, used for health check status. Set this value to be greater than Link Handshake Timeout.
Valid values are 5000–300000. |
|
| NNE Encryption Level | Accepted | Encryption level for NNE. Valid values are Accepted, Rejected, Requested, and Required. |
|
| NNE Encryption Types | AES256, AES192, AES128, 3DES168, 3DES112, DES56C, DES40C, RC4_256, RC4_128, RC4_40, RC4_56 | List of the encryption algorithms used by the database instance. | |
| NNE Integrity Level | Accepted | Checksum level for data integrity (for NNE). Valid values are Accepted, Rejected, Requested, and Required. |
|
| NNE Integrity Types | sha1, md5, SHA256, SHA384, SHA512 | Checksum algorithm for data integrity validation (for NNE). | |
| Number of Transfer Threads | 1 | The number of threads used to process data at the same time during a single request. | ● transferThreads |
| Password | None | The password of the user or service account credential. Maximum length is 255 characters. |
|
| Port | 1521 | The IP port of the target host and is a required property. Valid values are 1–65535. |
|
| Preserve Case | False | Preserve the case sensitivity of object names. When set to true, database, table, role, and user names are kept in the format they are written (upper, lower, or mixed case). When set to false, all objects convert to upper case when sent to the Oracle database. | ● preserveCase |
| Read Timeout | 300000 |
Number of seconds to wait to read between data packets when importing data messages. Valid values are 1000–8640000 milliseconds. |
● readTimeout |
| Role Support | False | Enable user role support for the target system. When set to true, the user role from the initiator or target based on role mapping is applied to the target system and any errors are returned back to the user. When set to false, roles are not applied to the target system. | ● roleSupport |
| Schema Name | None |
Schema name provided in the user query. If no schema value is entered, the system adds the username as the default. |
● schemaName |
| Security | DB Password |
Lists the security method used on the target system. Valid values are DB Password, OS, Authentication, SSL, or Kerberos. |
|
| Server | None | This is the IP address or DNS name of the target host and is a required property. Cannot use multiple hostnames. | |
| SID or ServiceName | None | Name of the Oracle instance. This is a required property. | ● sid |
| SSL Authentication Mode | None | Valid values are None, Server, or Both. | |
| SSL Port | None | SSL port of the target host. | |
| SSL Server DN | None | The Server Distinguished Name to match. When SSL authentication is set to server or both, you can optionally choose to match the distinguished name in addition to the server authentication. | |
| Temporary Schema Name | None | The temporary database name for table creation. | ● tempDbName |
| Truststore Password | None | The Truststore Password is used when SSL authentication is set to Both. | |
| Truststore Path | None | The Truststore Path is used when SSL authentication is set to Both. | |
| Truststore Type | JKS |
The Truststore Type is used when SSL authentication is set to Both. Valid values are JKS, PKCS12, and SSO. |
|
| Username | None |
Name of the user or service account for Kerberos authentication. |
|
| Write Timeout | 300000 |
Number of milliseconds to wait to write between data packets when exporting data messages. Valid values are 1000–86400000 ms. |
● writeTimeout |