...
Open the ODBC Administrator (64 bit).
Add a new System
Select the driver from the list.
Click Finish.
Click the newly created DSN name. This displays the Simba Spark ODBC Driver DSN Setup dialog box.
Configure the ODBC connection as:
Data Source Name: This is the name you will use to refer to this
Spark Server Type: Select the SparkThriftServer (1.1 and later) option.
Host(s): This is the Kyvos Web server URL without http. For example, use kyvos_install NOT http://kyvos_install
Port: The port your install is running By default, it’s 8081 for HTTP and 8443 for HTTPS
Authentication Mechanism: Select the Username and Password
Enter your credentials in the User Name and Password
Save Password: Select this checkbox to save the password in the Some tools may honor this, others may still ask.
Thrift Transport: Select the HTTP
HTTP Options - HTTP Path: Enter the path as: kyvos/sql. If you are using a custom application name instead of Kyvos, then use the path as <Web application name>/sql
SSL Options: If you are using SSL, you’ll need to configure this based on your IT recommendations.
Click Test. Assuming it connects, click the OK button to save.
...