Azure data studio odbc driver#

Azure data studio odbc driver#

Connecting to Azure Cosmos DB with the ODBC driver is currently supported for Azure Cosmos DB Core (SQL) API only.You can use those solutions to analyze, move, transform, and create visualizations with your Azure Cosmos DB data. You can also connect the normalized Azure Cosmos DB data to other software solutions, such as SQL Server Integration Services (SSIS), Alteryx, QlikSense, Tableau and other analytics software, BI, and data integration tools. The driver is ODBC 3.8 compliant and supports ANSI SQL-92 syntax. You can do SQL operations against the normalized tables and views, including group by queries, inserts, updates, and deletes. The ODBC driver helps make Azure Cosmos DB databases useful for data analysts as well as development teams. The schemas have no impact on the underlying data, and don't require developers to adhere to them. The normalized schemas let you use ODBC-compliant tools to access the data. The ODBC driver normalizes Azure Cosmos DB data into tables and views that fit your data analytics and reporting needs. To analyze or report on this data, you might need to flatten the data to fit into a schema.

A single Azure Cosmos database can contain JSON documents of various structures.

You can query the normalized data with SQL queries, or import the data into Power BI or other BI and analytics software to create reports and visualizations.Īzure Cosmos DB is a schemaless database, which enables rapid application development and lets you iterate on data models without being confined to a strict schema. This article walks you through installing and using the Azure Cosmos DB ODBC driver to create normalized tables and views for your Azure Cosmos DB data.