fbpx Skip to content

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
Mongodb ODBC Driver

Light-up features in your analytic applications by connecting to your MongoDB data with Simba MongoDB ODBC and JDBC drivers 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.

Learn More

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.