MongoDB ODBC & JDBC Driver

Leverage the power and convenience of SQL for real-time analytics and reporting

Current Versions ODBC 2.3.9 | JDBC 1.3.11

OEM & Distribution
  • DB Visualizer
  • Excel
  • Looker
  • Microstrategy
  • NoSQL
  • Other JDBC
  • Other ODBC
  • PowerBI
  • SAP
  • Sisense
  • Tableau

Light-up features in your analytic applications by connecting to your MongoDB data with Magnitude Simba MongoDB ODBC and JDBC connectors with SQL Connector.

Make quick analytic insights by leveraging high-performance query and calculation capabilities of both single and distributed instances of MongoDB. Since MongoDB is a schema-less data source, the SQL Connector defines schemas on the fly providing a low touch SQL window to MongoDB data. Further schema refinements are possible via the newly designed Schema Editor. High-performance data access is achieved through Simba SQL Engine’s built-in Collaborative Query Execution (CQE) ensuring filter and aggregation workflows are passed directly to MongoDB rather than being processed within a client application or intermediary system.

Features

  • Access MongoDB 4.2 data via SQL from analytic applications such as Microsoft Excel, Power BI, Qlikview, Tableau and more
  • Unicode enabled 32- and 64-bit ODBC 3.8 compliant connector for Windows, Mac OS X, Linux and AIX
  • Connects via MongoDB’s native API for support of both on-premise and cloud deployments of MongoDB
  • Automatic schema generation and normalization of arrays as virtual tables
  • Extensive performance improvements through the use of the MongoDB Aggregation Framework for passing down aggregation operations, double buffering when reading data, and improved write performance via the MongoDB batching interface
  • Updated Schema Editor allows for new and improved re-normalization workflows such as data preview and array flattening
  • Improved security with new authentication support for Kerberos and LDAP as well as per connection SSL configuration
  • Simple per-host licensing (server or desktop). The license cost is the same for any number of installed processors or cores (virtual or physical).
  • Departmental, enterprise and worldwide licensing available on request.

Specifications

Supports MongoDB 4.2 including WiredTiger storage engine
Supports 32- and 64-bit applications
Complies with latest ODBC 3.8 specification
Supports ANSI SQL-92
Complies with the latest JDBC 4.0, 4.1 and 4.2 specification
Supports Unicode
Supports multiple platforms, including Windows, Linux and Mac OS
Supports many MongoDB data types (DBPointer, JavaScript, JavaScript (with scope), MaxKey, MinKey, Regular Expression, Symbol, Timestamp, and Undefined)
Supports JSON-formatted strings
Supports for UPSERT
Join operations pass down for increased performance
Support for DML for both base and virtual tables
Improved security with new authentication support for Kerberos and LDAP as well as per connection SSL configuration

Documentation

User Guides, Release Notes, and FAQs.

Ready to buy? We're here to help!

If you are evaluating our drivers or our Simba SDK, our Sales Engineers would be happy to assist you.