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.
Use the following property settings for the Generic JDBC target connector using the DB User authentication.
|Authentication Mechanism||Set to DB User.|
|Username||[Optional] Set to the authorized username.|
|Password||[Optional] Set the password for the authorized user.|
Use the following property settings for Generic JDBC connector using the Kerberos security model.
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.
|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.|