Release Notes for MongoDB Connector for BI¶
On this page
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
andTRIM
functions down to MongoDB.
MongoDB Connector for BI version 2.3 improves enterprise deployment support. The new features include:
Improved Schema Management¶
In BI Connector 2.3, mongosqld includes the schema mapping functionality previously found in mongodrdl.
Log Rotation¶
With version 2.3, you can rotate the mongosqld logs. To rotate the logs, issue a command
or restart mongosqld
.
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:
--defaultAuthDatabase
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
, andJOIN
stages
Authentication Plugins¶
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:
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
andSHOW CREATE TABLE
statements,STRAIGHT_JOIN
, the unary plus (+
) operator, and theINTERVAL
keyword in date arithmetic.
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:
mongodrdl
- 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.
mongosqld
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 withmongodrdl
before startingmongosqld
.
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
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 inSHOW 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.