Release Notes for MongoDB Connector for BI

MongoDB Connector for BI 2.3.1

Released Nov 10, 2017

  • Fixes minor incompatibility with MongoDB 3.2.

MongoDB Connector for BI 2.3.0

Released Nov 08, 2017

  • Simplified and centralized Schema Management.
  • Supports log rotation.
  • Standardized logging in the BI Connector.
  • Push LTRIM, RTRIM and TRIM functions down to MongoDB.

MongoDB Connector for BI 2.2.1

Released Aug 29, 2017

  • Fixes lack of support for Read Preference tags which are used when targeting reads to specific members of a replica set.

MongoDB Connector for BI 2.2.0

Released Jul 31, 2017

  • Supports authenticating directly against MongoDB using the new C and JDBC authentication plugins. These plugins support SCRAM-SHA-1 and PLAIN mechanisms and remove the SSL requirement for authentication. The authentication plugins can be found on GitHub:

  • Supports configuration files for mongosqld.

  • Supports installing and running mongosqld as a Windows system service.

  • Provides a Windows MSI installer for the MongoDB Connector for BI.

  • Provides new command line arguments for default auth mechanism and database:

    • Authentication Options:


      default user source (default of admin)

      --defaultAuthMechanism arg

      default authentication mechanism (default of SCRAM-SHA-1)

  • Provides a new startup option to specify default VARCHAR length

  • Provides mongosqld status metrics with SHOW STATUS

    • Reports the following metrics reported:
      • Connections
      • Queries
      • BytesSent
      • Threads Connected
  • Can bind mongosqld to multiple IP addresses

  • Provides a new runtime options to limit memory usage of GROUP, SORT, and JOIN stages

MongoDB Connector for BI 2.1.0

  • Provides substantial performance improvements for some common JOIN scenarios.
  • Pushes $match stages earlier in the aggregation pipeline to improve to index utilization.
  • Pushes down more SQL functions and operators to the aggregation pipeline.
  • Supports additional SQL language features, such as USE and SHOW CREATE TABLE statements, STRAIGHT_JOIN, the unary plus (+) operator, and the INTERVAL keyword in date arithmetic.


mongosqld no longer offers the --fork option.

To run mongosqld in the background, use the nohup command:

nohup mongosqld [options] &

MongoDB Connector for BI 2.0.0

Released Nov 29, 2016

Improved Server-Side Execution

The MongoDB Connector for BI delivers significant performance and scalability improvements by moving as much execution as possible to the underlying MongoDB instance. Pushing execution down to the server reduces network latency and reduces bandwidth consumption.

This approach also reduces memory and CPU consumption in the MongoDB Connector for BI itself.

Pass-through Authentication

The user authentication process is now passed through the MongoDB Connector for BI to the underlying MongoDB instance. Users now authenticate as a user already created within MongoDB.

Simplified Architecture

The MongoDB Connector for BI package is now trimmed down from four separate components to two:

This tool connects to a MongoDB instance and generates a Document-Relational Definition Language (DRDL) file, which maps a given collection shape to relational schema.

Once installed and run as a daemon, mongosqld responds to SQL queries, requests for DB information, and schema from the requesting BI tool via the MySQL wire protocol.

mongosqld requires at least one DRDL file to start. You will need to have defined your schema with mongodrdl before starting mongosqld.

SQL Compatibility

MongoDB Connector for BI Version 2.x is compatible with SQL-99 SELECT statements, and uses the MySQL wire protocol.

MongoDB Connector for BI 2.0.2

Released Jan 5, 2017

  • Hides .pem key file passwords in logs.
  • mongodrdl ignores binary fields when generating DRDL files.
  • Supports queries that SELECT variables prefixed with “mongodb”.
  • Fixes incorrect result set from a CROSS JOIN.
  • Supports leading “.” characters on table names.

MongoDB Connector for BI 2.0.1

Released Dec 13, 2016

  • Fixes precedence issue with the NOT operator.
  • Fixes error looking up privilege information in databases with capital letters.
  • Supports LIKE pattern matching in SHOW COLUMNS queries.
  • Improves formatting of aggregation pipeline in logs.
  • Fixes substring function when the combined length of the starting index and substring exceeds the length of the string.

MongoDB Connector for BI 1.0.0

Released Dec 8, 2015

MongoDB Connector for BI 1.0 is now available. It allows users to visualize their MongoDB Enterprise data using existing relational business intelligence tools.

MongoDB Connector for BI 1.1.3

Released Apr 4, 2016

  • Improves JOIN performance.
  • Supports packages for Debian and Ubuntu.

MongoDB Connector for BI 1.1.2

Released Feb 3, 2016

  • Pushes down the ORDER BY clause as a $sort stage in the aggregation pipeline.

MongoDB Connector for BI 1.1.1

Released Jan 27, 2016

  • Ignores collections prefixed with “system.” when generating the DRDL file for a database with mongodrdl.
  • Checks if file is writable before sampling when generating the DRDL file with program:mongodrdl.

MongoDB Connector for BI 1.1.0

Released Jan 12, 2016

  • Supports renaming columns using the sqlname field in DRDL files.
  • Supports the mongotype: geo.2darray DRDL field for mapping geospatial data.