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.

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. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. Make sure that the Use External Credentials check box is cleared. If that check box is selected, then the User and Password fields are not available, and the connector uses Kerberos authentication instead.
  3. In the User field, type your user name for accessing the Oracle database.
  4. In the Password field, type the password corresponding to the user name you typed above.
  5. To save your settings and close the dialog box, click OK.

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:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. Select the Use External Credentials check box.
  3. To save your settings and close the dialog box, click OK.