Adapter Module

[former_member223432]

Hi Experts,

Do we have any adapter module  for FTP to SFTP conversion in PI 7.1

thx

[former_member223432]

Can someone please share an idea/document in building a custom adapter for SFTP in PI 7.1

thanks

[former_member184720]

Hi Smith - If you don't want to buy an adapter on the current service pack / update the service pack to get it free from SAP.. then the only option i can think of is..

Place the files on NFS..

write java prog to transfer them from NFS to SFTP server

Call that java program in the file receiver channel using " execute OS commands" option..

You can find many libraries(zehon,jcraft..) using which you can transfer the files to SFTP..

[former_member223432]

Hi Hareesh,

Thanks for your reply..we are currently saving the files in the network folder  by appending the files  and then sending one big file once at night to the target system..

Can you please provide some more input on building a java program and using it in OS command option.

[former_member184720]

Hi Smith - You can just google for " send files to SFTP server using Java". you should find many sample libraries..

one among -

zehon.com Java: SFTP Samples

http://www.jcraft.com/jsch/examples/Sftp.java.html

Then create a batch file to call this java program

Schedule that batch file on the server according to your requirement..

OS Commands might not be useful as you are appending the files..

[former_member223432]

Thanks hareesh..

we are appending the files in NFS to create one Single file...which will be later sent to receiver at night...an OS Command is written to the  target FTP channel right? i guess it should be OK.

[former_member184720]

If you use the "execute OS commands" option in the file receiver channel which is appending the files, please note that these commands will be executed whenever it writes a file(appends).

These commands will be executed on the PI Operating System..

If you are going with this approach - Then you have to handle the logic in your java program to check for the current time and process them to SFTP server based on your needs.

[former_member223432]

Any other valuable suggestion please...

[Former Member]

Hi Smith

You can try FTP adapter with FTPs protocol. That is also support secured FTP transfer.

Check this

[former_member190624]

Hi Smith,

AFAIK, We can't convert FTP to SFTP , as both adapters use different transport protocol (Network layer protocol).

File adapter uses - FTP as Transport protocol , where as

SFTP adapter uses - SFTP as Transport protocol.

We can't convert(FTP to SFTP) transport protocol in PI server , please check with network team for any available work around.

Thanks

Hari.

[former_member223432]

Thanks Hari..

is there any workaround in PI to have SFTP mode of communication...we dont want to use FTPS.

[anand_shankar10]

If you cant update the service pack to have SFTP out of box. then go for additional license. Adventco is a vendor who provides it.

[Former Member]

Hi ,

SFTP adapter is available from SAP PI 7.1 SP8.If you are in lower service pack then do the upgrade to PI 7.1 SP8.Even if you try to tweak it to make it work , SAP will not support it and therefore maintenance will be an issue in long term.

http://scn.sap.com/community/b2b-integration/blog/2012/03/30/new-add-ons-b2b-and-sftp-pgp-for-sap-ne...

Regards

Venkat

[former_member223432]

Thanks Venkat.

we are on lower pack..Can you please let us know how to tweak it to make it work.

thx

[anand_shankar10]

Basis team should provide you the exact solution.

As you may face maintenance issues so better to work with Basis team for this.

Thanks

Anand