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
The IBM Netezza Performance Server for DataStage connection supports IBM Cloud Satellite connector. The IBM Cloud Satellite tile is available in the Private Connectivity section of the Create connection form. You can set up a Satellite Connector to securely connect to your data source from a Docker container in your on-prem infrastructure or set up a Satellite location with multiple hosts in your infrastructure, such as an on-prem data center or cloud. For more information, see Setting up a Satellite Connector.
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 > 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
- DataStage (DataStage service). See Connecting to a data source in DataStage.
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