Atlas Data API Removal

Parent: MongoDB BI Connector and SQL Access · researched 2026-05-28T16:44:56.847Z· 5 sources · 6 concepts · skill mongodb-bi-connector

Two distinct approaches for SQL-based BI tool integration with MongoDB:

Overview

Two distinct approaches for SQL-based BI tool integration with MongoDB: [source]
Legacy BI Connector (mongosqld): EOL September 2026. Self-hosted translation layer. [source]
Atlas SQL Interface (current): Managed service via Atlas Data Federation. Certified connectors for Tableau and Power BI. [source]

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]

mongosqld uses DRDL (Document Relational Definition Language) files to define the SQL schema mapping: [source]

September 2026: BI Connector reaches end-of-life; mongosqld will no longer be supported or updated [source]
Migration: All customers should migrate to Atlas SQL Interface (if on Atlas) or third-party tools (Hasura, DBeaver, etc.) [source]

Atlas SQL Interface uses Atlas Data Federation (FDI) as its query engine. No self-hosted binary needed. [source]

Connection setup in Tableau: [source]
Select "Other Databases (JDBC)" connector [source]
URL: jdbc:mongodb://atlas-sql-<fdi-id>.mongodb.net:27017/<database>?ssl=true [source]
Class name: com.mongodb.mongosql.MongoSQLDriver [source]
Username/password [source]

DirectQuery performance depends on Atlas query performance. Index optimization applies here too - slow MQL = slow DirectQuery. [source]

Atlas clusters: MongoDB 5.0+ [source]
Self-managed Enterprise: MongoDB 6.0+ (JDBC/ODBC 3.0.1+) [source]
Data Federation is provisioned automatically when Atlas SQL Interface is enabled [source]

Atlas SQL Interface incurs Data Federation query processing costs: [source]
$5.00/TB of data processed per query [source]
Partition strategy and Parquet format reduce costs significantly [source]
DirectQuery workloads (multiple users, frequent refreshes) accumulate more data processed charges than scheduled Import [source]

Verify cluster is on MongoDB 5.0+ [source]
Enable Atlas Data Federation on the project [source]
Map DRDL schema columns to Atlas SQL Interface schema (jsonSchema format) [source]
Update BI tool connection: switch from mongosqld host to FDI hostname [source]

Using BI Connector for new deployments (post-2024): EOL is September 2026; invest in Atlas SQL Interface [source]
DirectQuery without optimizing MongoDB indexes: Every Power BI interaction queries Atlas live; unindexed queries = slow dashboards [source]
Schema auto-infer on heterogeneous collections: Auto-infer samples 1,000 documents and may miss fields in outliers; validate schema explicitly for production [source]
Not setting a Data Federation query byte limit: Runaway DirectQuery workloads can drive significant $5/TB costs [source]

Frontier under this node: Delbridge Data API, Express MongoDB Driver Pattern, FastAPI Motor Pattern, Lambda MongoDB Driver Pattern, RESTHeart