Configuring Authentication

All Oracle databases require authentication. You can configure the Simba Oracle ODBC Driver to provide your credentials and authenticate the connection to the database using one of the following methods:

Important: You cannot use the Simba Oracle ODBC Driver to connect to an Oracle Autonomous Data Warehouse instance using Kerberos authentication.

You can set the connection properties described below in a connection string or in a DSN (in the odbc.ini file). Settings in the connection string take precedence over settings in the DSN.

Using Your Oracle Database Credentials

You can configure the connector to authenticate the connection using your database credentials.

To configure authentication using your database credentials:

  1. Set the UseExternalCredentials property to false.
  2. Set the UID property to your user name for accessing the Oracle database.
  3. Set the PWD property to the password corresponding to the user name you typed above.

Using Kerberos

You can configure the connector to use the Kerberos protocol to authenticate the connection. The connector retrieves and uses a Kerberos ticket based on the settings in the sqlnet.ora configuration file.

Before you can use this authentication mechanism, you must specify the necessary Kerberos settings in the sqlnet.ora file, and set the TNS_ADMIN environment variable on your machine to point to the path of the sqlnet.ora file. For more information, see the following:

To configure Kerberos authentication:

  • Set the UseExternalCredentials property to true.