CODEWITHSUNDEEP
azure-cosmosdb
sqlfit
sqlfit

Reputation: 43

Use SQL Server to query CosmosDB

Is there a way to query CosmosDB from SQL Server 2016 SSMS? I'm currently querying CosmosDB using the DocumentDB ODBC driver via SSIS. Users are now asking for the ability to query CosmosDB directly from SSMS through some sort of view.

Upvotes: 4

Views: 7002

Answers (2)

Sam Tran
Sam Tran

Reputation: 158

Yes there is, you can use Linked Servers. For more information, https://samtran.me/2017/10/07/linked-servers-for-azures-nosql-cosmosdb/

Upvotes: 7

Luis Bosquez
Luis Bosquez

Reputation: 386

SQL Server Management Studio makes use of SqlClient underneath, which makes the main GUI only compatible with SQL Server databases. Using Linked Servers might not work yet either, since SQL Server doesn't support DocDB drivers.

Upvotes: 1

Related Questions