2.06 - Oracle Connector and Link Properties - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty
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

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