Netezza Performance Server 11.1.0.0 release notes

Deployment options: Netezza Performance Server for Cloud Pak for Data System Netezza Performance Server for Cloud Pak for Data

Version 11.1.0.0 introduces the option to deploy Netezza Performance Server on-premises with the hyper-converged Cloud Pak for Data System (Netezza Performance Server for Cloud Pak for Data System), or on private or public clouds (Netezza Performance Server for Cloud Pak for Data).

Netezza Performance Server for Cloud Pak for Data System

Note: On-prem customers can consider staying on the 11.0.X.X version stream instead of moving to 11.1.0.0. For more details, consult IBM Support to choose the most appropriate release (11.1.X.X or 11.0.X.X) for your business needs.

New features, enhancements, and improvements

Netezza Performance Server for Cloud Pak for Data SystemNetezza Performance Server for Cloud Pak for Data

Added external table support for AWS S3 and IBM Cloud Object Storage.
For Netezza Performance Server for Cloud Pak for Data System, see Loading data from cloud: AWS S3 and IBM COS and Unloading data from cloud: AWS S3 and IBM COS.

For Netezza Performance Server for Cloud Pak for Data, see Loading data from cloud: AWS S3 and IBM COS and Unloading data from cloud: AWS S3 and IBM COS.
Added a native SQLAlchemy connector.
Added a technical preview of the JSONB data type.
For Netezza Performance Server for Cloud Pak for Data System, see Document data types.

For Netezza Performance Server for Cloud Pak for Data, see Document data types.

Netezza Performance Server for Cloud Pak for Data

You can choose to deploy Netezza Performance Server on private or public clouds. With 11.1.0.0, Netezza Performance Server is available on both IBM Cloud and Amazon Web Services.

For information on how to install Netezza Performance Server on cloud, see Installing.

The built-in automation and auto-recovery provides a highly-available and fault-tolerant deployment with minimal human touch, ensuring your data warehouse is running continuously without interruption.

The on cloud solution is fully compatible with the existing TwinFin, Striper and Mako workloads. It is the same database engine, but reconfigured and retooled for cloud using the Cloud Platform Infrastructure. You can also leverage cloud provider's Object Storage.
It is a lift and shift solution. On your appliance, you can run the nzbackup command to upload data to IBM Cloud Object Storage or AWS S3 and perform a restore on your cloud data warehouse by running the nzrestore command. You can also choose to run the nz_migrate command.

For more information, see Migrating with the backup and restore method.
Two types of database backup are supported: on-demand, and scheduled.
For more information, see Backup and restore.
You can continue to use your nz-* utilities.

For more information, see Remote command-line nz.
The SSL protocol is enabled by default for the on cloud databases.
SQL Extensions Toolkit is installed by default.
User management is integrated into Cloud Pak for Data, so a new authentication type EXTERNAL and authentication provider CloudPak are added and enabled by default. With them, you can use the Cloud Pak for Data user management.
See Managing users on Netezza Performance Server for Cloud Pak for Data.