Reading from a remote directory in Sequence Job

s_avneet · Post by **s_avneet** » Thu Nov 03, 2016 8:43 am

Hi All.

We have a requirement to read the incoming files from a folder. This folder is not local to DataStage server, but resides on the source application system server ( on a Windows server). DataStage is running on a Linux server.

I want to know if i can access the server from a sequence job?? And if i can use Execute command stage?

Cheers!!

chulett · Post by **chulett** » Thu Nov 03, 2016 9:41 am

Meaning... you are wondering if an Execute Command stage in a Sequence job can access a remote directory and move the files locally? If so, the answer is yes. I would suggest you get it working from the server's command line first before you even attempt to fold it into a DataStage job.

PaulVL · Post by **PaulVL** » Thu Nov 03, 2016 9:55 am

I recommend doing an SFTP to obtain the file with secure SSH keys in place.

Your company Security team will echo that statement.

I dislike shared mounts between Unix and Windows. But that is a personal choice, just like I do not like Liver or Uni.