The Cosmos DB ODBC Driver is a powerful tool that allows you to connect with live data from Cosmos DB, directly from any applications that support ODBC connectivity. Access Cosmos DB data like you would a database - read, write, and update Cosmos DB data through a standard ODBC Driver interface.
See what you can do with Cosmos DB ODBC Driver
Server
Connect to Cosmos DB from SQL Server as Linked-Server. You can query Cosmos DB from familiar Transact-SQL without need of setting up another application.
Integrate Cosmos DB to your system through popular ETL / EAI tools such as Informatica PowerCenter. Standard SQL and Stored Procedures enable fast delivery of your integration projects.
Connect Cosmos DB from any ODBC compatible tools:
Desktop
Your familiar tools can connect to Cosmos DB using CData ODBC.
- Microsoft Access
- Power Query
- DBeaver
- and more
Cosmos DB ODBC Connectivity Features
- Access any Azure CosmosDB instance setup using the MongoDB API
- Enables SQL-92 capabilities on Azure Cosmos DB NoSQL data.
- Flexible NoSQL flattening - automatic schema generation, flexible querying etc.
- Connect to live Azure Cosmos DB data, for real-time data access with the Azure Cosmos DB JDBC Driver
- Full support for data aggregation and complex JOINs in SQL queries
- Secure connectivity through modern cryptography, including TLS 1.2, SHA-256, ECC, etc.
- Seamless integration with leading BI, reporting, and ETL tools and with custom applications via the Cosmos DB Connector.
Target Service, API
The driver connects to Azure Cosmos DB via SQL API. Supports partitioned collections and multi-region deployments.
Schema, Data Model
Models Cosmos DB containers as tables with automatic schema detection. Handles nested documents and arrays with flattening options.
Key Objects
Databases, Containers (Collections), Documents, Stored Procedures, Triggers, and User-Defined Functions. Access to all Cosmos DB data.
Operations
SQL queries translated to Cosmos DB SQL. Full CRUD operations with support for partial updates. Handles partition keys automatically.
Authentication
Azure AD authentication or Master Key/Resource Tokens. Connection requires account endpoint and authentication credentials.
Start a 30-day free trial today
Robust ODBC access to Azure Cosmos DB
Full-featured and consistent SQL access to any supported data source through ODBC
Connect to Cosmos DB—empower every team
AI-assisted development with CData CLI
Build Cosmos DB integrations faster with AI that understands your schema
Schema-aware AI
CData CLI gives AI coding tools access to your Cosmos DB schema. No more guessing table names or column types—AI sees the same metadata in your ODBC Drivers.
Your AI Knows SQL
How to find table names, column names, and how to generate SQL syntax are things that AI knows well from millions of training data. No need for customization, no hallucinations. Your AI acts like a domain specialist to Cosmos DB.
More Accurate, More Token-Efficient
With CData CLI's queryable schema detection and highly efficient queries with filters, aggregation, joins with correct pushdown, your AI will achieve more accuracy with less token usage.
FAQs
Frequently asked Cosmos DB ODBC driver questions
Learn more about Cosmos DB ODBC drivers for data and analytics integration
- Does Cosmos DB support ODBC?
- Is there an ODBC driver for Cosmos DB?
- How do I connect to Cosmos DB via ODBC?
- Where can I download an ODBC driver for Cosmos DB?
- How do I install an ODBC driver for Cosmos DB?
- Is the Cosmos DB ODBC driver 32-bit or 64-bit?
- Does pyODBC work with Cosmos DB?
- Does the ODBC connector support ARM64 devices?
Download the Cosmos DB ODBC Driver today!
Get the latest Cosmos DB ODBC Drivers for Windows, Linux, and macOS. Install in minutes and connect your Cosmos DB data to Power BI, Tableau, and more.