Setting Connector-Wide Configuration Options

When you specify connection settings in a DSN or connection string, those settings apply only when you connect to Impala using that particular DSN or string. As an alternative, you can specify settings that apply to every connection that uses the Simba Impala ODBC Driver by configuring them in the simba.impalaodbc.ini file.

Note:

Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.

To set connector-wide configuration options:

  1. In a text editor, open the simba.impalaodbc.ini configuration file.
  2. In the [Driver] section, specify configuration options as key-value pairs. Start a new line for each key-value pair.

    3. For example, to enable SASL User Name authentication using "simba" as the user name, type the following:

    AuthMech=SASL User Name

    UID=simba

    For detailed information about all the configuration options supported by the connector, see Driver Configuration Options on page 1.

  3. Save the simba.impalaodbc.ini configuration file.

Related topics