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.18, as well as the version history.

1.0.18 =======================================================================

Released 2023-08-01

Enhancements & New Features

• [NZO-780] Updated 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.

• Updated macOS support

  On macOS, the connector is now a Universal driver that natively supports Apple Silicon. For security best practices, it is suggested to keep both the connector and OS updated.

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.17 ———————————————————————–

• [NZO-769] Removed support for Windows 8.1

  Beginning with this release, support for Windows 8.1 has been removed. For a list of supported Windows versions, see the Installation and Configuration Guide.

• [NZO-769] Updated encryption and decryption methods

  On Windows, the encryption and decryption methods used for storing the password (PWDE) within the registry have changed. Update the password within the existing DSN or remove and create a new DSN otherwise the connection fails.

• [NZO-778] Deprecated support for SSLv3

  Beginning with this release, support for SSLv3 has been deprecated.

  Support will be removed in a future release. For more details, see the Installation and Configuration Guide.

• [NZO-779] Removed support for NPS 7.2.1

  Beginning with this release, support for NPS 7.2.1 has been removed. For a list of supported NPS versions, see the Installation and Configuration Guide.

1.0.13 ———————————————————————–

• [NZO-700] Removed 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] Removed 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.17 ———————————————————————–

Released 2023-04-30

Enhancements & New Features

• [NZO-769] Updated third-party libraries

  The connector now uses the following third-party libraries:

  • Expat 2.5.0 (previously 2.4.6)
    
  • ICU 71.1x (previously 58.3x)
  • OpenSSL 3.0.8 (previously 1.1.1n)

  In addition, the connector also upgraded Compiler support.

  The connector now uses the following compiler versions:

  • Windows vs2022 (previously vs2013/vs2015)
  • Linux gcc 5.5 (previously gcc 4.4)
  • mac OS XCode 11.3 (previously 10.9)

• [NZO-779] Upgraded NPS support

  The NPS version now supported is 11.x. Previously, the NPS version supported was 7.2.1.

1.0.16 ———————————————————————–

Released 2023-01-16

Resolved Issues The following issue was resolved in Simba Netezza ODBC Connector 1.0.16.

• [NZO-763] When tables contain more than 16 columns and the columns are not nullable, the connector does not retrieve the data.

1.0.15 ———————————————————————–

Released 2022-04-29

Enhancements & New Features

• [NZO-759] Updated OpenSSL support

  The connector now uses OpenSSL 1.1.1n for encryption of data. Previously the connector used OpenSSL 1.1.1g.

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

Installation and Configuration Guide