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
-
laxmi_etl
- Charter Member
- Posts: 117
- Joined: Thu Sep 28, 2006 9:10 am
Post
by laxmi_etl »
Hi,
Can anybody tell me what stage we have to use for secure ftp
Thanks
-
DSguru2B
- 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
- 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
- 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
- Posts: 366
- Joined: Fri Dec 02, 2005 5:00 am
- Location: Here I Am
Post
by sud »
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.