8 NETEZZA

============================================================================== Magnitude Simba Netezza ODBC Data Connector Release Notes ==============================================================================

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

1.0.13 =======================================================================

Released 2021-06-30

Enhancements & New Features

  • [NZO-709] TLS 1.2 support

The connector now supports TLS 1.2. To specify the version of TLS/SSL, from the SSL Version drop-down list, select the TLS/SSL version (set the SSLVersion property to the TLS/SSL version). For more information, see the Installation and Configuration Guide.

  • [NZO-752] Updated ICU library

The connector now uses ICU version 58.3.x. Previously, the connector used version 58.2.x.

Resolved Issues The following issue has been resolved in Simba Netezza ODBC Connector 1.0.13.

  • [NZO-740] SQLGetInfo incorrectly returns "TEXT" for SQL_DBMS_NAME.

This issue has been resolved. SQLGetInfo now returns "NetezzaSQL" for SQL_DBMS_NAME. However, SQLGetInfo continues to return the connector binary name for SQL_DRIVER_NAME, as per the ODBC documentation.

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

  • The connector takes longer than expected to process bulk inserts that use an array of parameters.

  • Translations of functions nested within the same {fn } block are not supported.

The connector does not support functions that are nested within the same {fn } block. For example, the following is not supported by the connector, because convert and substring are nested within the same {fn } block:

  SELECT tm_col2 FROM DBF.TIME_ 
  WHERE {fn SECOND(tm_col2)}={fn convert(substring(tm_col2||'',7,2),
  SQL_INTEGER)}

As a workaround, specify an additional function block. For example, the following is supported by the connector, because substring is now within its own {fn } block:

  SELECT tm_col2 FROM DBF.TIME_ 
  WHERE {fn SECOND(tm_col2)}={fn convert({fn substring(tm_col2||'',
  7,2)},SQL_INTEGER)}

Workflow Changes =============================================================

The following changes may disrupt established workflows for the connector.

1.0.13 -----------------------------------------------------------------------

  • [NZO-700] Removing support for earlier versions of Linux

Beginning with this release, the connector no longer supports the following operating systems: - CentOS 6 - Red Hat Enterprise Linux (RHEL) 6
- Debian 8

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

1.0.11 -----------------------------------------------------------------------

  • [SF-798][SF-796] Removing support for earlier versions of Windows

Beginning with this release, the connector no longer supports the following operating systems: - Windows 7 - Windows Server 2008 - Windows Server 2008r2 - SLES 11

In addition, the connector no longer supports Visual Studio 2013.

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

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

1.0.12 -----------------------------------------------------------------------

Released 2020-12-31

Enhancements & New Features

  • [NZO-729] Updated OpenSSL version

The driver now uses OpenSSL version 1.1.1g. Previously, the driver used OpenSSL version 1.1.1d.

1.0.11 -----------------------------------------------------------------------

Released 2020-10-08

Enhancements & New Features

  • [NZO-650] Reporting the maximum length of database fields

You can now specify the maximum character length that the driver reports for the names of catalogs, columns, schemas, and tables. To do this, set the following new advanced options: - Max Catalog Name Length (the MaxCatalogNameLen property) - Max Column Name Length (the MaxColumnNameLen property) - Max Schema Name Length (the MaxSchemaNameLen property) - Max Table Name Length (the MaxTableNameLen property)

For more information, see the Installation and Configuration Guide.

  • [NZO-721] Updated logging configurations

The logging configurations for a particular connection can now be passed in via the connection string or DSN. For more information, see the Installation and Configuration Guide.

  • [NZO-701] Additional operating system support

The driver now supports the following additional operating systems: - Windows Server 2019 - Red Hat Enterprise Linux (RHEL) 8 - CentOS 8 - SUSE Linux Enterprise Server (SLES) 15

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

1.0.10 -----------------------------------------------------------------------

Released 2020-09-11

Resolved Issues The following issues have been resolved in Simba Netezza ODBC Driver 1.0.10.

  • [NZO-652] When the driver is installed on a machine that uses Turkish locale settings, if you try to connect using a connection string where one or more of the property names contains a lower-case "i" character, the driver fails to parse the string and does not connect to the server.

  • [NZO-712] When you perform an insert using parameters, and the parameter string includes a single quote ('), the driver terminates unexpectedly.

  • [NZO-712] When you perform a bulk insert using an array of parameters, the driver hangs.

1.0.9 ------------------------------------------------------------------------

Released 2020-01-08

Enhancements & New Features

  • [NZO-645] Updated Expat library

The driver has been updated to use version 2.2.9 of the Expat library. Previously, the driver used version 2.2.0.

Resolved Issues The following issue has been resolved in Simba Netezza ODBC Driver 1.0.9.

  • [NZO-691] Running queries in parallel on large amounts of data affects the driver performance.

1.0.8 ------------------------------------------------------------------------

Released 2019-11-08

Enhancements & New Features

  • [NZO-645] Standardized log file names

When logging is enabled, the driver now produces the following log files: - A simbanetezzaodbcdriver.log file that logs driver activity that is not specific to a connection. - A simbanetezzaodbcdriver_connection_[Number].log for each connection made to the database, where [Number] is a number that identifies each log file. This file logs driver activity that is specific to the connection.

  • [NZO-681] Updated OpenSSL library

The driver has been updated to use version 1.1.1d of the OpenSSL library. Previously, the driver used version 1.1.0j.

  • [NZO-667][00141891] Internal driver improvements

The driver has been updated with minor internal improvements.

Resolved Issues The following issue was resolved in Simba Netezza ODBC Driver 1.0.8.

  • [NZO-668] In some cases, when the driver reads a large amount of data, it stops responding.

This issue has been resolved. As part of this update, the default value for Prefetch Count (PreFetch) has been increased to 5000. The previous default value was 256.

1.0.7 ------------------------------------------------------------------------

Released 2019-05-20

Resolved Issues The following issue was resolved in Simba Netezza ODBC Driver 1.0.7.

  • [NZO-664] If the simba.netezzaodbc.ini configuration file is placed in the same folder as the driver library file, the driver does not read the configuration file.

1.0.6 ------------------------------------------------------------------------

Released 2019-03-27

Enhancements & New Features

  • [NZO-639] Driver-wide configurations

You can now set configuration options so that they apply to every connection that uses the driver. Before, most configuration options had to be set individually for each connection.

For information about how to set driver-wide configuration options, see the Installation and Configuration Guide.

  • [NZO-642] Updated OpenSSL library

The driver has been updated to use version 1.1.0j of the OpenSSL library.

  • [NZO-644] Updated ICU library

The driver has been updated to use version 58.2 of the ICU library.

1.0.5 ------------------------------------------------------------------------

Released 2018-10-19

Enhancements & New Features

  • [NZO-608][NZO-630] Upgrade to OpenSSL 1.1.0i

The driver now uses OpenSSL 1.1.0i for encryption of data.

1.0.4 ------------------------------------------------------------------------

Released 2017-12-15

Resolved Issues The following issue was resolved in Simba Netezza ODBC Driver 1.0.4.

  • In some cases, memory leaks may occur during certain data conversions.

1.0.3 ------------------------------------------------------------------------

Released 2017-10-30

Resolved Issues The following issue was resolved in Simba Netezza ODBC Driver 1.0.3.

  • When the Use Windows Trust Store option (the UseTrustStore property) is enabled, but the trust store does not contain an SSL certificate, the driver returns a communication link error (1001) instead of the expected cert file missing error (1003).

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

Installation and Configuration Guide

Installation and Configuration Guide