Generic JDBC Security Guidelines | Teradata QueryGrid - Generic JDBC Connector Security Guidelines - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.19
Published
July 2022
Language
English (United States)
Last Update
2022-07-28
dita:mapPath
jpf1654813554544.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem

Authentication

The Generic JDBC connector supports basic database user and password based authentication and Kerberos security mechanisms. Set authentication details in the Generic JDBC Connector and Link Properties.

DB User

Use the following property settings for the Generic JDBC target connector using the DB User authentication.
Setting Description
Authentication Mechanism Set to DB User.
Username [Optional] Set to the authorized username.
Password [Optional] Set the password for the authorized user.

Kerberos

Use the following property settings for Generic JDBC connector using the Kerberos security model.
Setting Description
Authentication Mechanism Set to Kerberos.
Username [Optional] Set to the Kerberos principal name.
Password [Optional] Set to the password for the Kerberos principal name.
Keytab Set to the absolute path to the Kerberos Keytab file.
If both password and keytab are provided, the password takes precedence over the keytab authentication. If the target database requires any additional Kerberos properties, the same can be passed in the JDBC URL. See Generic JDBC Connector and Link Properties for additional information.