# MongoSQL ODBC Driver > Depth-first rabbithole dossier for MongoSQL ODBC Driver; source-anchored research pack. Parent: [Atlas SQL Interface MongoSQL](https://llms-explorer.com/tree/atlas-sql-interface-mongosql/) · 5 facets · 26 facts · page: https://llms-explorer.com/tree/mongosql-odbc-driver/ ## Definitions - [high] The MongoDB ODBC driver is a 64-bit Unicode-only driver that does not support ANSI functions and is required to use the MongoDB Atlas SQL Connector. Sources: https://github.com/mongodb/mongo-odbc-driver, https://learn.microsoft.com/en-us/power-query/connectors/mongodb-atlas-sql-interface — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] MongoSQL schemas are not cached and adapt to data natively, allowing refresh at any time without impacting connectivity. Sources: https://www.mongodb.com/docs/sql-interface/index.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` ## How it works - [medium] All three SQL Interface deployment options use the same JDBC and ODBC drivers, and a federated database instance is used when a single SQL query must span multiple data sources like clusters or S3 buckets. Sources: https://www.mongodb.com/docs/sql-interface/index.md, https://www.mongodb.com/docs/sql-interface/connect.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] MongoSQL is not fully SQL-92 compatible because it does not support the `date` data type (use `timestamp` instead), interval arithmetic, MongoDB Vector Search, or MongoDB Search. Sources: https://www.mongodb.com/docs/sql-interface/language-reference.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` ## Measurements and reference values - [low] MongoSQL automatically rotates logs when the file size reaches 0.5MB and keeps up to 10 log files. Sources: https://www.mongodb.com/docs/sql-interface/install-driver.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#tools` ## Problems, failure modes and limitations - [low] MongoSQL converts flexible document values into types using a schema, and queries fail to compile if static type constraints are not satisfied. Sources: https://www.mongodb.com/docs/sql-interface/language-reference.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] If a connection cannot be established, the driver may display the generic error message `The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.80`. Sources: https://learn.microsoft.com/en-us/power-query/connectors/mongodb-atlas-sql-interface — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#troubleshooting` ## Facts and statements - [low] The MongoDB SQL Interface allows querying clusters from BI tools like Tableau and Power BI over ODBC and JDBC drivers without requiring a federated database instance. Sources: https://www.mongodb.com/docs/atlas/cluster-additional-settings.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] The MongoDB ODBC driver is compatible with Windows and Linux glibc 2.34+ (x86_64 and arm64 architectures). (verified as of 2026-10-15) Sources: https://www.mongodb.com/docs/sql-interface/install-driver.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#tools` - [medium] MongoDB officially supports Tableau (Desktop, Server, or Cloud) and Power BI Desktop (Desktop and Service) with its JDBC and ODBC drivers, though compatibility with other SQL-92 compatible tools is not guaranteed. Sources: https://www.mongodb.com/docs/sql-interface/install-driver.md, https://www.mongodb.com/docs/sql-interface/connect.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#tools` - [low] To install the MongoDB ODBC driver, download and import the public key from https://pgp.mongodb.com/atlas-sql-odbc.asc, set the Driver value to the absolute path of mongoodbc.dll, and verify installation via registry query. Sources: https://github.com/mongodb/mongo-odbc-driver — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#tools` - [low] Successful installation of the MongoDB Atlas SQL ODBC Driver creates a new entry called ADF_ODBC under ODBC/ODBCINST.INI in the registry. Sources: https://github.com/mongodb/mongo-odbc-driver — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#tools` - [low] In the JDBC Settings tab, the Driver Name is `MongoSQL` and the Class Name is `com.mongodb.jdbc.MongoDriver`, requiring the addition of the `all.jar` file in the Libraries tab. Sources: https://www.mongodb.com/docs/sql-interface/connect.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#tools` - [high] The MongoDB Atlas SQL Interface provides live, read-only access to data using the MongoSQL dialect, which is based on the SQL-92 standard. Sources: https://www.mongodb.com/docs/sql-interface/index.md, https://www.mongodb.com/docs/sql-interface/language-reference.md, https://mongodb.com/company/blog/product-release-announcements/real-time-insights-through-atlas-sql-interface — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] The SQL Interface does not support insert, update, or delete operations on any deployment and does not support SQL dialects other than MongoSQL. Sources: https://www.mongodb.com/docs/sql-interface/index.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] MongoSQL data types are based on BSON types, and explicit type conversions are performed via the `CAST` function or `::` operator. Sources: https://www.mongodb.com/docs/sql-interface/language-reference.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] Numeric types in MongoSQL are mutually comparable without requiring casting to the same numeric type. Sources: https://www.mongodb.com/docs/sql-interface/language-reference.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] MongoSQL requires nested `SELECT` statements to have an alias, and duplicate checking follows MongoDB equality semantics where field and element order matter. Sources: https://www.mongodb.com/docs/sql-interface/language-reference.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] MongoSQL sorts `MISSING` before `NULL`, and `NULL` before all other values. Sources: https://www.mongodb.com/docs/sql-interface/language-reference.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] MongoSQL does not support `INTERSECT` or `EXCEPT` set operations. Sources: https://www.mongodb.com/docs/sql-interface/language-reference.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] MongoSQL identifiers support all UTF-8 characters except the null character `\x00` and are case-sensitive regardless of delimiters. Sources: https://www.mongodb.com/docs/sql-interface/language-reference.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] Starting in MongoSQL 2.0.0, array functions allow native operation on array values within queries. (verified as of 2026-10-15) Sources: https://www.mongodb.com/docs/sql-interface/language-reference.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#core` - [low] The MongoDB JDBC driver is compatible with Windows x86_64, macOS x86_64 and aarch64, and Linux x86_64 and arm64 architectures. Sources: https://www.mongodb.com/docs/sql-interface/install-driver.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#tools` - [low] By default, MongoSQL writes logs to a file named `mongo_odbc.log` in the `logs` folder, with a default log level of `info`. Sources: https://www.mongodb.com/docs/sql-interface/install-driver.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#tools` - [low] If settings are defined in both the driver and the connection string, the connection string setting takes precedence. Sources: https://www.mongodb.com/docs/sql-interface/install-driver.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#tools` - [low] At the `FINER` log level, the driver logs every call that retrieves data for each cell of each result set. Sources: https://www.mongodb.com/docs/sql-interface/connect.md — source: `~/.global-ai-hub/research/.pipeline/mongodb-2026-10-14/frb/mongosql-odbc-driver-05b558df2a/rabbithole-synthesis.md#troubleshooting` ## Related concepts - MongoSQL — is a part of MongoSQL ODBC Driver - Driver — is a part of MongoSQL ODBC Driver - ODBC — is a part of MongoSQL ODBC Driver