Accessing Remote Files

DKostelnik · Post by **DKostelnik** » Mon Nov 02, 2009 3:51 pm

Hi,
We are running DataStage v7.5.2 on an AIX v5.3 platform. The development staff has a new requirement to read remote files (I do not know the details). In doing some research it looks like I can either
1) Use NFS to map a remote file system and have DataStage access the file as if were local.
2) FTP the data/file to the loca DataStage filesystem.

Is there another possibility? They were looking at possibly defining the configuation file to include a remote directory, but I don't see where that will work.

chulett · Post by **chulett** » Mon Nov 02, 2009 4:16 pm

Use of the FTP Stage as a source is your only other option I can think of, with all the normal caveats it brings being metadata-driven and all.

DSUser2000 · Post by **DSUser2000** » Thu Nov 05, 2009 7:08 am

You may also use the "External File" stage. Under "Source Program" you can enter a shell script. Each line this shell script outputs becomes a datastage row. You will probably want to use the "Column Import" stage after that to get the fields out of each row.