Hendelser
Bli et sertifisert stoff Dataingeniør
14. jan., 23 - 31. mars, 23
Sjekk din kvalifisering for en eksamen rabatt tilbud og registrere deg for gratis live økter for å forberede eksamen DP-700.
Finn ut merDenne nettleseren støttes ikke lenger.
Oppgrader til Microsoft Edge for å dra nytte av de nyeste funksjonene, sikkerhetsoppdateringene og den nyeste tekniske støtten.
Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. Azure Data Explorer is compatible with a subset of the SQL Server communication protocol (MS-TDS). This compatibility enables the use of the ODBC driver for SQL Server with Azure Data Explorer.
Consequently, you can establish a connection to Azure Data Explorer from any application that is equipped with support for the ODBC driver for SQL Server.
Watch the following video to learn to create an ODBC connection.
Alternatively, follow the steps to connect to your cluster with ODBC.
Obs!
We recommend using dedicated connectors whenever possible. For a list of available connectors, see Connectors overview.
You can connect to your cluster in the following ways.
From an application that supports ODBC connection, you can connect to your cluster with a connection string of the following format:
"Driver={ODBC Driver 17 for SQL Server};Server=mykustocluster.kusto.windows.net;Database=mykustodatabase;Authentication=ActiveDirectoryIntegrated"
Obs!
Azure Data Explorer considers string values as NVARCHAR(MAX)
, which may not work well with some ODBC applications. Cast the data to NVARCHAR(
n)
using the Language
parameter in the connection string. For example, Language=any@MaxStringSize:5000
will encode strings as NVARCHAR(5000)
. For more information, see tuning options.
To use application principal authentication with ODBC, you must provide the Microsoft Entra tenant ID. You can set this configuration in the connection string, the Windows registry, or the odbc.ini file. See examples in the following tabs. For more information, see tuning options.
Set the application principal with Language=any@AadAuthority:<aad_tenant_id>
in the connection string. Replace <aad_tenant_id>
, <aad_application_id>
, and <aad_application_secret>
with the Microsoft Entra tenant ID, Microsoft Entra application ID, and the Microsoft Entra application secret respectively.
"Driver={ODBC Driver 17 for SQL Server};Server=<adx_cluster_name>.<region_name>.kusto.windows.net;Database=<adx_database_name>;Authentication=ActiveDirectoryServicePrincipal;Language=any@AadAuthority:<aad_tenant_id>;UID=<aad_application_id>;PWD=<aad_application_secret>"
Hendelser
Bli et sertifisert stoff Dataingeniør
14. jan., 23 - 31. mars, 23
Sjekk din kvalifisering for en eksamen rabatt tilbud og registrere deg for gratis live økter for å forberede eksamen DP-700.
Finn ut merOpplæring
Læringsbane
Data analysis in Azure Data Explorer with Kusto Query Language - Training
Learn how to analyze data in Azure Data Explorer using the Kusto Query Language
Sertifisering
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Dokumentasjon
Connect from common apps - Azure Data Explorer
This article describes how to connect to Azure Data Explorer with SQL Server emulation from various apps in Azure Data Explorer.
Azure Data Explorer as linked server from SQL server - Azure Data Explorer
This article describes Azure Data Explorer as a linked server from the SQL server.