Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

PI JDBC select table from oracle database

Hi all,

I am new to the JDBC adapter and have been able to make interfaces to insert and update tables in an oracle database. I'm not sure if it is possible, but what I would like to do is execute a proxy from ECC to PI. The proxy would execute a message map designed to do a select on a table via the JDBC adapter to an oracle database. The selection would be passed back to PI and than through the proxy to ECC.

Is this possible? What is the workflow of how this works? Do I need anther map to receive the selection?

Thanks for your help.

Former Member
replied

>Is this possible? What is the workflow of how this works? Do I need anther map to receive the selection?

Yes. This is possible.  You need to do Proxy to JDBC synchronous scenario.

Proxy to JDBC request  (First Mapping)

JDBC response to Proxy (second mapping)

Basically you do sender proxy and receiver JDBC.  JDBC  receiver works as sync.  So create the structure as follows.

Request message name    example  TestReceiver

Response message name  example TestReceiver_response

Please search scn for proxy sender scenarios and JDBC Receiver scenarios. There are plenty of documents, blogs available on this topic.

Also use sap help document for JDBC  receiver structure for reference

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Follow the statement1 format... for creating receiver Data type structure...

Hope that helps

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question