Netezza

Netezza is supported as a source-only database in MigratorXpress. It uses NZDataSlice-based parallel transfers for efficient extraction of large tables.

Connection Parameters

Parameter	Required	Description
ds_type	Yes	Must be "netezza"
auth_mode	Yes	Must be "classic"
username	Yes	Netezza username
password	Yes	Netezza password
server	Yes	Hostname or IP address
port	Yes	Port number (default: 5480)
database	Yes	Database name

NZDataSlice Parallel Transfer

Netezza distributes data across internal data slices. MigratorXpress leverages this architecture by reading from individual data slices in parallel, which significantly improves throughput for large tables. No key column is required -- the parallelism is based on Netezza's internal data distribution.

The number of parallel streams is controlled by the --fasttransfer_p parameter. For best results, set it to a value that aligns with the number of data slices on your Netezza appliance.

Required Permissions

-- Grant read access to the migration user
GRANT SELECT ON TABLE schema_name.table_name TO migratorxpress_user;

-- Or grant list access for an entire schema
GRANT LIST ON schema_name TO migratorxpress_user;
GRANT SELECT ON schema_name TO migratorxpress_user;

Example

{
  "netezza_prod": {
    "ds_type": "netezza",
    "auth_mode": "classic",
    "info": {
      "username": "$env{NZ_USER}",
      "password": "$env{NZ_PASSWORD}",
      "server": "nz-prod.company.com",
      "port": 5480,
      "database": "PROD_DB"
    }
  }
}

Troubleshooting

Connection refused: Verify that the Netezza appliance is running and accessible. The default port is 5480, not the standard PostgreSQL port of 5432. Check firewall rules and network connectivity:

# Test connectivity
telnet nz-prod.company.com 5480

Authentication failed: Confirm the username and password are correct. Verify that the user has not been locked out and has the required permissions on the target database.

See Also

• Database Connections Overview -- Auth file format and security best practices