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 Apache Impala ODBC Connector 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.

    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 Connector Configuration Options.

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