Handling attachments in PI

[Former Member]

Hi Gurus,

I have a requirement to attach the Files along with the Main Payload in the sender side. There may be multiple attachment files with different formats ( example: PDF, JPEG, XLS) . The source are JDBC, FTP and SOAP. Target is capable of handling attachments. Need to know how to handle attachment files in JDBC sender , FTP adapter and in SOAP sender.

Thanks in Advance..

[former_member181985 · Accepted solution]

Hello Kevin,

With sources,

• JDBC - As mainpayload only with clob/blob as base64/hex content. In mapping you can formulate attachments by reading clob/blob section tags, if your pi version >=7.1
• FTP - Not possible. you can have attachments with only File NFS protocol.
• SOAP - Attachments possible. Source application platform should be capable of doing this.

Regards,

Praveen Gujjeti

[Former Member · Accepted solution]

Thanks praveen. Could you please explain with steps in JDBC and SOAP for attachments.

[former_member181985 · Accepted solution]

Hello kevin,

For JDBC, you can read my blog as reference (read the last section snippet): http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/03/28/sap-xipi-storing-binaries-images-...

For SOAP, you do not have to do anything specific other than enabling keep attachments option in pi sender soap channel. The source system should be capable of sending attachments in the messaage.

Regards,

Praveen Gujjeti

[smavachee]

Specifying your existing SAP PI System version will be more effective to get the relevant replies.

Regards,

Sunil

[Former Member]

PI 7.3