2.10 - Oracle Connector and Link Properties - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K
When you create links and associated properties in the QueryGrid portlet, you are creating Configuration Name Value Pairs (NVP). NVP does the following:
  • 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.

Important: The Oracle connector is only available as a target connector.
Name Default Description Overridable?

Property Name

Authentication Mechanism DB Password

Lists the security method used on the target system.

Valid values are DB Password, OS Authentication, SSL, or Kerberos.

 
Batch Size 1000 Number of rows to insert into the database at a time. Valid values are 100–10000.

batchSize

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 32000 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 INFO

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, and DEBUG.

 
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 60000–86400000.

 
Link Heartbeat Interval 3600000 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 60000–86400000.

 
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 3 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 3600000

Number of milliseconds to wait to read between data packets when importing data messages.

Valid values are 300000–8640000.

readTimeout

Response Timeout 86400000 Number of milliseconds to wait for the final data exec response when all the data has been transferred.

Valid values are 1800000–172800000.

responseTimeout

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

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 Peer Authentication Mode None Valid values are None, Server, or Both.  
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 3600000

Number of milliseconds to wait to write between data packets when exporting data messages.

Valid values are 300000–86400000 ms.

writeTimeout