Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

ODBC is one of the most established and widely supported for connecting and working with databases. The Kyvos ODBC Driver is used for Spark SQL access to the Kyvos BI Server, enabling business intelligence, analytics, and reporting.

Click here to download the Kyvos ODBC driver.

Features

The Kyvos ODBC driver comes with the following features.

• Catalog and schema support: The Kyvos ODBC Driver supports both catalogs and schemas to make it easy for the driver to work with various ODBC applications.

• Security and authentication: Some Kyvos datastores require connections authentication with Secure Sockets Layer (SSL) protocol to protect data from unauthorized access. SSL encryption protects data and credentials when they are transferred over the network and provides stronger security. We recommended enabling SSL whenever you connect to a server that is configured to support it.
  For more information, refer to the Configuring SSL Verification on Windows section below.

Supported data types

The Kyvos ODBC Driver supports various standard data formats, converting between Spark data types and SQL data types.

The following table lists the supported data type mappings.

Kyvos ODBC Driver

• Windows

  • Prerequisites for Windows

  • Installing and configuring Kyvos ODBC Driver on Windows

  • Creating a data source name (DSN) on Windows

  • Configuring SSL verification on Windows

  • Configuring logging options on Windows

• Mac

  • Creating a data source name (DSN) on Mac OS

  • Configuring logging options on MAC

Prerequisites for Windows

Each computer on which you install the driver must meet the following minimum system requirements:

• One of the following operating systems:

  • Windows 8.1 or Windows 10

  • Windows Server 2012 and 2016

• Visual C++ Redistributable for Visual Studio 2015 installed (with the same bitness as the driver that you are installing)

• Available disk space: 100 MB

• To install the driver, you must have Administrator privileges on the computer.

Installing and configuring Kyvos ODBC Driver on Windows

To install the Kyvos ODBC Driver on Windows:

1. Double-click the Kyvos ODBC Installer executable file to start the installation.

2. If prompted, enter Administrator credentials and click OK.

3. Click Next.

4. Read License Agreement and click Yes if you agree to the terms; to continue with the installation. Else, click No to exit.

5. Enter Username and Company Name in the corresponding fields and click Next.

6. Choose the Setup Type. We recommend selecting the Complete

7. If you have selected the Custom setup type, you can change the installation location, click Change to choose the folder on your computer, and then click OK. To accept the installation location, click Next.

8. Click Install.

9. When the installation completes, click Finish.