6 MONGODB

============================================================================= Simba MongoDB ODBC Driver with SQL Connector Release Notes =============================================================================

The release notes provide details of enhancements, features, and known issues in Simba MongoDB ODBC Driver 2.3.0, as well as the version history.

2.3.0 =======================================================================

Released 2017-11-30

Enhancements & New Features

Support for SQLStatistics

The driver now supports the SQLStatistics function.
Support for SQL_COLLATION_SEQ

The driver now returns a value for SQL_COLLATION_SEQ when SQLGetInfo is called.
Random sampling strategy

The driver now has the option to sample data store records randomly or sequentially when creating or editing the database schema. This is configured using the Sampling Method option. For more information, see the Installation and Configuration Guide. This feature is only supported by MongoDB Server 3.2 or higher.
New column added to SQLColumns result sets

A custom SOURCE_NAME column has been added to the SQLColumns result set. The colunn contains the fully qualified field path in the BSON document that maps to the respective column.
Configurable socket timeout

The driver can now be configured to time out when attempting to send or receive on a socket. For more information, see the Socket Timeout configuration option in the Installation and Configuration guide.
Cursor timeout option

The driver can now be configured to prevent cursors on the data source server from timing out. For more information, see the No Cursor Timeout configuration option in the Installation and Configuration guide.

Resolved Issues

The following issue has been resolved in Simba MongoDB ODBC Driver 2.3.0.

The driver doesn’t recognize values set in the Step Size (SamplingStepSize).

Known Issues The following are known issues that you may encounter due to limitations in the data source, the driver, or an application.

Driver does not work on some recent versions of Linux distributions, due to an inconsistency in the cyrus-sasl version that is used.

The driver requires libsasl2.so.2, but some Linux distributions have upgraded to use libsasl2.so.3 instead. As a workaround, run the following commands to create a symbolic link between libsasl2.so.2 and libsasl2.so.3:

sudo ln -s /usr/lib64/libsasl2.so.3 /usr/lib64/libsasl2.so.2 sudo ln -s /usr/lib/libsasl2.so.3 /usr/lib/libsasl2.so.2
Driver fails to filter Boolean data when mixed type filtering is disabled.
If filtering for Boolean data is required, enable mixed type filtering by selecting the “Enable Mixed Type Filter” check box in the DSN Setup dialog box or by setting the EnableMixedTypeFilter connection property to
Driver versions 2.1.0 and later fail to connect using Kerberos authentication.

At this time, you cannot authenticate the connection using Kerberos when using version 2.1.0 or later of the driver.
On AIX, you cannot create new schema definitions using the Schema Editor.

The Schema Editor application is not supported on AIX, so you cannot create and save new schema definitions. When connecting to a database, the AIX driver must use a temporary schema definition that is generated during connection time or a persistent schema definition that was created on another platform.
Driver does not use the maximum string column length specified through the Schema Editor.

As a workaround, configure the maximum string column length by using the String Column Size configuration option (the DefaultStringColumnLength key) in the driver instead.
Driver does not prevent you from specifying MongoDB column and table names that contain invalid syntax.
UPDATE statements are not supported for columnar views of arrays.
Aggregation passdown requires the field being passed down to contain data that is all of the same type.

Version History =============================================================

2.2.7 ———————————————————————–

Released 2017-10-13

Enhancements & New Features

Logging file name format

The format of the log file names have been updated, and can now be configured to include a user name prefix. See the Installation and Configuration Guide for details.

Resolved Issues

The following issue were resolved in Simba MongoDB ODBC Driver 2.2.7.

Driver will only sample from databases that the user has rights to query.

2.2.6 ———————————————————————–

Released 2017-09-01

Enhancements & New Features

Work with JSON-formatted strings

The driver can be configured to retrieve or store whole documents as JSON- formatted strings. See the installation and configuration guide for more details.

2.2.5 ———————————————————————–

Released 2017-08-11

Enhancements & New Features

Mixed type filtering is now configurable

You can now specify whether or not the driver uses mixed type filtering, which allows a value to pass the filter even if it is not the same data type as the specified filter term. To enable or disable this feature, set the “Enable Mixed Type Filter” option (the EnableMixedTypeFilter connection property).

2.2.4 ———————————————————————–

Released 2017-08-09

Enhancements & New Features

AIX support

You can now install and run the driver on machines that run 64-bit editions of AIX.

2.2.3 ———————————————————————–

Released 2017-07-07

Enhancements & New Features

More descriptive value returned for SQL_DBMS_NAME

When SQLGetInfo is called, the driver now returns “MongoDB” as the SQL_DBMS_NAME value. Previously, the driver returned “TEXT”.

Resolved Issues The following issue has been resolved in Simba MongoDB ODBC Driver 2.2.3.

UNION operations fail if the String Column Size driver option (the DefaultStringColumnLength property) is set to a large value.

2.2.2 ———————————————————————–

Released 2017-05-22

Resolved Issues The following issue has been resolved in Simba MongoDB ODBC Driver 2.2.2.

The connection setting “Documents To Fetch Per Block” affects the number of rows retrieved.

2.2.1 ———————————————————————–

Released 2017-04-12

Resolved Issues The following issues were resolved in Simba MongoDB ODBC Driver 2.2.1.

Error when using OR operator on two SQL filters.
Driver ignores OdbcParameter when executing an OdbcCommand multiple times.
Virtual tables are overwritten when there are naming conflicts during schema generation.

2.2.0 ———————————————————————–

Released 2017-03-29

Enhancements & New Features

Updated MongoDB Support

Views defined in MongoDB 3.4 are sampled as read-only tables. If there is nested data inside the view, the driver will renormalize the nested data into virtual tables as normal.
Support for Decimal Data Types

The driver will now support Decimal data types.
Map Version Tracking

Schema maps that are saved to a file or published to a data source now contain a version number indicating the version of the schema map generated by a driver. This version number is used to prevent older versions of a driver attempting to read schema maps created by newer versions of a driver. Drivers newer than what was used to create a schema map can continue to read older schema map files however these schema maps will be updated to the latest version when saved to a file or published to a data source.
Updated MacOS and Linux Environment Variable

The name of the INI environment variable in non-windows installations has been updated to “SIMBA_MONGODB_ODBC_INI”.
Column Precision and Column Scale

When sampling data the driver will now calculate the maximum precision and scale of the current column data. This information will appear in the properties for those columns. These properties do not affect non-numeric data directly, but they are used if the data is converted to a numeric type.

Resolved Issues The following issues have been resolved in Simba MongoDB ODBC Driver 2.2.0.

Chinese characters not being properly encoded.

==============================================================================