MongoSQL ODBC Driver
Parent: Atlas SQL Interface MongoSQL · Published reference · snapshot 2026-10-24 · viability 3.00 / 5 (skip)
↓ Facts as markdownall context files
Source-anchored research for MongoSQL ODBC Driver. Run status: COMPLETED.
These notes link each claim to its source. Some citations identify archived research reports that are no longer hosted on this site. A published reference means the content is available; it does not certify independent review or accuracy.Read the editorial policy and follow the sources before relying on a claim.
Definitions
- The MongoDB ODBC driver is a 64-bit Unicode driver using the MongoSQL dialect. Its repository explicitly distinguishes it from the separate MongoDB Connector for BI ODBC driver. (low confidence) [source]
- The MongoSQL ODBC driver is a 64-bit Unicode driver for Atlas SQL connectivity; the Power BI MongoDB Atlas SQL connector requires this native driver. (high confidence) [source]
How it works
- Power BI connection dialogs expect a MongoDB URI without embedded username or password; credentials in the URI are rejected. Supply the database separately and use the connector authentication flow. (high confidence) (verified as of 2026-10-09) [source]
- A December 18, 2024 issue reports a segmentation fault using ODBC 1.4.2 in Ubuntu 22.04.5 Docker; the accompanying log says libmongosqltranslate.so could not be loaded from /opt/mongodb/atlas-sql-odbc-driver. This is a historical user report, not proof of the cause or of a current-release defect. (low confidence) [source]
- A first-hand Power BI forum report describes SQLSTATE 22018 while loading a true/false column through the MongoDB Atlas SQL connector; excluding the column allowed the table to load. Suggested Boolean conversion workarounds in replies do not establish a confirmed driver root cause or fix. (low confidence) [source]
Problems, failure modes and limitations
- Windows installation requires Microsoft Visual C++ Redistributable 17.0 or later. A missing runtime can produce a module-not-found error even when the driver DLL exists. (low confidence) (verified as of 2026-10-24) [source]
- Microsoft describes SQL_DRIVER_ODBC_VER: 03.80 as a generic connection-failure message and recommends first checking credentials and network access to the federated database. That message alone does not establish an ODBC version mismatch. (high confidence) (verified as of 2026-10-09) [source]
- MongoDB documents Windows and Linux glibc 2.34+ on x86_64 and arm64 for ODBC. Windows requires Microsoft Visual C++ Redistributable 17.0 or later; missing runtime libraries can produce a module-not-found error even when the driver DLL exists. (low confidence) (verified as of 2026-10-14) [source]
Facts and statements
- The Power BI MongoDB SQL connector requires the MongoDB Atlas SQL ODBC driver and supports both Import and DirectQuery modes. (high confidence) (verified as of 2026-10-09) [source]
- MongoDB documents ODBC installation for Windows and Linux with glibc 2.34 or later; Linux arm64 support was added in ODBC 2.0.9 on July 23, 2026. (high confidence) (verified as of 2026-07-23) [source]
- ODBC availability does not guarantee support in every BI tool. MongoDB disclaims guaranteed compatibility outside its officially supported tools, and Qlik explicitly lists the MongoDB Atlas SQL driver as unsupported by its ODBC via Direct Access gateway connector. (high confidence) (verified as of 2026-10-23) [source]
- The driver README lists ANSI functions as unsupported and also lists SQLBindParameter, SQLPrepareW and SQLEndTran among unsupported ODBC calls. Applications that depend on these calls need compatibility checks. (low confidence) (verified as of 2026-10-24) [source]
- MongoDB Security Alerts identifies CVE-2026-19503 as insufficient OIDC endpoint scheme validation affecting Atlas SQL ODBC versions from 1.0.0 before 2.0.9. The July 23 changelog says 2.0.9 validates HTTPS before opening an authorization URL; CERT-In also lists Atlas SQL ODBC versions before 2.0.9 as affected in its advisory. (high confidence) (verified as of 2026-08-17) [source]
- The July 23, 2026 ODBC 2.0.9 release removes the OpenSSL requirement and switches secure connections to rustls. Instructions requiring OpenSSL for older driver generations should be checked against the installed ODBC release. (low confidence) (verified as of 2026-07-23) [source]
- The repository directs Connector for BI users to a different ODBC-driver repository. Its Atlas Data Federation description should not be read as an exhaustive deployment restriction: MongoDB connection documentation also supports configured Atlas dedicated clusters and self-managed Enterprise Advanced through the same ODBC driver. (medium confidence) (verified as of 2026-10-14) [source]
- MongoSQL release documentation identifies libmongosqltranslate as the library used by ODBC and JDBC drivers for on-premises and direct-cluster queries. (low confidence) [source]
- Power BI exposes both Import and DirectQuery through MongoDB Atlas SQL. MongoDB documents driver version 1.2 or later for DirectQuery and says a DSN is unnecessary for the Power BI connector. (high confidence) (verified as of 2026-10-14) [source]
- For a general Windows ODBC connection, configure a System DSN with the MongoDB Atlas SQL ODBC Driver and the deployment URI, database and credentials. Power BI connector users can instead supply the URI and database directly. (high confidence) [source]
Children
- No children recorded.