# 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`