Proxy to JDBC with attachments

[Former Member]

Hi all,

We are working on an old setup viz. SAP ECC 5.0, XI 3.0 and Oracle database (version not known yet). The scenario is ABAP proxy -> XI -> JDBC. The sales orders created in SAP are to be replicated in Oracle. In the same data flow, PDF attachment is also sent from SAP. So the current plan is to write XML data portion to Oracle table and store the PDF attachment at some file/FTP location which can be made available.

For sending PDF's via ABAP proxy, I could find some info (e.g. http://scn.sap.com/community/pi-and-soa-middleware/blog/2006/04/19/xi-rfc-or-abap-proxy-abap-proxies...). However, since the PDF is to be stored at file location (unlike email or web service receiver wherein the received attachment can be directly forwarded), I am wondering if this is feasible. Would be great if anyone can provide any approach to handle this.

Regards,

-Shankar

[former_member184681 · Accepted solution]

Hi,

You have a few approaches available for your scenario:

1. Split the message in Interface Determination and configure two receivers of the message: file and JDBC. For JDBC, process the sales order message, and for file receiver, use PayloadSwapBean to save the attachment instead of the payload.Still, this is not the best approach, since it does not comply to the "all-or-nothing" principle.

2. You could use a JDBC receiver and write an adapter module to save the attachment as a file. Or the opposite way: use file receiver and call the database in an adapter module.

3. Use JDBC (only in a UDF, since you are using XI 3.0), and make it as a proxy to file scenario, with data saved to the receiver DB in the UDF.

Regards,

Greg

[Former Member · Accepted solution]

Thanks a lot Greg for quick help. Will try these out.

Regards,

-Shankar

[former_member188885 · Accepted solution]

Hi Greg,

For the same scenario, is it possible to send the PDF to the Oracle DB instead to a FTP?

Regards,

Lavanya R