MongoDB SQL Interface: Now Obtainable for Enterprise Superior

In the present day, we’re excited to announce the overall availability of MongoDB SQL Interface for MongoDB Enterprise Superior. This builds upon the muse established by MongoDB Atlas SQL Interface, which started by extending SQL connectivity to self-managed MongoDB deployments. Groups can now question their MongoDB information immediately from acquainted BI instruments like Tableau and Microsoft’s Energy BI utilizing commonplace ODBC and Java Database Connectivity (JDBC) connections, eliminating the necessity to study MongoDB Question Language (MQL), construct extract, rework, and cargo (ETL) pipelines, or transfer information.

Bridging the SQL-MongoDB hole

Organizations new to MongoDB typically face an information entry problem: Whereas builders profit from elevated flexibility and efficiency, groups transferring from SQL-based instruments typically wrestle to entry the info they want. With out direct SQL connectivity, they have to both study MongoDB’s question language or construct and keep customized ETL pipelines to maneuver information out of MongoDB for reporting and analytics. This creates fragmented operational reporting workflows, with customers switching between a number of instruments and information sources to piece collectively the insights they want. These approaches typically result in elevated upkeep overhead, outdated information, and dependency bottlenecks.

MongoDB SQL Interface now eliminates this friction by offering direct SQL entry to MongoDB information by way of customized connectors and drivers. This works by producing complete JSON schemas of MongoDB collections and translating commonplace SQL queries into MongoDB operations in actual time. Customers can join from standard BI instruments like Tableau and Energy BI, or by way of JDBC and ODBC drivers for different SQL-based instruments. They’ll use acquainted SQL syntax, together with joins, aggregations, and subqueries by way of MongoSQL, a SQL-92 suitable dialect designed particularly for MongoDB. This hastens evaluation and allows self-service reporting whereas sustaining database efficiency.

Getting began

MongoDB SQL Interface is now included with Enterprise Superior licenses and works with MongoDB 6.0 or increased, requiring no adjustments to your present MongoDB server configuration. The setup course of includes three essential steps:

1. Obtain the MongoDB SQL Schema Builder CLI from the obtain heart.
2. Use the command line interface (CLI) to investigate your information construction and generate schemas that map your collections’ doc constructions to SQL-queryable codecs.
3. Join your BI instruments utilizing MongoDB’s customized connectors for Tableau and Energy BI, or JDBC and ODBC drivers for different SQL-based instruments.

The Schema Builder CLI examines your present collections to grasp doc patterns, nested objects, and array constructions. It then creates JSON Schema definitions that protect the total richness of your doc mannequin whereas making advanced nested constructions and arrays queryable by way of acquainted SQL syntax. This schema-first method ensures optimum question efficiency and maintains information kind accuracy throughout your SQL operations.

As soon as the MongoDB Schema Builder CLI generates your schemas, it shops them alongside your information. SQL Interface then robotically makes use of them to validate queries and supply correct kind data for outcomes. This creates a seamless bridge between MongoDB’s versatile doc mannequin and SQL’s structured question expectations.

Transferring ahead from MongoDB BI Connector

For organizations at present utilizing MongoDB BI Connector, MongoDB SQL Interface represents a major enchancment to our SQL connectivity resolution. The interface addresses a number of limitations of the MongoDB BI Connector method, together with improved question efficiency by way of native MongoDB operations and enhanced schema flexibility that higher represents doc constructions. Whereas assist for BI Connector will proceed till September 2026, MongoDB SQL Interface gives improved efficiency, enhanced schema management, and a extra intuitive setup course of.