Configure Simba ODBC driver with a proxy in Windows

How to configure the Simba ODBC driver to connect through a proxy server when using Windows.

Written by jordan.hicks

Last published at: March 2nd, 2022

In this article you learn how to configure the Databricks ODBC Driver when your local Windows machine is behind a proxy server.

Download the Simba driver for Windows

Download and install the latest version of the Databricks ODBC Driver for Windows.

Add proxy settings to the Windows registry

Open the Windows registry and add the proxy settings to the Simba Spark ODBC Driver key.

  1. Open the Windows Registry Editor.
  2. Navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Simba\Simba Spark ODBC Driver\Driver key.
  3. Click Edit.
  4. Select New.
  5. Click String Value.
  6. Enter UseProxy as the Name and 1 as the Data value.
  7. Repeat this until you have added the following string value pairs:
    Name ProxyHost Data <proxy-host-address>
    Name ProxyPort Data <proxy-port-number>
    Name ProxyUID Data <proxy-username>
    Name ProxyPWD Data <proxy-password>
  8. Close the registry editor.

Configure settings in ODBC Data Source Administrator

  1. Open the ODBC Data Sources application.
  2. Click the System DSN tab.
    ODBC Data Sources application
  3. Select the Simba Spark ODBC Driver and click Configure.
  4. Enter the connection information of your Apache Spark server.
    Simba Spark ODBC Driver DSN Setup
  5. Click Advanced Options.
  6. Enable the Driver Config Take Precedence check box.
    Simba Spark ODBC Driver DSN Setup - Advanced Options
  7. Click OK.
  8. Click OK.
  9. Click OK.
Was this article helpful?