Invoke PI interface from Oracle

[Former Member]

Hello Experts,

We need to send Product build status/update from an MES database system to SAP ECC 6 using PI 7.11

Scenario will be -> Oracle PL/SQL code (probably on AfterInsert trigger in Oracle table) -> PI -> RFC Receiver on ECC

What are some of the possible options for doing this ?

Obviously using the JDBC Sender channel that polls a 'status' table and gathers all the data and send to PI is one option - however, since the requirement is to have the line initiate the transfer when the product reaches certain build status only - we want to avoid the overhead associated with constantly polling on the critical MES database from PI...

Thanks in advance

Mustafa

[baskar_gopalakrishnan2 · Accepted solution]

If you dont want constant polling using jdbc sender, then think about writing application logic on the oracle side to send webservice request to the soap sender at PI. The scenario will be soap sender to proxy receiver (sap). That is better option. or using application logic write the data on a flat file and use PI to poll the file and send it to proxy receiver. This is second option.

[MichalKrawczyk]

Hi,

- the trigger can start an SP which will create an XML file form Oracle and PI will only poll the folder

- you can call a Web service on PI from stored procedure on the Oracle

- the one you mentioned with the status table - there is no overhead with any polling from PI

if there is no data the select is quick and the call is finished

Regards,

Michal Krawczyk

[Former Member]

Michal

Thank you for your insightful answer...

I like the WS call from Oracle SP - will look for info. on how to do this...

Mustafa

[MichalKrawczyk]

Hi,

there are multiple examples on the web:

http://www.oracle-base.com/articles/10g/utl_dbws10g.php

Regards,

Michal Krawczyk