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 Windows Registry.

To set connector-wide configuration options:

1. Choose one:
• If you are using Windows 7 or earlier, click Start , then type regedit in the Search field, and then click regedit.exe in the search results.
• Or, if you are using Windows 8 or later, on the Start screen, type regedit, and then click the regedit search result.
2. Navigate to the appropriate registry key for the bitness of your connector and your machine:
• If you are using the 32-bit connector on a 64-bit machine, then browse to the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Simba\Simba Impala ODBC Driver\Driver

• Otherwise, browse to the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Simba\Simba Impala ODBC Driver\Driver

3. For each connection property that you want to configure, do the following:
   1. Right-click the Driver subkey and then select New > String Value.
   2. Type the key name of the connection property, and then press Enter.

   For example, to specify the authentication mechanism to use, type AuthMech. To verify the supported key name for each connector configuration option, refer to the "Key Name" column in the description of the option in Driver Configuration Options on page 1.

   3. Right-click the value that you created in the previous steps and then click Modify.
   4. In the Edit String dialog box, in the Value Data field, type the value that you want to set the connection property to and then click OK.

   For example, to specify the Kerberos authentication mechanism, type 1.

4. Close the Registry Editor.

Related topics

• Configuring the Driver on page 1
• Driver Configuration Options on page 1