How to setup an ODBC connection

When using Databricks or Snowflake in WriteBackExtreme you need to configure an ODBC connection

Open your ODBC Administrator (search for ODBC in the windows start menu and select `ODBC Datasources (64Bit)`

Snowflake

1. Be sure you have the driver installed from the snowflake website
2. In ODBC Administrator, Go to the `User DSN` tab and press the `Add` button.
3. Select the SnowflakeDSIIDriver
4. Fill in at least these fields:
   1. Data source (this is the key you define to identify your connection, this is the DSN name you need when creating the connection in the management console)
   2. User
   3. Password
   4. Server
   5. Schema
   6. Warehouse
5. Click the test button to confirm that your connection data is correct
6. Make sure to set NoExecuteInSQLPrepare to true in ODBC configuration. (link)

Databricks

Before you start, be sure to read the Databricks ODBC page

There are multiple ways to authenticate. We will describe the username/password authentication in this example. 

1. Be sure you have the Simba Spark ODBC driver installed
2. In ODBC Administrator, Go to the `User DSN` tab and press the `Add` button.
3. Select the Simba Spark ODBC Driver
4. Fill in at least these fields:
   1. Data source (this is the key you define to identify your connection, this is the DSN name you need when creating the connection in the management console)
   2. Host(s)
   3. Port: 443
   4. Database
   5. Mechanism: User Name and Password
   6. User Name: token
   7. Password (this would be your personal access token)
   8. Thrift Transport: HTTTP
   9. Select the HTTP Options button
      1. Fill in your HTTP Path
         
   10. Select the SSL Options
       1. Check the Enable SSL Option
   11. Click the Test button to confirm that connection is successful.