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 cluster and receive results. The ODBC driver supports Starburst Galaxy and Starburst Enterprise platform (SEP).

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

• PDF file
• TXT file

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.2.0.1002) is available for the following operating system versions and driver managers. Older versions of the driver may be subject to different platform requirements.

See the release notes for changes and fixes in the latest driver version.

Standalone drivers #

Download the latest Starburst ODBC driver using archive files:

• Starburst ODBC .zip
• Starburst ODBC .tar.gz

Windows #

The Starburst ODBC driver supports the following operating system versions:

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

Download the latest Starburst ODBC driver for Windows:

• Starburst ODBC 32-bit .msi
• Starburst ODBC 64-bit .msi

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 11 (Universal binary for Intel and ARM support)
• macOS version 12 (Universal binary for Intel and ARM support)

Download the latest Starburst ODBC driver for macOS:

• Starburst ODBC Intel .dmg and Starburst ODBC Apple Silicon .dmg

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, 8, or 9
• CentOS 7 or 8
• Debian 10 or 11
• Ubuntu 20.04 or 22.04

Download the latest Starburst ODBC driver for Linux:

• Starburst ODBC RHEL i686/32-bit .rpm
• Starburst ODBC RHEL x86_64/64-bit .rpm
• Starburst ODBC Debian ARM/64-bit .deb
• Starburst ODBC ARM/64-bit .rpm
• Starburst ODBC Debian i386/32-bit .deb
• Starburst ODBC Debian amd64/64-bit .deb

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 #

Unless advised by Starburst Support, download the latest stable version (v2.2.0.1002) of the Starburst ODBC driver. If you require a specific driver version, see the ODBC driver archive for download links and documentation.

Note that version 1.2.16 and earlier of the ODBC driver require a license file, which you can 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 Starburst Galaxy and SEP with a client application, learn more about Starburst’s SQL support.