Cosmos DB ODBC Driver

⚡ Key Benefits

• SQL-Driven Operations — Read and write Cosmos DB entities through familiar SQL statements
• Flexible Endpoint Access — Work with databases, tables/containers, users, and documents from one DSN
• API Key Authentication — Configure secure account-level access for read and write workflows
• Performance Controls — Push filtering via query builder parameters for server-side execution
• Centralized Governance — Publish one connection through Data Gateway for multiple clients

📸 Visual Overview & Setup

1. Pick Cosmos DB Connector 🔍 View Full Size	2. Search Online if Not Listed Cosmos DB connector page	3. Build & Preview SQL Query 🔍 View Full Size
4. Load Cosmos DB Rows into Excel 🔍 View Full Size	5. Connect from Power BI 🔍 View Full Size	6. Share via Data Gateway Data Gateway overview

🔗 Seamless SQL Query Integration

-- Create document in Cosmos DB via SQL
INSERT INTO TestContainer (PartitionKey, Document)
VALUES(
'["user2"]',
'{"id":"user2","name":"John Doe","email":"jdoe@contoso.com","phone":["12345"],"level":"platinum"}'
)
WITH(Upsert='true')

🔧 Key Features

Read and Write Coverage

• Query documents, databases, containers, and users through table-like endpoints
• Create, update, upsert, and delete documents through SQL-driven operations
• Use generic request endpoints for advanced Cosmos DB API scenarios

Authentication and Security

• API key authentication using primary or secondary key modes
• Support for read-only and read-write key governance models
• Account-scoped access for controlled DSN-level configuration

Operational Fit

• Use query builder parameters to move filtering server-side for faster retrieval
• Handle partition key values and document payloads from SQL
• Share one connection across users using Data Gateway

💡 Common Use Cases

• Document analytics: Query Cosmos DB documents from BI and SQL reporting tools.
• Data synchronization: Insert or upsert JSON documents from ETL output datasets.
• Cross-tool reporting: Reuse one DSN across SQL Server, Power BI, and Excel.
• Centralized access: Govern shared API access via Data Gateway deployment.
• Operational automation: Execute repeatable document workflows from SQL jobs.

🎯 Summary

Bring Azure Cosmos DB into your ODBC ecosystem with SQL-driven access patterns.
Configure once and integrate from reporting, automation, and data engineering tools without custom API wrappers.

Trusted by Developers & IT Teams Worldwide Built for ODBC Workloads: One integration model across SQL, BI, and code. Expert Technical Support: Help with auth setup, query design, and troubleshooting. Proven Enterprise Scale: Used globally for API and cloud data integration projects.

ODBC PowerPack Includes Cosmos DB ODBC Driver Read reviews on Capterra →