Connect to Azure Data Explorer with ODBC

Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. Use ODBC to connect to Azure Data Explorer from applications that don't have a dedicated connector.

Behind the scenes, applications call functions in the ODBC interface, which are implemented in database-specific modules called drivers. Azure Data Explorer supports a subset of the SQL Server communication protocol (MS-TDS), so it can use the ODBC driver for SQL Server.

Using the following video, you can learn to create an ODBC connection.

Alternatively, you can configure the ODBC data source as detailed below.

In the article, you learn how to use the SQL Server ODBC driver, so you can connect to Azure Data Explorer from any application that supports ODBC.

Prerequisites

You need the following:

Configure the ODBC data source

Follow these steps to configure an ODBC data source using the ODBC driver for SQL Server.

  1. In Windows, search for ODBC Data Sources, and open the ODBC Data Sources desktop app.

  2. Select Add.

    Add data source

  3. Select ODBC Driver 17 for SQL Server then Finish.

    Select driver

  4. Enter a name and description for the connection and the cluster you want to connect to, then select Next. The cluster URL should be in the form <ClusterName>.<Region>.kusto.windows.net.

    Select server

  5. Select Active Directory Integrated then Next.

    Active Directory Integrated

  6. Select the database with the sample data then Next.

    Change default database

  7. On the next screen, leave all options as defaults then select Finish.

  8. Select Test Data Source.

    Test data source

  9. Verify that the test succeeded then select OK. If the test didn't succeed, check the values that you specified in previous steps, and ensure you have sufficient permissions to connect to the cluster.

    Test succeeded

Next steps