How to do OpenQuery in mongoDB

Question

I want to do link mongodb servers within one query like SQL Linked server's OpenQuery concept. Is it possible in mongoDB?

SELECT 
    UserID,
    UserName,
    FirstName,
    LastName
FROM OPENQUERY(remotelinkedservername, 'SELECT * FROM dbo.Users' )

score 1 · Accepted Answer · edited Feb 22 '18 at 08:55

1

You can't do Open query logic in mongoDB but you can connect mongoDB with SQL server by using MongoDB new ODBC Driver with SQL Connector 2.1.0

A linked server enables you to execute distribute queries against tables stored in a Microsoft SQL Server instance and another data store. Use the Microsoft SQL Server Management Studio to link your MongoDB data store to a SQL Server instance and then execute distribute queries against both data stores.

edited Feb 22 '18 at 08:55

Murugan Perumal

975
5
15

answered Jun 28 '17 at 20:29

Developer Quick gun

40
6

1

Just would like to add that my company offers a [MongoDB ODBC Driver](https://www.progress.com/odbc/mongodb) – user6641561 Jun 29 '17 at 19:42
1

This company is doing the same thing using Microsoft SQL Server Linked Server with the commercial MongoDB ODBC driver mentioned in the previous comment - https://www.progress.com/customers/killik-co – Sumit Sarkar Jun 30 '17 at 12:44
1

ODBC new connector 2.1.0 – Murugan Perumal Feb 22 '18 at 08:58

How to do OpenQuery in mongoDB

1 Answers1