Setting Connector-Wide Configuration Options

When you specify connection settings in a DSN or connection string, those settings apply only when you connect to Spark using that particular DSN or string. As an alternative, you can specify settings that apply to every connection that uses the Simba Apache Spark ODBC Connector by configuring them in the simba.sparkodbc.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.sparkodbc.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 User Name authentication using "simba" as the user name, type the following:

    AuthMech=2

    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.sparkodbc.ini configuration file.

Related topics