Accessing files from remote host

mail2hfz · Post by **mail2hfz** » Tue Jun 22, 2010 9:27 am

Hello All,

Datastage is on host A and files reside on host B. Can we access files directly from remote host B in datastage(tried with seq file stage) without ftp to datastage local host. Is there any settings for this? The files zone is not a shared mount between the hosts.

Thanks!

anbu · Post by **anbu** » Tue Jun 22, 2010 9:31 am

For sequential file stage, files should reside in DS server(Host A).

mail2hfz · Post by **mail2hfz** » Tue Jun 22, 2010 9:43 am

Thanks. Besides seq files stage, any other way I can achieve it? (as an example I've given seq stage). I knew it should be local or atleast common/share mount point between the hosts, to view the files. Just wanted to make sure, I am not missing anything before I propose my design.

ArndW · Post by **ArndW** » Tue Jun 22, 2010 9:47 am

If the files are not visible from the OS then DataStage cannot access them either. The standard tools of NFS mounting, rcp, scp, or ftp will allow DataStage to process the files.

vinothkumar · Post by **vinothkumar** » Tue Jun 22, 2010 9:48 am

In which OS your DataStage server got installed. Unix or Windows ? ? If your DataStage and remote files are in Windows then I guess you can access those files by giving the file name as //Servername/directory/filename.

mail2hfz · Post by **mail2hfz** » Tue Jun 22, 2010 9:56 am

Thanks guys.

bobyon · Post by **bobyon** » Tue Jun 22, 2010 11:01 am

I could certainly be wrong because I have not done it myself, but I thought there was a way to set up an ODBC connection to a sequential file on a remote server.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 22, 2010 4:16 pm

Mounting the remote directory (that contains the files) on the local system is supported.

Yes, you can configure the ODBC driver for text files to access a remote "server".