Hi All,
I am working on a DataStage Upgrade Project. Previously we were using FTP Stage to tranfer the data to other servers.
In new system, we have to use SFTP. Can this be done using existing FTP stage?
If yes then How?
If no, then what are workarounds to resolve this issue.
I have researched in this forum but could not get a satisfied answer.
Thanks in Advance.
Can SFTP be used within FTP plug in Stage
-
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
Can SFTP be used within FTP plug in Stage
Attitude is everything....
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 27
- Joined: Thu Mar 20, 2008 11:55 am
I think you cannot use FTP stage for SFTP.
Passing password for SFTP is different than that you do FTP.
I would suggest the easiest way is to ask your unix admins to have a pairing between two servers (source & your local file server) by sharing keys.
With this you don't have to use any username or password..and still you can have secured transfers.
you have to write a small script to pull those files (use get or mget).
This password less transfer from from SFTP is easy and secured.
Passing password for SFTP is different than that you do FTP.
I would suggest the easiest way is to ask your unix admins to have a pairing between two servers (source & your local file server) by sharing keys.
With this you don't have to use any username or password..and still you can have secured transfers.
you have to write a small script to pull those files (use get or mget).
This password less transfer from from SFTP is easy and secured.
Thanks.
"Creativity is the ability to use your available resources to their fullest."
"Creativity is the ability to use your available resources to their fullest."
-
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA