============================================================================== 
Simba MongoDB ODBC Data Connector Release Notes 
============================================================================== 

The release notes provide details of enhancements, features, known issues, and
workflow changes in Simba MongoDB ODBC Connector 2.4.5, as well as the 
version history. 

2.4.5 =======================================================================

Released 2024-08-30

Enhancements & New Features

 * [MDBO-936] UnsetNullColumnsOnUpdate support

   This option determines whether the connector removes columns set to null 
   during update operations. To enable this behavior, set 
   UnsetNullColumnsOnUpdate to 1. For more information, see the 
   Installation and configuration Guide.

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

 * [MDBO-843] In some cases, when inserting a decimal value with a higher 
   precision than the sampled decimal data, a "numeric value out of range" 
   error is expected to be returned.
 
   As a workaround, the decimal column's precision should be increased using 
   the Schema Editor to enable insertion of the data.

 * In some cases, when the connector performs a batch update or insert of 
   decimal values, it returns a "numeric value out of range" error.

   This might occur if the decimal column is set to a low precision in the 
   schema map. To resolve this, in the Schema Editor, increase the precision 
   of the decimal column in the schema map.

 * [MDBO-761] The connector does not support querying and manipulating MongoDB
   documents that have field names containing periods ( . ). 
 
   This is a limitation of the MongoDB server. For more information, see
   https://docs.mongodb.com/manual/reference/limits/#mongodb-limit-Restrictions-on-Field-Names. 

 * [MDBO-745] In some cases, when executing nested select queries, the
   connector returns a "(20030) Memory management error" error message. 

   This issue might occur when setting the DefaultStringColumnLength property 
   to a large value such as 2147483647. In this case, the connector uses a 
   large amount of memory when saving temporary tables generated from the 
   queries, resulting in insufficient available memory. 

   As a workaround, compress the temporary tables by setting the 
   EnableTempTableCompression property to 1. For more information, see the 
   Installation and Configuration Guide.

 * [MDBO-745] Setting the DefaultStringColumnLength property to a large value,
   such as 2147483647, affects the performance of join queries on varchar 
   columns.

 * [MDBO-691] The connector does not support executing SQLStatistics on views.
 
   This is a limitation of the MongoDB server. 

 * [MDBO-501] When connecting through a client application in which 
   auto-commit mode is disabled, the connection fails and the connector 
   returns an error.

   Connections where auto-commit is disabled in the client application are 
   not supported by default.
   
   As a workaround, set the IgnoreTransactions property to 1. For more 
   information, see the Installation and Configuration Guide.

 * When mixed type filtering is disabled, the connector fails to filter
   boolean data when the data includes Boolean and other types.
   
   To successfully filter this kind of data, you must 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 1.

 * 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 
   connector must use a temporary schema definition that is generated during 
   connection time or a persistent schema definition that was created on 
   another platform.

 * Connector 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 connector instead.

 * Connector 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. 
   
 
Workflow Changes ============================================================= 

The following changes may disrupt established workflows for the connector. 


2.4.3 -----------------------------------------------------------------------

 * [MDBO-888] Updated FIPS support documentation

   Beginning with this release, when connecting to MongoDB with FIPSMode 
   enabled, the SCRAM-SHA-1 authentication mechanism cannot be used. For more
   information, see the Installation and Configuration Guide.


2.4.1 -----------------------------------------------------------------------

 * [MDBO-887] Removed support for MongoDB 4.2
 
   Beginning with this release, the connector will no longer support MongoDB 
   server version 4.2. For a list of supported MongoDB versions, see the 
   Installation and Configuration Guide.


2.3.22 -----------------------------------------------------------------------

 * [MDBO-859] Removed support for MongoDB 3.6 and 4.0
 
   Beginning with this release, the connector will no longer support MongoDB 
   server versions 3.6 and 4.0. For a list of supported MongoDB versions, see
   the Installation and Configuration Guide.


2.3.14 -----------------------------------------------------------------------

 * [MDBO-645][MDBO-646] Removed support for the Visual C++ Redistributable for 
   Visual Studio 2013

   Beginning with this release, the connector requires the 2015 version of 
   this dependency instead of the 2013 version. 

   To download the installation packages for the Visual C++ Redistributable 
   for Visual Studio 2015, go to 
   https://www.microsoft.com/en-ca/download/details.aspx?id=48145.

 * [MDBO-641][MDBO-647][MDBO-649][MDBO-762][MDBO-764][MDBO-766][MDBO-768] 
   Removing support for multiple operating systems

   Beginning with this release, the connector no longer supports the following
   operating systems:
   - Windows 7
   - Windows Server 2008 and 2008 R2
   - CentOS 6
   - Red Hat Enterprise Linux (RHEL) 6
   - SLES 11
   - Ubuntu 14.04 and 16.06
   - Debian 6 and 7 
   - macOS 10.9, 10.10, 10.11, and 10.12

   For a list of supported operating systems, see the Installation and 
   Configuration Guide.


