On this page
- MongoDB Connector for BI 2.10.0
- MongoDB Connector for BI 2.9.0
- MongoDB Connector for BI 2.8.2
- MongoDB Connector for BI 2.8.1
- MongoDB Connector for BI 2.8.0
- MongoDB Connector for BI 2.7.0
- MongoDB Connector for BI 2.6.1
- MongoDB Connector for BI 2.6.0
- MongoDB Connector for BI 2.5.0
- MongoDB Connector for BI 2.4.1
- MongoDB Connector for BI 2.4.0
- MongoDB Connector for BI 2.3.1
- MongoDB Connector for BI 2.3.0
- MongoDB Connector for BI 2.2.1
- MongoDB Connector for BI 2.2.0
- MongoDB Connector for BI 2.1.0
- MongoDB Connector for BI 2.0.0
Released Mar 15, 2019
Fixes a bug where aggregate functions returned
NULLin dual queries with the
Fixes a bug where some invalid
DUALqueries did not return an error.
Fixes a bug that prevented pushdown of some joins to derived tables selecting from
Fixes some correctness bugs in the in-memory evaluation for mysql-mode conversions.
Fixes a bug where some trig functions (
asin) could return incorrect results due to missing type conversions.
Fixes a bug where some subquery comparisons could return incorrect results due to missing type conversions.
Fixes a bug where we lost precision while converting a
Fixes a correctness bug with the
INSERTscalar function's pushdown translation.
Fixes a bug where unstable sorting caused non-deterministic renaming of colliding collection/field names during schema mapping.
Fixes a bug where some valid subquery comparisons returned errors.
Fixes a bug where some valid subquery and tuple comparisons returned errors.
Fixes a bug where queries using
xorreturned errors on MongoDB 3.2 because the generated pipelines required features added in MongoDB 3.4.
Fixes a bug that caused kerberos authentication to fail with MongoDB 4.0.
This release resolves a number of inconsistencies in the BI Connector's date and timestamp semantics. Resolving these inconsistencies resulted in some changes to user-facing behavior:
Removes inconsistent support for partial dates.
MySQL can represent partial dates that are missing month or day components. It is impossible to represent these incomplete dates with MongoDB dates. Attempting to correctly manipulate and render incomplete dates was causing a number of bugs and inconsistencies with complete dates.
Starting with version 2.10, the BI Connector does not support operations on or expressions that return incomplete dates. Going forward, we cannot provide guarantees about the behavior of operations that attempt to construct incomplete dates.
TIMESTAMP(a)scalar functions to be equivalent to
CAST(a AS DATE), and
CAST(a AS DATETIME), respectively.
The behavior of the
TIMESTAMPscalar functions will depend on the value of the
type_conversion_modevariable. This will change the default behavior for those scalar functions.
Queries affected by this change can be rewritten to use a more explicit conversion function (such as
str_to_date) that does not depend on
type_conversion_mode. If an affected query cannot be rewritten, a user may set
mysql, which instructs the BI Connector to perform all type conversions with MySQL semantics instead of MongoDB semantics.
This is discouraged unless absolutely necessary, as it significantly curtails the ability to push down type conversions across the board.
For more information on type conversions and the
type_conversion_modesystem variable, see Type Conversion Modes.
Released Dec 18, 2018
Includes a sample
mongosqldconfiguration file in the release archive.
Allows setting commonly used system variables in the configuration file.
Optimizes conversions of years to days.
General performance improvements.
Improves the BI Connector's resiliency to queries against fields that may contain unsupported BSON types.
Released Nov 16, 2018
Fixes correctness bugs discovered in polymorphic schema mapping, query cancellation, and
Fixes a performance regression in a common query pattern.
Released Nov 09, 2018
Fixes a bug in the behavior of the
Released Nov 06, 2018
Improvements in parsing
Fixes to how the BI Connector honors readPreference specifications.
Released Oct 02, 2018
Collapse associative functions
Improve filter optimization for MongoDB versions 3.6 and later
Expose type_conversion_mode in configuration parameters
Cache catalog columns for quicker lookup
Fix incorrect semantics for null safe equality operator (
||operator returns incorrect type (and value) when operating on two strings
WHEREclause removed in certain cross-join queries
Fix some incorrect left self-join results when dynamic schemas are used
Support turning off view optimization with
MongoDB BI Connector ODBC Driver on macOS should install in versioned directories
Fix MongoDB BI Connector ODBC Driver installer issue on macOS that caused unicode driver to be reported as ANSI
Released version 1.2.0 of the MongoDB BI Connector ODBC Driver.
Released Sep 21, 2018
Resolved an issue caused by how scalar functions handle string values.
We encourage Tableau users running BIC 2.6.0 to upgrade to 2.6.1.
Released Sep 04, 2018
Added EXPLAIN() support.
Push down type conversions to MongoDB servers running version 4.0 or later.
Improved the handling of polymorphic data by updating the BI Connector's type conflict resolution system.
Added Common Table Expression (CTE) support.
SCRAM-SHA-256mechanism to the following:
Released the MongoDB BI Connector ODBC Driver for Linux.
mongosqld --prejoincommand line option for combining array data and non-array data into a single table.
Users can use EXPLAIN to return details of aggregation pipeline used to generate query results.
The BI Connector now supports queries that include Common Table Expressions.
Released May 23, 2018
Improved memory management for
New SSPI support for
NULLvalued types are now cast to varchar during sampling.
TANare now pushed down.
Windows Clients may now use kerberos to authenticate against the BI Connector.
This resolves the issue where queries would fail due to
being ignored during sampling. Now,
NULL values will be cast as SQL
BI Connector will now push down
functions. This will improve performance for queries using these
Released Mar 09, 2018
We've released version 2.4.1 of the MongoDB Connector for BI for production deployment. This release contains minor bug fixes for users of the BI Connector and is a recommended upgrade for all 2.4 users.
Released Feb 21, 2018
Support for 3.6 Aggregate Expressions.
Pushdown for subqueries and non-equijoins.
Killing SQL query now also kills MongoDB operation.
Permission changes for
DRDLfile users. When
mongosqldruns with authentication enabled, admin credentials must be provided with the
--mongo-passwordoptions or the
mongodb.net.auth.passwordsettings in the configuration file.
MongoDB Connector for BI version 2.4 improves more expressive queries. New features include:
BI Connector 2.4 improves support for aggregate expressions including math, date, and string functions.
With version 2.4,
mongosqld has improved support for
subqueries and non-equijoins.
Released Nov 10, 2017
Fixes minor incompatibility with MongoDB 3.2.
Released Nov 08, 2017
Simplified and centralized Schema Management.
Supports log rotation.
Standardized logging in the BI Connector.
TRIMfunctions down to MongoDB.
MongoDB Connector for BI version 2.3 improves enterprise deployment support. The new features include:
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.
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:
Provides a Windows MSI installer for the MongoDB Connector for BI.
Provides new command line arguments for default auth mechanism and database:
- default user source (default of
- default authentication mechanism (default of SCRAM-SHA-1)
Provides a new startup option to specify default VARCHAR length
Reports the following metrics reported:
Can bind mongosqld to multiple IP addresses
Provides a new runtime options to limit memory usage of
MongoDB Connector for BI Version 2.0 introduced passthrough authentication, in which clients authenticate as a user defined in MongoDB, without the need to create a separate user within the connector itself.
MongoDB Connector for BI Version 2.2 further increases ease of use with a set of authentication plugins which can authenticate users through the connector without the need for SSL certificates. These plugins perform user authentication via the SASL framework and support the SCRAM-SHA-1 and PLAIN authentication mechanisms. We currently provide authentication plugins in the following languages:
Provides substantial performance improvements for some common
$matchstages 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
SHOW CREATE TABLEstatements,
STRAIGHT_JOIN, the unary plus (
+) operator, and the
INTERVALkeyword in date arithmetic.
Released Nov 29, 2016
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.
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.
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,
mongosqldresponds to SQL queries, requests for DB information, and schema from the requesting BI tool via the MySQL wire protocol.
MongoDB Connector for BI Version 2.x is compatible with SQL-99 SELECT statements, and uses the MySQL wire protocol.
Released Jan 5, 2017
Released Dec 13, 2016
Fixes precedence issue with the
Fixes error looking up privilege information in databases with capital letters.
LIKEpattern matching in
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.