IBM Netezza Performance Server for DataStage connection

To access your data with the IBM Netezza Performance Server for DataStage connection, create a connection asset for it. This connection works with the DataStage IBM Netezza Performance Server for DataStage connector, which has exclusive features for DataStage.

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 with IBM Netezza Performance Server for DataStage

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

  • Database name
  • Hostname
  • Port number: The default is 5480.
  • Username and password

For Credentials, 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.

Advanced options

Select Use separate connection for TWT to use a separate connection for creating, dropping, or accessing external tables and the Temporary Work Table. The DataStage IBM Netezza Performance Server for DataStage connector uses a Temporary Work Table as a staging area for the rows received from the input link of a target IBM Netezza Performance Server for DataStage connector.

Enter the database name and the optional username and password for the TWT connection. The database must be on the same database server that you specify for the hostname and port properties.

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. See Adding platform connections.

Next step: Add data assets from the connection

Where you can use this connection

You can use the IBM Netezza Performance Server for DataStage connection in the following workspaces and tools:

Projects

Catalogs

  • Platform assets catalog

IBM Netezza Performance Server for DataStage setup

Running SQL statements

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

Learn more

Related connection: Netezza Performance Server connection

Parent topic: Supported connections