Oracle db to SAP R/3 synchronous solution ?

10-11  Source: Network gathering  Views:7 

Advertisement
Hi,
I am looking for some comments from SDN members to come up with a solution.
<u>Requirement:</u> Automatically update the R/3 system based on the updates in the "external" Oracle database.
In order to accomplish this, currently we are working on the JDBC (Sender)> XI> R/3 ( RFC receiver) asynchronous scenario using poll interval to pull the data from Oracle db to R/3.
Instead we are looking for a synchronous sort of solution where Oracle pushes the data into R/3 as soon as update happens in the Oracle tables.
One of the possibility is to have a trigger in the database to generate the XML files using XMLGen.getxml utility.
Thanks for your time,
Sunil
Hi Sunil.
If I understand correctly, you want to push data from Oracle to XI rather than polling the database from XI and retrieving data.
You may consider exposing your outbound interface in XI as a web service and then calling the web service from the triggers in Oracle. Thus data would be passed from the Oracle trigger to XI over SOAP.
This link would help you on how to call web service from PL/SQL
http://www.oracle.com/technology/tech/webservices/htdocs/samples/dbwebservice/DBWebServices_PLSQL.html
These links would help you on how to expose a web service from XI.
http://help.sap.com/saphelp_nw04/helpdata/en/31/daa0404dd52b54e10000000a1550b0/frameset.htm
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/336365d3-0401-0010-9884-a651295aeaa9
You can write the trigger for the appropriate action (INSERT, UPDATE, DELETE) on the database table and then call the web service.
Hope this help ,
Gaurav
Related articles
  • Oracle db to SAP R/3 synchronous solution ? 10-11

    Hi, I am looking for some comments from SDN members to come up with a solution. <u>Requirement:</u> Automatically update the R/3 system based on the updates in the "external" Oracle database. In order to accomplish this, currently we

  • How can we do the data migration between Oracle Applications and SAP R/3. 10-11

    Hi All, How can we do the data migration between Oracle Applications and SAP R/3 system.What are all the possible ways to move bulk data from Oracle Apps to SAP r/3 system. Provide any 3rd party tools which supports data migration and also pls rpovid

  • Using Oracle CURSOR in SAP PI 7.0 10-11

    Hi All, I have a scenario in which I need to get the data from Oracle database using cursor, but I couldnu2019t find a direct method in PI to do the same using the JDBC sender channel. Can anyone tell me how we can access Oracle cursors in SAP PI? I

  • How to bring BO knowledge (Oracle source) to SAP BI/BW/ECC (source) 10-11

    Hi, I currently took a BO XI R2 class but they did not have SAP BI/BW (ECC 6/ R3) and therefore, they used only Oracle DB as the relational database i.e. the source system of data. Do you have any help for me on how to transition my acquired knowledg

  • When is Oracle Adapter for SAP 10.1.2.0.2 released? 11-30

    Hi, I'm desperately waiting for the release of the Oracle Adapter for SAP 10.1.2.0.2. It is stated as Projected on the Download site. I do still have serious problems with bug 2574376. This bug was fixed already in July 2004. In that bug is stated th

  • Are the Oracle Transparent Gateways SAP approved 11-30

    Gentlemen: Thanks in advance for your reply. I am new on this gateway world and I am trying to find the best solution for us. Situation ... DB Migration of SAP 4.5B from MSSQL to Oracle8 in Sun Solaris (No problem with this). We run a VB application

  • Oracle error in SAP 11-30

    Hi experts we are facing oracle error while installing SAP '10.2.0.1' is not allowable for "optimizer_feature_enabled. Currently our oracle version is 10.1.0.2 Please suggest which patch we should apply to over this error or pls suggest some solution

  • SAP MMC Java with Solution Manager 10-11

    Dear experts, i have installed a SAP Solution Manager 7.0 in WAS ABAP + JAVA in Windows Server 2003 SR2 Enterprise Edition 64 bits + MS SQL 2005. I try to connect to the SAP MMC in Java (http://localhost:52113/) but i have a message error: Your brows

  • Error during the installation of ORACLE 10g for SAP MDM 5.5 10-11

    Hi all, I am installing ORACLE 10g on a SUSE LES 9 for a future MDM 5.5 system. While I launch the Installer I get the following error: Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-09-26_07-11-46AM. Please wait [email protected]

  • How to copy the Data From Oracle Table To SAP Table 10-11

    Hi Friends, We need to copy the data from Oracle Database Table to SAP Table. The data should be updated simultaneously in both tables . Should I write a program that contains the native sql statement like EXEC SQL PERFORMING WRITE,.... I appreciate

  • Can Oracle Forms access SAP R/3's Oracle 9i Database? 10-11

    I have an SAP R/3 with an Oracle 9i R2 database. I would like to access the contents of say KNA1 in Oracle 9i. Has any one try to integrate SAP R/3 using an Oracle Forms, say formaple, to maintain or just search/enquiry customer details in the table

  • Connection to oracle database from sap R/3 10-11

    Hello SAP Masters, I do have two querries. 1) I want to download the data into oracle. so is it possible in sap? 2)please explain me how in details? 3) I tried with DBCON . 4) But when I wrote program stating the name of the connection it is giving d

  • Message transfer from Oracle DB to SAP R/3 10-11

    Hi All, I have a scenario in which i want to transfer an HR record from a table of OracleDB to SAP R/3 via a standard IDOC. Can anybody pls tell me the following: 1. Requirements for implementing this scenario. 2. Oracle 8.0 is being used, so is ther

  • Monitoring a non-SAP satellite system in Solution Manager 10-11

    Hi Folks, I have two quick questions. 1.) What is the proper procedure/tool for monitoring a non-NW system in Solution Manager? Should I be able to use sapccmsr and saposcol on these systems? 2.)  What is the proper way to connect a non-NW system to

  • SAP Netweaver gateway in solution manager 10-11

    Hi , We have a solution manager 7.1(netweaver 7.02) and ECC IDES EHP 6 system for which we need to configure Netweaver gateway. We have installed netweaver gateway 2.0 components in solution manager system. Now is it possible to configure gateway on

  • Oracle equivalent of SAP BAPI/RFC? Stored Procedures? 11-30

    Hello all. I am looking at the development of integrating our desktop application with Oracle. We would like to upload/download objects from Oracle EAM such as Assets, Work Orders, etc using ODP.NET. We already have a similar connector to SAP. In thi

  • Broken image links on APEX 3.0 in Oracle 10g XE? Here's the solution 11-30

    You're on Oracle 10g XE and you've just upgraded your APEX from 2.0 to 3.0. You log into APEX Admin and there's tons of broken image links. You look into the Oracle documentation for APEX and it instructs you to copy the Images folder into your htmld

  • Customer Credit Limit from Oracle Financials to SAP 11-30

    Friends,    SAP has  to receive the Customer credit limit data from Oracle Financials.  Can any one help me what idoc / bapi should i use for this inbound process. If the question is not clear ,  please let me know. Regards RajHi there, In WE20, chec

  • Set events parameter in oracle 11g for SAP 11-30

    Hi All, Recently we have upgraded 10.2.0.4 oracle database to 11.2.0.3 (AIX 7.1) for SAP application. Some non-default event parameters were set when Database was running with 10.2.0.4 version. After upgrade to 11.2.0.3, those events were not seen in

  • Migration from oracle to standard sap bw components 11-30

    client using an oracle based corporate data warehouse management wants to migrate for sap bw. they are now using oracle for central reporting system. what kind of extraction has to be used? is table from oracle warehouse has to be converted to other