Skip to Content
0
Former Member
Jan 17, 2012 at 05:18 PM

Invoke PI interface from Oracle

85 Views

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