Interesting Tip: Run query against MongoDB using SQL Server
Disclaimer: This is just a quick setup I had to do to expose MongoDB to SQL Server user, this is still a work in progress because not everything works, only non string fields work so far, such as number and date, at least I haven't found a way to get around it. Update: So far the major types that we typically query all work for me, such as varchar, int, and datetime. Components: SSMS, SQL Server v2008 (It should also work for 2012 or 2016) MongoDB 3.2.x MongoDB BI Connector v2.2 mysql-connector-odbc-5.3.9 I am going to jump directly to the setup on SQL Server as I have done a little bit of bi connector setups in the post1 , post2 , Please refer to them for setting that up. First, let's download the mysql-connector-odbc, here I have downloaded the latest version which is available to me, the 5.3.9 version. Then we simply need to install that on the server where we are going to set up our odbc connection. After the setup is complete, we can go to ...