Using Token-based Authentication

Token-based authentication is used to interactively authenticate the connection for a single session.

When you initiate a connection using token-based authentication, the connector attempts to open a web browser. You may be prompted to type your credentials in the browser.

The following instructions describe how to configure advanced options in a DSN and in the connector configuration tool. You can specify the connection settings described below in a DSN, in a connection string, or as connector-wide settings. Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.

To configure authentication using token-based authentication:

  1. Choose one:
    • To configure authentication for a DSN, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click DFI Options.
    • Or, to configure authentication for a DSN-less connection, open the Simba Spark ODBC Driver Configuration tool, and then click DFI Options.
  2. Set the OCI Config File field to a path that does not contain an OCI configuration file.
  3. To display a web browser used to complete the token-based authentication flow even when SQL_DRIVER_NOPROMPT is enabled, select the Ignore SQL_DRIVER_NOPROMPT check box.
  4. To save your settings and close the DFI Options dialog box, click OK.

Related topics