Export Netezza to AZ Datalake Gen2 in XLSX
Fast, parallel data export with zero intermediate storage
Terminal
.\FastBCP.exe `
--connectiontype "nzsql" `
--server "host.domain | host.domain,port | host.domain,port/service" `
--database "tpch" `
--trusted `
--sourceschema "tpch10" `
--sourcetable "orders" `
--query "SELECT * FROM tpch10.orders" `
--directory "abfss://storageaccount.dfs.core.windows.net/fastbcpexport/raw/{sourcedatabase}/{sourceschema}" `
--fileoutput "{sourcetable}.xlsx" `
--decimalseparator "." `
--dateformat "yyyy-MM-dd HH:mm:ss" `
--encoding "UTF-8" `
--method "Ntile" `
--distributekeycolumn "o_orderkey" `
--paralleldegree -2 `
--merge false `
--runid "runidfromcaller"Source - Netezza
IBM Netezza is a high-performance data warehouse appliance. FastBCP 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:
Output Format - Excel (XLSX)
The Excel XLSX format is ubiquitous in enterprise environments. FastBCP exports directly to Excel format, ready to open in Microsoft Excel or compatible tools.
Features:
- •Native Excel format (Office Open XML)
- •Automatic column headers
- •Data type formatting (numbers, dates)
- •Ready for business reporting
Destination - Azure Data Lake Gen2
Azure Data Lake Storage Gen2 combines Azure Blob Storage with hierarchical namespace for big data analytics. FastBCP optimizes uploads for ADLS Gen2.
Storage Type:
Cloud Data Lake
Features:
- •Hierarchical namespace support
- •Optimized for analytics workloads
- •POSIX-compliant access control
- •Native integration with Azure services
