• MongoDB SQL Interface: Now Available for Enterprise Advanced Today, we’re excited to announce the general availability ofMongoDB SQL InterfaceforMongoDB Enterprise Advanced. • This builds upon the foundation established by MongoDB Atlas SQL Interface, which began by extending SQL connectivity to self-managed MongoDB deployments. • Teams can now query their MongoDB data directly from familiar BI tools like Tableau and Microsoft’s Power BI using standard ODBC and Java Database Connectivity (JDBC) connections, eliminating the need to learn MongoDB Query Language (MQL), build extract, transform, and load (ETL) pipelines, or move data. • Bridging the SQL-MongoDB gap Organizations new to MongoDB often face a data access challenge: While developers benefit from increased flexibility and performance, teams moving from SQL-based tools often struggle to access the data they need. • Without direct SQL connectivity, they must either learn MongoDB’s query language or build and maintain custom ETL pipelines to move data out of MongoDB for reporting and analytics. • This creates fragmented operational reporting workflows, with users switching between multiple tools and data sources to piece together the insights they need.
Article Summaries:
- MongoDB has released the general availability of its SQL Interface for MongoDB Enterprise Advanced, extending the functionality that began with the Atlas SQL Interface. The new feature allows users to query MongoDB collections directly from BI tools such as Tableau and Power BI via standard ODBC and JDBC connections, eliminating the need to learn MongoDB’s query language or build ETL pipelines. The interface generates JSON schemas from collections and translates SQL‑92‑compatible queries into MongoDB operations in real time. It is included with Enterprise Advanced licenses, works with MongoDB 6.0+, and requires only a three‑step setup involving a CLI schema builder and connector installation.
Sources: