ODBC driver #

The Open Database Connectivity (ODBC) driver enables any application supporting an ODBC driver to connect to Starburst clusters. The client application can then issue SQL queries to a Starburst Enterprise platform (SEP) cluster and receive results.

For more detailed information, refer to the complete ODBC driver documentation

Installation #

To install the ODBC driver, download the latest driver for your operating system version. Typically you have to install the driver and add it to your client application. Refer to your client’s documentation for more details.

Some clients may require an older version of the ODBC driver than the downloads available on this page. See Driver version requirements for more information.

Download the driver #

The latest version of the Starburst ODBC driver (v2.0.1.1002) is available for the following operating system versions and driver managers. Older versions of the driver may be subject to different platform requirements.

Windows #

The Starburst ODBC driver supports the following operating system versions:

  • Windows 10, 8.1, or 7 SP1
  • Windows Server 2016, 2012, or 2008 R2 SP1

Download the latest Starburst ODBC driver for Windows:

The ODBC driver can be managed on Windows with Windows ODBC Administrator.

MacOS #

The Starburst ODBC driver supports the following operating system versions:

  • MacOS version 10.15, 10.14, or 10.13

Download the latest Starburst ODBC driver for macOS:

The ODBC driver can be managed on macOS with the following driver managers:

  • iODBC 3.52.9 or later
  • unixODBC 2.2.14 or later

Linux #

The Starburst ODBC driver supports the following operating system versions:

  • Red Hat® Enterprise Linux® (RHEL) 7 or 6
  • CentOS 7 or 6
  • SUSE Linux Enterprise Server (SLES) 12 or 11
  • Debian 9 or 8
  • Ubuntu 18.04, 16.04, or 14.04

Download the latest Starburst ODBC driver for Linux:

The ODBC driver can be managed on Linux with the following driver managers:

  • iODBC 3.52.9 or later
  • unixODBC 2.2.14 or later

Driver version requirements #

For most clients, download the newest version of the Starburst ODBC driver. Some ODBC-based clients may require earlier versions of the ODBC driver. Contact Starburst Support to request specific driver versions.

Note that version 1.2.16 and earlier of the ODBC driver require a license file, which you can also request from Starburst Support. Install this license file in the lib directory of the ODBC driver installation.

Connect to a cluster #

With the ODBC driver installed, you can now configure a connection to a cluster. Typically you only need the connection information. Other details such as the ODBC connection are automatically configured in many applications, or can be seen and updated in a user interface dialog.

Start querying #

You can now open a connection and start running queries.

For example, if your application allows you to write and run queries you can run the following command to see what catalogs are available:

SHOW CATALOGS;

Many client applications provide a user interface to see the list of catalogs, schema, tables, and much more.

Next steps #

Now that you can connect to SEP with a client application, learn more about Starburst’s SQL support.