SQL Connectivity in a MongoDB World

SQL Connectivity in a MongoDB World

June 03, 2015 0 Comments

Sumit Sarkar recaps his experience at MongoDB World 2015 and announces further support for NoSQL with open data standards.

Over the last month, I've been on the road gathering feedback from Business Intelligence (BI) professionals around NoSQL connectivity with open data standards across ODBC, JDBC and OData. I wrapped up the DataDirect NoSQL BI evangelism tour this week in New York City at MongoDBWorld.  One of the NoSQL database technologies we've been talking about is MongoDB during this tour, so it's really exciting to hear a direct response at MongoDBWorld on plans to expand support for SQL connectivity for BI in the future!

DataDirect MongoDB ODBC and JDBC connectors will continue to pick up the latest enhancements from MongoDB such as support for the aggregation framework discussed at MongoDBWorld ’14. And we'll continue to leverage future enhancements such as the improved SQL experience announced at MongoDBWorld ’15.

Elevating MongoDB with ODBC/JDBC

Adoption for MongoDB is growing across the enterprise and disrupting existing business intelligence, analytics and data integration infrastructure. During my MongoDB World session, “Elevate MongoDB with ODBC/JDBC,” I wanted to show my audience how to disrupt that disruption using ODBC and JDBC access to MongoDB for instant out-of-box integration with existing infrastructure to elevate and expand your organization’s MongoDB footprint. The discussion topics included common challenges and “gotchas” that shops face when exposing unstructured and semi-structured data using these established data connectivity standards. Existing infrastructure requirements should not dictate developers’ freedom of choice in a database.

During the Q&A portion of my presentation, I got a lot of great questions, but there were a few that stuck out:

How do you prevent runaway queries on operational MongoDB databases? Do you support the aggregation framework?

Yes, DataDirect does support the aggregation framework.

When querying data from the logical, normalized data model exposed by DataDirect MongoDB ODBC and JDBC clients, the driver sends a single optimized query to MongoDB even if SQL join are executed, as long as it's within a single collection. The drivers are further optimized with support for the aggregate framework. In cases where MongoDB query API does not support an operation (such as cross collection joins), the driver will perform the work and has been enhanced to handle even larger data sets in the latest versions (Summer ’15).

For operational systems, the considerations for SQL access are really no different than those for native MongoDB queries. Further, the driver can be configured to connect to secondary servers using the "Read Preference" connection property.

What are best practices for changing data models?

DataDirect connectors establish a logical, normalized data model at the time of connection based on sampling a configurable portion of the database. If new requirements arise and the data model changes significantly, I recommended that you refresh the data model across both BI servers and client metadata modeling tools.

Our R&D team attended MongoDB World as well, and is investigating the latest technologies that can help solve this problem.

DataDirect's vast partner ecosystem on display at MongoDBWorld

One of the best things about events like MongoDB is the opportunity to learn about the latest technologies from DataDirect partners.  Many of our partners—CA, Teradata and Tibco to name a few–co-sponsored the show with us. I really enjoyed seeing live demos for MongoDB analytics powered by the DataDirect MongoDB JDBC driver from the Jaspersoft team.

Later in the show, our friends from Tableau had a live demo, during which they recommended our currently available Progress DataDirect ODBC and JDBC drivers for connectivity to MongoDB. There were some announcements during the keynote for possible Tableau integration in the future, but I cannot comment any further on that.

Talk to us about MongoDB connectivity

If you missed the show, make sure you don’t miss out! Contact us to learn more about SQL access to MongoDB, or pick up a free trial of our MongoDB ODBC/JDBC drivers.

Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments are disabled in preview mode.
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
2020 Progress Data Connectivity Report
2020 Progress Data Connectivity Report
Read More
Getting Ahead of the Hybrid Data Curve
Read More
570x321__Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Read More