2.3.13 -----------------------------------------------------------------------

 * [MDBO-734] Removed support for MongoDB 3.4
  
   Beginning with this release, the driver no longer supports MongoDB 3.4.

 * [MDBO-727] PWD and ENCRYPTED_PWD values
 
   On Windows, when both PWD and ENCRYPTED_PWD are provided in the connection
   string or the registry, the PWD value takes precedence. If PWD is not
   provided, the value from ENCRYPTED_PWD is read. Previously, the password
   was always read from ENCRYPTED_PWD if it was provided.

  
2.3.10 -----------------------------------------------------------------------

 * Updated JSON records

   Previously, if an existing record had key-value pairs that were not 
   specified in an incoming update, these values would continue to exist as 
   part of the JSON record. With this release, the driver default behavior now 
   deletes any key-value pairs that are not specified in a new JSON record. If 
   you want to preserve key-value pairs under these circumstances, you can 
   configure this behavior using the ReplaceDocumentAsJsonOnUpdate property. 
   For more information, see the Installation and Configuration Guide.
  
  
2.3.5 ------------------------------------------------------------------------

 * Removed support for MongoDB 3.0 and 3.2
 
   Beginning with this release, the driver no longer supports MongoDB server 
   versions 3.0 and 3.2. For a list of supported MongoDB versions, see the 
   Installation and Configuration Guide.
   
 
Version History ==============================================================

2.4.4 ------------------------------------------------------------------------


Released 2024-06-07

Enhancements & New Features
   
 * [MDBO-939][MDBO-940] Updated third-party libraries

   The connector now uses the following third-party libraries:
   - mongo c driver 1.27.1 (previously 1.24.4)
   - rapidjson 1.1.0 (previously 1.0.2)
   - zlib 1.3.1 (previously 1.2.13)



2.4.3 ------------------------------------------------------------------------

Released 2023-12-15

Enhancements & New Features
   
 * [MDBO-905] Updated MongoDB support
 
   The connector now supports MongoDB 7.0. For a complete list of supported 
   MongoDB versions, see the Installation and Configuration Guide.


2.4.2 ------------------------------------------------------------------------

Released 2023-08-18

Enhancements & New Features
   
 * [MDBO-891] Improved performance on virtual tables

   The connector's performance on filtered read queries on virtual tables has 
   been improved. For more information, see the Installation and Configuration 
   Guide.

 * [MDBO-902] Updated zlib version

   The connector now uses zlib version 1.2.13. Previously, the connector used 
   zlib version 1.2.11.

 * [MDBO-901] Internal security related improvements

   The connector has been updated with security related improvements.


2.4.1 ------------------------------------------------------------------------

Released 2023-04-28
  
Resolved Issues
The following issue has been resolved in Simba MongoDB ODBC Connector 2.4.1.

 * [MDBO-884] When inserting a timestamp with a date before the year 1601: 
   - on Windows, the connector returns an error. 
   - on Linux, the connector inserts incorrect dates and times.


2.4.0 ------------------------------------------------------------------------

Released 2023-03-02

Enhancements & New Features

 * [MDBO-861] Updated third-party libraries

   The connector now uses the following third-party libraries:
   - cyrus sasl 2.1.28 (previously 2.1.26)    
   - ICU 71.1.x (previously 58.3x)
   - mongo c driver 1.23.0 (previously 1.22.0)
   - OpenSSL 3.0.8 (previously 1.1.1) 
   - Simba Engine SDK 10.2 (previously 10.1)  

 * [MDBO-865] Omit explicit Null columns on update support

   The connector now ignores writing null values for update operations to the 
   server. To do this, select the Omit explicit NULL columns on update check 
   box (set the OmitNullColumnsOnUpdate property to 1). For more information,
   see the Installation and configuration Guide.

 * [MDBO-873] FIPS support

   The connector now supports the FIPS (Federal Information Processing 
   Standards) module to ensure the security, quality, and processing 
   compatibility of various services. For more information, see the 
   Installation and configuration Guide.


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