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

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
lifecycle
latest
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.