FTP Enterprise Stage - To access Mainframe File

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
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

FTP Enterprise Stage - To access Mainframe File

Post by synsog »

Hi,

We are using FTP enterprise stage to connect and grab a file from Mainframe host. This connection is working perfectly fine when we are trying FTP using our own credentials. But somehow it's not able to grab the file using SFTP SSH connection

URI - FTP://HOST//'MAINFRAME_FILE'
TRANSFER_PROTOCOL - Secure FTP(SFTP)

Please suggest - do we need to have any specific connection when we do SFTP ?

Regards,
synsog
FranklinE
Premium Member
Premium Member
Posts: 739
Joined: Tue Nov 25, 2008 2:19 pm
Location: Malvern, PA

Re: FTP Enterprise Stage - To access Mainframe File

Post by FranklinE »

synsog wrote:Please suggest - do we need to have any specific connection when we do SFTP ?
The short answer is yes, you do. SSH compatibility is the first requirement.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

Post by synsog »

Thank you!

I confirmed and we have required SSH created. But Still the job is running long without any activity. There is not sign of grabbing or extracting the data from Mainframe.

Can someone please confirm, if the above mentioned syntax are proper ?

Regards,
Synsog.
FranklinE
Premium Member
Premium Member
Posts: 739
Joined: Tue Nov 25, 2008 2:19 pm
Location: Malvern, PA

Re: FTP Enterprise Stage - To access Mainframe File

Post by FranklinE »

synsog wrote:URI - FTP://HOST//'MAINFRAME_FILE'
The correct URI is FTP://hostname/'mainframe filename'

Could be you just have the extra slash.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

Post by synsog »

Unfortunately, Removal of the extra slash also did not worked. :-(
FranklinE
Premium Member
Premium Member
Posts: 739
Joined: Tue Nov 25, 2008 2:19 pm
Location: Malvern, PA

Post by FranklinE »

synsog wrote:Unfortunately, Removal of the extra slash also did not worked. :-(
I'm sorry to hear that. At this point you probably need to talk to your system support and get them to verify the connection. You might also have a password violation lock. Only your support can find out at this point.

I suggest you review your code again, just to make sure there isn't something else causing it. Good luck.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
Post Reply