Use SQL Server to query CosmosDB

Question

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.

Answer 1

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