Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open the ODBC Administrator (64 bit).

  2. Add a new System

  3. Select the driver from the list.

  4. Click Finish.

  5. Click the newly created DSN name. This displays the Simba Spark ODBC Driver DSN Setup dialog box.Image Removed

    image-20250304-091341.pngImage Added
  6. Configure the ODBC connection as:

    1. Data Source Name: This is the name you will use to refer to this

    2. Spark Server Type: Select the SparkThriftServer (1.1 and later) option.

    3. Host(s): This is the Kyvos Web server URL without http. For example, use kyvos_install NOT http://kyvos_install

    4. Port: The port your install is running By default, it’s 8081 for HTTP and 8443 for HTTPS

    5. Authentication Mechanism: Select the Username and Password

    6. Enter your credentials in the User Name and Password

    7. Save Password: Select this checkbox to save the password in the Some tools may honor this, others may still ask.

    8. Thrift Transport: Select the HTTP

    9. 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

    10. SSL Options: If you are using SSL, you’ll need to configure this based on your IT recommendations.

  7. Click Test. Assuming it connects, click the OK button to save.

...