FTP - PI - SAP ECC Proxy with attachment

[Former Member]

Hi all.

We are exploring the possibility to make an integrationscenario where we will pick the file with FTP.

We will use dynamic configuration to get the file name and be able to map that inte the service interface of the proxy.

The actual file should be sent as an attachment with the proxy message.

Result will be an simple message over proxy with the filename in it and attached to the is the actual file.

The filename will be used to trigger programs in SAP ECC.

Is it possible to read teh attachment filename on the SAP ECC side without SAP PI sending it in the XML message?

If that is the case then I can skip the whole mapping or am I incoorect there?

Best Regards

Kalle

[Former Member]

Hello,

>>The actual file should be sent as an attachment with the proxy message.

IMO, without mapping this step is not possible becoz u are picking files from FTP server as a main payload, so u need a mapping where u can send it as an attachment.

BTW, why don't u pass files as it is to ECC (using a pass through scenario) and let ECC program take care of rest.IMO, that would be much simpler and easy design.

Thanks

Amit Srivastava

[Former Member]

Check this:

OutputAttachments

[Former Member]

We are considering that as well but if we can avoid to have FTP accounts on the ECC system then that would be great.

We also have integrations where we need to be able to process without any jobs running and we need to be sure that files a re processed EOIO for som integrations.

Last thing is that we need to use a specific filename that will be the same every time.

If we place the file on the file system then there has to be a job scheduled and how would I then be sure that we are processing the files befor I write the next one with the same name.

I know that the naming is not a good solution but that are the restrictions the business has set for us to follow.

//Kalle

[Former Member]

Hello,

Hmm...then u can use PI and set attachments using above mentioned API

Thanks

Amit Srivastava

Message was edited by: Amit Srivastava

[Former Member]

But lets say that the job is running every 10 mins.

Then we could end up with holding a file on the PI system for 10 mins without being able to write it.

Is that an ideal situation?

Lets say a file around 50 Mb in size.

[Former Member]

Hello,

I have deleted my previous reply, but since u have asked so here is my reply.

I have implemented something similar in my landscape where i have to maintain sequence and pass files to ECC server with the same name and eventually a job (standard FIN program) will read those files but in my case i don't have such bigger files (Size is in KBs)

But having said so, IMO, passing/holding 50 MB of file in a pass through scenario (u can also chunk that file) is little bit better then creating that file as an attachment in PI.

Thanks

Amit Srivastava

[Former Member]

Then the question is how to make the file as attachment?

//Kalle

[Harish]

Hi Kalle,

you can pick the file with File adapter and use PayloadZipBean to convert it as attachement. Read the file name in dynamic configuration and use a map (with any structure) to populate the file name in one of the field. you proxy will read the file name from payload.

refer the blog -

regards,

Harish

[former_member184720]

Hi Kalle - AFAIK - I think you can skip the mapping and read the attachment in your proxy code.

Have a look at the below blog.

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/10/19/abap-proxy-protocols-use-cases-an...

also the discussion for sample code-

http://scn.sap.com/thread/1275849