MongoDB ODBC Driver — SQL Access to MongoDB NoSQL Data

September 28, 2016 Data & AI

Progress DataDirect MongoDB drivers are certified by MongoDB to provide SQL access to the NoSQL data stored in your MongoDB instance. This guide will help you get started with our MongoDB ODBC driver.

The MongoDB ODBC driver is one of the most popular Progress DataDirect drivers. This driver provides powerful SQL access to the NoSQL data stored in your MongoDB instance. Our MongoDB drivers let you map a logical schema against complex MongoDB JSON structures (including deeply nested documents and arrays) into their most natural relational counterpart—child tables that relate to a primary parent table.

Our developers and data evangelists came up with a ton of resources to help you through your MongoDB ODBC connectivity journey. In this article, I will get all of this information together in one place so you have an informal guide to help you through your evaluation process.

How TIBCO Jaspersoft Used MongoDB Drivers

 

Why Do I Need a MongoDB ODBC Driver?

  1. Back in 2014, Sumit Sarkar wrote this article describing why you need SQL access to MongoDB.
  2. This community post by Brody Messmer gets a little more technical about our MongoDB drivers.
  3. An ODBC driver for MongoDB can help you fit MongoDB into Big Data. Learn how in this webinar.



Why DataDirect MongoDB Drivers?

  1. Our drivers are certified by MongoDB, straight from the source! Progress is an official partner for MongoDB and this solutions brief explains how our partnership will help you with MongoDB integration.
  2. In this joint webinar, Gene Arnold, Senior Sales Engineer at TIBCO Jaspersoft, explains why the company went with the DataDirect MongoDB ODBC solution.

How Do Our MongoDB Drivers Work?

  1. This datasheet gives you a good overview of how our MongoDB drivers work and discusses their benefits
  2. Brad Wright explains in this webinar how we get SQL access to MongoDB data using our ODBC and JDBC drivers

Getting Started

  1. Try our ODBC driver for MongoDB for free
  2. You can find all relevant technical information in our documentation for MongoDB
  3. Watch our videos to install and configure the MongoDB ODBC driver on Windows or Linux
  4. Here are some tutorials to help you use our MongoDB ODBC driver:
    1. MongoDB ODBC Connectivity for Tableau
    2. Connect MongoDB and Power BI Using the DataDirect ODBC Driver
    3. Integrate with MS Access Using the MongoDB ODBC Driver
    4. Connect MongoDB to TIBCO Spotfire via the ODBC Driver
    5. MongoDB ODBC Drivers Disrupt Microstrategy Shops
  5. These video tutorials on Tableau and Microsoft Query will also help you get started

You can contact us if you have any questions during your setup. Before you leave, I’d like to set the record straight—Progress is a pioneer in standards-based connectivity. We cofounded the ODBC specification. Progress DataDirect is run by 10,000+ organizations, including 350+ ISVs and 96 of the Fortune 100. And most importantly, our MongoDB drivers are exclusively certified by MongoDB.

Try Now

MongoDB NoSQL SQL SQL Access

Nishanth Kadiyala

Nishanth Kadiyala is a Technical Marketing Manager at Progress. He got his B.Tech degree from IIT Guwahati and his MBA from UNC Chapel Hill. He has worked on several technologies including database designing, SQL querying and Cloud Computing in the past. Currently, he is committed to educating enterprises about standards based connectivity via ODBC, JDBC, ADO.NET and OData. He is also proficient with DataDirect Hybrid Connectivity Services – DataDirect Cloud and Hybrid Data Pipeline. You can stay in touch with him through Twitter.