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
- 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.Important
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.
- The behavior of the
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
- 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
- Support the
- Support the
- 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.
- Added the
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
--sampleNamespacesoption now supports exclusion.
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:
- 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:
- 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:
- Threads Connected
- 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.