Table of Contents

Search

  1. Preface
  2. Introduction to ODBC Connector
  3. Connections for ODBC
  4. Synchronization tasks with ODBC Connector
  5. Mappings and mapping tasks with ODBC Connector
  6. SQL ELT optimization
  7. Data type reference

ODBC Connector

ODBC Connector

Set environment variables

Set environment variables

To use Kerberos authentication to connect to DB2 or SAP Sybase ASE, you need to set the required environment variables on the Secure Agent machine.
  • setenv KRB5CCNAME <Absolute path and file name of the credentials cache file>
  • setenv KRB5_CONFIG <Absolute path of the Kerberos configuration file>\krb5.conf
After you set the environmental variables, you need to restart the Secure Agent.
Alternatively, you can add the environment variables when you create an ODBC connection with the subtype as
DB2
or
SAP Sybase ASE
.
Enter the
KRB5_CONFIG
and
KRB5CCNAME
details in the
Kerberos Connection Properties
field in the ODBC connection.
For example, add the properties in the following format:
KRB5_CONFIG=<Absolute path of the Kerberos configuration file>\krb5.conf;KRB5CCNAME=<Absolute path of the credential cache file>/<File name>
Ensure that you separate each key-value pair with a semicolon.

0 COMMENTS

We’d like to hear from you!