Other Databases

Examples for exporting data from Clickhouse, SAP HANA, and Netezza databases.

Clickhouse

Export data from Clickhouse database.

Single-threaded export:

.\\FastTransfer.exe `
  --connectiontype "clickhouse" `
  --server "localhost" `
  --port "9000" `
  --database "default" `
  --user "default" `
  --password "password" `
  --query "SELECT * FROM orders LIMIT 1000" `
  --directory "C:\temp" `
  --fileoutput "clickhouse_orders.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "None"

Parallel export with Random method:

.\\FastTransfer.exe `
  --connectiontype "clickhouse" `
  --server "localhost" `
  --port "9000" `
  --database "default" `
  --user "default" `
  --password "password" `
  --sourceschema "default" `
  --sourcetable "orders" `
  --directory "C:\temp" `
  --fileoutput "clickhouse_orders.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "Random" `
  --distributekeycolumn "order_id" `
  --paralleldegree 8 `
  --merge "False"

SAP HANA

Export data from SAP HANA database using two connection types.

HANA Connection Type

Standard HANA connection for general exports.

Single-threaded export:

.\\FastTransfer.exe `
  --connectiontype "hana" `
  --server "hanaserver:30015" `
  --user "SYSTEM" `
  --password "password" `
  --query "SELECT * FROM ORDERS WHERE ORDER_DATE >= '2024-01-01'" `
  --directory "C:\temp" `
  --fileoutput "hana_orders.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "None"

Parallel export with Random method:

.\\FastTransfer.exe `
  --connectiontype "hana" `
  --server "hanaserver:30015" `
  --user "SYSTEM" `
  --password "password" `
  --sourceschema "SYSTEM" `
  --sourcetable "ORDERS" `
  --directory "C:\temp" `
  --fileoutput "hana_orders.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "Random" `
  --distributekeycolumn "ORDER_ID" `
  --paralleldegree 8 `
  --merge "False"

HANA Export Connection Type

Optimized HANA connection using native EXPORT functionality for faster bulk exports.

HANA Export

The hanaexport connection type uses SAP HANA's native EXPORT statement for optimized bulk data transfer. This is recommended for large datasets.

Single-threaded export:

.\\FastTransfer.exe `
  --connectiontype "hanaexport" `
  --server "hanaserver:30015" `
  --user "SYSTEM" `
  --password "password" `
  --query "SELECT * FROM ORDERS WHERE ORDER_DATE >= '2024-01-01'" `
  --directory "C:\temp" `
  --fileoutput "hana_orders.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "None"

Parallel export with Random method:

.\\FastTransfer.exe `
  --connectiontype "hanaexport" `
  --server "hanaserver:30015" `
  --user "SYSTEM" `
  --password "password" `
  --sourceschema "SYSTEM" `
  --sourcetable "ORDERS" `
  --directory "C:\temp" `
  --fileoutput "hana_orders.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "Random" `
  --distributekeycolumn "ORDER_ID" `
  --paralleldegree 8 `
  --merge "False"

Netezza

Export data from Netezza database using OLEDB provider.

Single-threaded export:

.\\FastTransfer.exe `
  --connectiontype "oledb" `
  --provider "NZOLEDB" `
  --server "netezza_server" `
  --database "SYSTEM" `
  --user "admin" `
  --password "password" `
  --query "SELECT * FROM orders" `
  --directory "C:\temp" `
  --fileoutput "netezza_orders.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "None"

Parallel export with Random method:

.\\FastTransfer.exe `
  --connectiontype "oledb" `
  --provider "NZOLEDB" `
  --server "netezza_server" `
  --database "SYSTEM" `
  --user "admin" `
  --password "password" `
  --query "SELECT * FROM orders" `
  --directory "C:\temp" `
  --fileoutput "netezza_orders.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "Random" `
  --distributekeycolumn "order_id" `
  --paralleldegree 6 `
  --merge "False"

Parallel export with DataDriven method:

.\\FastTransfer.exe `
  --connectiontype "oledb" `
  --provider "NZOLEDB" `
  --server "netezza_server" `
  --database "SYSTEM" `
  --user "admin" `
  --password "password" `
  --query "SELECT * FROM orders" `
  --directory "C:\temp" `
  --fileoutput "netezza_orders.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "DataDriven" `
  --distributekeycolumn "region" `
  --paralleldegree 6 `
  --merge "False"

tip

Build your command with the Wizard