IBM Netezza Performance Server connection

To access your data in IBM Netezza Performance Server, create a connection asset for it.

Netezza Performance Server is a platform for high-performance data warehousing and analytics.

Supported versions

  • IBM Netezza Performance Server 11.x
  • IBM Netezza appliance software 7.0.x, 7.1.x, 7.2.x

Create a connection to Netezza Performance Server

To create the connection asset, you need these connection details:

  • Database name
  • Hostname or IP address
  • Port number
  • Username and password
  • SSL certificate (if required by the database server)

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Choose the method for creating a connection based on where you are in the platform

In a project
Click Assets > New asset > Prepare data > Connect to a data source. See Adding a connection to a project.
In a deployment space
Click Import assets > Data access > Connection. See Adding data assets to a deployment space.
In the Platform assets catalog
Click New connection. For more information, see Adding platform connections.

Next step: Add data assets from the connection

Where you can use this connection

You can use Netezza Performance Server connections in the following workspaces and tools:

Projects

  • AutoAI (Watson Machine Learning)
  • Decision Optimization (Watson Studio and Watson Machine Learning)
  • Notebooks (Watson Studio). Click Read data on the Code snippets pane to get the connection credentials and load the data into a data structure. For more information, see Load data from data source connections.
  • SPSS Modeler (SPSS Modeler service)
  • Synthetic Data Generator (Synthetic Data Generator service)
  • Watson Machine Learning Accelerator (Watson Machine Learning Accelerator service)

Catalogs

  • Platform assets catalog

Federal Information Processing Standards (FIPS) compliance

This connection can be used on a FIPS-enabled cluster (FIPS tolerant); however, it is not FIPS-compliant.

Netezza Performance Server setup

Running SQL statements

To ensure that your SQL statements run correctly, refer to the product documentation:

Learn more

Parent topic: Supported connections