# Atlas Data API Removal > Two distinct approaches for SQL-based BI tool integration with MongoDB: Parent: [MongoDB BI Connector and SQL Access](https://llms-explorer.com/tree/mongodb-bi-connector-and-sql-access/) · 15 facets · 48 facts · page: https://llms-explorer.com/tree/atlas-data-api-removal/ ## Overview - Two distinct approaches for SQL-based BI tool integration with MongoDB: — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#overview) - Legacy BI Connector (mongosqld): EOL September 2026. Self-hosted translation layer. — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#overview) - Atlas SQL Interface (current): Managed service via Atlas Data Federation. Certified connectors for Tableau and Power BI. — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#overview) ## What It Is - A self-hosted binary (mongosqld) that acts as a MySQL-protocol SQL translation layer in front of MongoDB. BI tools connect via ODBC/JDBC as if connecting to a MySQL database. — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#what-it-is) ## DRDL Schema Files - mongosqld uses DRDL (Document Relational Definition Language) files to define the SQL schema mapping: — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#drdl-schema-files) ## EOL Timeline - September 2026: BI Connector reaches end-of-life; mongosqld will no longer be supported or updated — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#eol-timeline) - Migration: All customers should migrate to Atlas SQL Interface (if on Atlas) or third-party tools (Hasura, DBeaver, etc.) — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#eol-timeline) ## Architecture - Atlas SQL Interface uses Atlas Data Federation (FDI) as its query engine. No self-hosted binary needed. — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#architecture-1) ## Certified Connectors - Custom connector in the Tableau Exchange or direct download — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#certified-connectors) - Supports Tableau Desktop, Tableau Server, Tableau Prep — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#certified-connectors) - Tableau Cloud: check current status (in progress as of 2025) — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#certified-connectors) - Driver: JDBC or MongoDB ODBC Driver (Windows/Linux/macOS) — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#certified-connectors) - Certified by Microsoft; available in Microsoft AppSource — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#certified-connectors) - Supports DirectQuery (live Atlas queries) and Import mode — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#certified-connectors) - Driver: MongoDB ODBC Driver — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#certified-connectors) - Via ODBC connection with MongoDB ODBC Driver — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#certified-connectors) - Windows only (ODBC data source configuration) — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#certified-connectors) ## JDBC Connection - Connection setup in Tableau: — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#jdbc-connection) - Select "Other Databases (JDBC)" connector — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#jdbc-connection) - URL: jdbc:mongodb://atlas-sql-.mongodb.net:27017/?ssl=true — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#jdbc-connection) - Class name: com.mongodb.mongosql.MongoSQLDriver — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#jdbc-connection) ## ODBC Connection (Power BI / Excel) - Download MongoDB ODBC Driver 2.0+ — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#odbc-connection-power-bi-excel) - In Windows ODBC Data Source Administrator: Add new DSN — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#odbc-connection-power-bi-excel) - Server: atlas-sql-.mongodb.net — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#odbc-connection-power-bi-excel) - Database: — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#odbc-connection-power-bi-excel) - Authentication: username/password — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#odbc-connection-power-bi-excel) ## DirectQuery vs Import Mode (Power BI) - DirectQuery performance depends on Atlas query performance. Index optimization applies here too - slow MQL = slow DirectQuery. — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#directquery-vs-import-mode-power-bi) ## Atlas Cluster Requirements - Atlas clusters: MongoDB 5.0+ — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#atlas-cluster-requirements) - Self-managed Enterprise: MongoDB 6.0+ (JDBC/ODBC 3.0.1+) — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#atlas-cluster-requirements) - Data Federation is provisioned automatically when Atlas SQL Interface is enabled — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#atlas-cluster-requirements) ## Cost - Atlas SQL Interface incurs Data Federation query processing costs: — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#cost) - $5.00/TB of data processed per query — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#cost) - Partition strategy and Parquet format reduce costs significantly — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#cost) - DirectQuery workloads (multiple users, frequent refreshes) accumulate more data processed charges than scheduled Import — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#cost) ## Pre-migration checklist - Verify cluster is on MongoDB 5.0+ — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#pre-migration-checklist) - Enable Atlas Data Federation on the project — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#pre-migration-checklist) - Map DRDL schema columns to Atlas SQL Interface schema (jsonSchema format) — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#pre-migration-checklist) - Update BI tool connection: switch from mongosqld host to FDI hostname — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#pre-migration-checklist) ## Schema Migration - DRDL columns → jsonSchema properties: — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#schema-migration) ## Anti-Patterns - Using BI Connector for new deployments (post-2024): EOL is September 2026; invest in Atlas SQL Interface — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#anti-patterns) - DirectQuery without optimizing MongoDB indexes: Every Power BI interaction queries Atlas live; unindexed queries = slow dashboards — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#anti-patterns) - Schema auto-infer on heterogeneous collections: Auto-infer samples 1,000 documents and may miss fields in outliers; validate schema explicitly for production — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#anti-patterns) - Not setting a Data Federation query byte limit: Runaway DirectQuery workloads can drive significant $5/TB costs — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#anti-patterns) ## References - BI Connector Documentation (Legacy) — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#references) - Atlas SQL Interface — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#references) - Atlas SQL JDBC Driver — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#references) - Atlas SQL ODBC Driver — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#references) - BI Connector EOL Announcement — [source](https://llms-explorer.com/sources/mdb-context-hub/mongodb-bi-connector/#references) ## Context files - [MongoDB BI Connector and SQL Access](https://llms-explorer.com/downloads/sources/mdb-context-hub/mongodb-bi-connector.md)