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.

Sam Tran · Accepted Answer · 2017-10-12 11:05:01Z

7

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

answered Oct 12, 2017 at 11:05

Sam Tran

1581 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

dancerjude Over a year ago

This link reaches a website that try with insistence to install an Edge extension (since I'm using Edge).

Steve Owen Over a year ago

It's a dead link, and really the contents of the page should have been included here.

Antonio Buonaiuto Over a year ago

the link is poisoned and should be removed.

Luis Bosquez · Accepted Answer · 2017-10-05 03:05:32Z

1

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.

answered Oct 5, 2017 at 3:05

Luis Bosquez

3862 silver badges11 bronze badges

Collectives™ on Stack Overflow

Use SQL Server to query CosmosDB

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related