[sf-perl] Named Pipe => ftp get => Named Pipe

Asheesh Laroia asheesh at asheesh.org
Wed Aug 15 08:56:11 PDT 2007

On Wed, 15 Aug 2007, Loo, Peter # PHX wrote:

> I am trying to get a large dataset from one database (Netezza) to
> another database (Oracle).  In Netezza, you can dump a large table
> within a couple of minutes into a text file or a named pipe.  As
> everyone knows, sqlldr does a great job loading as well.  So my thought
> is to have Netezza dump to a named pipe and have Oracle SQL load from a
> named pipe.

Can you get Netezza to dump to the "file" /dev/stdout, and then do 
something like:

ssh user at netezzahost 'netezza --dump-to=/dev/stdout' | ssh user at bigiron 
'oracle --read-from=/dev/stdin'

Similarly, if you're logged-in to netezza host:

netezza --dump-to=/dev/stdout | ssh user at bigiron 'oracle --read-from=/dev/stdin'

You can add '-C' after 'ssh' to add compression to the communication, too, 
if you wanted.

-- Asheesh.

You can't cheat an honest man.  Never give a sucker an even break or
smarten up a chump.
 		-- W. C. Fields

More information about the SanFrancisco-pm mailing list