How integrate Oracle and SAP.

[Former Member]

Hi.

Can you help me?.

I have a RFC in SAP, and in Oracle I have a  trigger.

From trigger of Oracle I wan call to RFC. Can do it's?.

Thanks.

[Former Member]

you can refer to below link get into JDBC scenario->

http://wiki.sdn.sap.com/wiki/display/XI/JDBC+TO+JDBC

In sender you have to use JDBC sender adapter only. Before you actually configure your scenario make sure that you have correctly deployed the vendor compliant driver on the java side of PI.

Otherwise JDBC may not pool the data even though mentioned connection parameters correctly.

As in this case you have sender - Oracle and receiver -SAP /RFC.

you can chose one of following options.

1. You may simply push data to SAP using RFC receiver adapter by importing the BAPI into PI

2. OR you can create the proxy as per the required structured at the SAP and then pushing the data via same proxy calling the function module from the RFC.

3. OR simply recognizing correct IDOC and making inbound connection settings and pushing so.

[former_member192238]

Hi,

From PI we can call database by stored procedure or we can poll the table directly by using JDBC sender adapter in receiver you can use bapi by which you can call with RFC adapter in PI.

Regards

Praveen Reddy

[rajasekhar_reddy14]

Search in SCN..

Use JDBC adapter at sender side and use RFC/ABAP Proxy/IDoc at receiver end.

You don't need to use trigger, PI JDBC channel cal poll directly to DB Table.