ftp

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
laxmi_etl
Charter Member
Charter Member
Posts: 117
Joined: Thu Sep 28, 2006 9:10 am

ftp

Post by laxmi_etl »

Hi,


Can anybody tell me what stage we have to use for secure ftp

Thanks
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

No secure ftp stage. You could create a sftp script and invoke it within datastage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Kirtikumar
Participant
Posts: 437
Joined: Fri Oct 15, 2004 6:13 am
Location: Pune, India

Post by Kirtikumar »

Write the script to get the file using sftp. Call this script as before job and then you can use the file in the job.
Regards,
S. Kirtikumar.
michaeld
Premium Member
Premium Member
Posts: 88
Joined: Tue Apr 04, 2006 8:42 am
Location: Toronto, Canada

Post by michaeld »

In windows both CuteFTP or WinSCP support scripting which you can call from a datastage command activity. DataStage v8 has an SFTP stage.
Mike
sribuz
Premium Member
Premium Member
Posts: 19
Joined: Mon Jun 04, 2007 7:26 pm
Location: US

Post by sribuz »

Hi, I am working on EE 7.5

can you tell me how to write script in unix to SFTP a file
Thanks & Regards,
Sri
sud
Premium Member
Premium Member
Posts: 366
Joined: Fri Dec 02, 2005 5:00 am
Location: Here I Am

Post by sud »

:lol:

Sure, please post your credit card number, expiry date and the 3 digit code.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
Post Reply