Quickstart for inbound SFTP to ABAP Proxy w/ file conversion

[errol_sayre]

I'm looking for expertise about how to use PI to pull a text (tab delimited) file from a remote SFTP server and push the entries to ABAP.

I'm still quite new at PI but as I understand it, I need a three step process by which I pull the file via the SAP SFTP/PGP adapter, store it to the PI filesystem, open that stored file with a File adapter to do conversion (from flat to XML) and send that data off to an ABAP proxy.

Is this correct? And if so, how do I make this multi-step process work? Do I need two configurations e.g. SFTP sender to PI file receiver and PI file sender/converter to ABAP proxy receiver? It's the details of this configuration that have me baffled.

I'd like to use PI but this has proven more difficult than setting up a standard SOAP service (my prior experience in PI). My best alternative is to bypass PI altogether and accomplish this via Java/JCo as that process is considerably simpler to me.

Thank you much.

[rcsegovia · Accepted solution]

Please have a look to: http://scn.sap.com/message/14465239  scenario is not too complex.

Take into account that is not the same SFTP than FTPS  http://scn.sap.com/people/krishna.moorthyp/blog/2007/07/31/sftp-vs-ftps-in-sap-pi

good luck,

Roberto.

[errol_sayre · Accepted solution]

Thanks, I'm definitely using SFTP.

All of the links on that discussion I've seen before, however the comments suggest I should look at MessageTransformBean... ignoring that, what do think about my idea to write a temp file to the PI filesystem and use a separate communication channel to pick that up and use the conversion utilities bundled therein? Is this approach even possible?

[rcsegovia · Accepted solution]

If I understood well, two interfaces:

   One to move file from SFTP to PI filesystem and another one to easy convert to an XML using file adapter and proxy as receiver?

More steps means more possible errors but...

I will give it a try to the one step way  http://scn.sap.com/thread/3187445

good luck,

Roberto.

[errol_sayre · Accepted solution]

I'm planning on trying this, for some reason I mistakenly thought MessageTransformBean required a JAVA proxy rather than ABAP.

Thank you again for your help.