Transfer Netezza to CedarDB

Fast, streaming database-to-database transfer with parallel processing

FastTransfer

Streaming Engine

Terminal

.\FastTransfer.exe `
  --sourceconnectiontype "nzsql" `
  --sourceserver "your-source-server" `
  --sourceuser "your-username" `
  --sourcepassword "your-password" `
  --sourcedatabase "your-source-db" `
  --query "SELECT * FROM your_schema.your_table" `
  --targetconnectiontype "pgcopy" `
  --targetserver "your-target-server" `
  --targetuser "your-username" `
  --targetpassword "your-password" `
  --targetdatabase "your-target-db" `
  --targetschema "your_table" `
  --targettable "your_table" `
  --parallelmethod "Ntile" `
  --distributekeycolumn "id"  `
  --degree 10  `
  --loadmode "Truncate"

All Parameters Wizard

Get FastTransfer

Source - Netezza

IBM Netezza is a high-performance data warehouse appliance. FastTransfer integrates Netezza-specific optimizations.

Features:

•Full Netezza protocol support
•Optimized for appliance architectures
•Support for native parallel methods

Parallel Method - Ntile

Divides data into N equal partitions based on a numeric column.

Requirement: Requires a numeric distribution column

Available parallel methods with Netezza:

Destination - CedarDB

FastTransfer uses PostgreSQL's binary COPY protocol for CedarDB with a PostgreSQL Compatible Source if you use pgcopy both in source and target connection types, ensuring maximum compatibility and performance.

Loading method:

Binary COPY Protocol

Advantages:

•Binary COPY for maximum performance (Pg Compatible Source Only + pgcopy/pgcopy)
•PostgreSQL protocol compatibility
•Optimized for modern hardware

Related Pipelines