Load data from sql-server to Netezza using FIFO

Fixed Price
Deliver by - June 6, 2014


Hi ,
i need to know how can i load data from SQL-Server to Netezza tables using Named-pipes (FIFO) through NZLoad , but the SQLServer and Netezza are on two different servers ,
But I do not want to do the BCP from SQLServer to Flat-file then FTP the Flatfile to Netezza Server then use this Flat-file for NZLoad  because it requires me to store huge amount of flat-file data temporarily in both the servers so is why i like to use FIFO to avoid the temporary storing of data  

Both the Netezza and SQL Servers are in two different UnixBoxes so i am curious if we can read the Named pipe from SQL Server Unixbox in to Netezza Unixbox without breakage.
Skills Required

Client Activity on this Job

Last Viewed: 10 months ago
Applicants: 5
Hired: 1