Starburst Documentation
Data consumer
  • Overview
  • Introduction
  •   Clients
  • Using SQL
  • Migrating your queries
  • Materialized views
    • Resources
  • Support
  • Security
  • Technical blog
  • Video library
  • Starburst Academy
  • Glossary
  • Conventions
  • Iconography
  • Trino Forum

    • data consumer > clients > ODBC driver

    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.15.1021) 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.

    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 #

    Unless advised by Starburst Support, download the latest stable version (v2.0.15.1021) 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 SEP with a client application, learn more about Starburst’s SQL support.