MongoDB ODBC & JDBC Driver
Leverage the power and convenience of SQL for real-time analytics and reporting
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 |
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.