MongoDB ODBC Driver with SQL Connector

Deliver full application functionality and real-time analytic capabilities to users.

SQL access made easy.

MongoDB ODBC Driver with SQL Connector DiagramMongo DB Logo

Light up features in  BI clients by connecting to your MongoDB data in a powerful, effective way to access, analyze, and report. Simba’s ODBC connector allows to you to make quick analytic insights and to leverage back end data source high performance calculation capabilities for your favorite BI client. Since MongoDB is schema-less, a powerful mechanism within the SQL Connector allows users to define schemas on the fly for use by the ODBC 3.8 driver, providing a powerful SQL window to MongoDB data.

MongoDB supports “standalone” or single-instance operations and production MongoDB deployments that are distributed by default. MongoDB users combine replica sets and sharded clusters to provide high levels of redundancy for large data sets transparently for applications. Simba SQL Engine’s built-in Collaborative Query Execution (CQE) passes down filters and aggregations to provide high-performance access to MongoDB. Any traditional, SQL-based BI or analytics tool can easily connect and quickly deliver performance and broad compatibility, and ensure full functionality for users analyzing and reporting on Big Data.

Product Highlights

  • SQL Interface for MongoDB Data
  • Simple per-host licensing (server or desktop). The license cost is the same for any number of installed processors or cores (virtual or physical).
  • Preserves nested MongoDB document structure by translating it into hierarchical SQL schema of virtual tables
  • Bundled Schema tool allows fine-tuning of the mapping between schema-less MongoDB data structure and relational SQL schema
  • Supports the latest MongoDB 3.0 including WiredTiger storage engine for improved performance and more efficient resource utilization
  • Automatic registration of the driver with ODBC Administrator for streamlined installation process on OS X
  • Complies with the latest ODBC 3.52 data standard
  • Adds important functionality such as Unicode and 32- and 64-bit support

Product Features

  • Powerful SQL Connector allows users to define schemas on the fly on schema-less data
  • Direct BI connectivity to data without extraction
  • Full compatibility with leading analytic/reporting apps, including Microsoft Excel & Access, SAP Crystal Reports, Tableau and more
  • Support for MongoDB 3.0 including WiredTiger storage engine for improved performance and more efficient resource utilization
  • Adds SQL-92 capabilities to MongoDB
  • Adds aggregation and join capabilities for queries
  • Leverages MongoDB’s native filtering and aggregation capabilities
  • Provides full driver and query metadata
  • Improved UI for the Schema Editor and the Windows driver
  • Optimized joins between virtual tables
  • Automatic registration of the driver with ODBC Administrator for streamlined installation process on OS X

Product Specifications

  • Supports 32- and 64-bit applications
  • Supports MongoDB 3.0 including WiredTiger storage engine
  • Complies with latest ODBC 3.8 specification
  • Supports Unicode
  • Supports Windows, RedHat, SUSE, Solaris, AIX, HP-UX and Mac OS X platforms
  • Supports ANSI SQL-92
  • Supports dynamic schema generation via intelligent data sampling
  • Connects via MongoDB’s native API
  • Uses legacy C++ client libraries v.1.0.2 RC0
  • Supports on-premise and cloud environments

Product FAQ

FREE Trial

A password will be emailed to you.

Contact Sales

+1 (604) 633-0008
solutions@simba.com

Webinar

How to Build an ODBC Driver in Just 5 Days!

Play Webinar