Skip to Content

How to integrate Oracle Primavera and SAP through SAP PO

Hello,

I have requirement to integrate Oracle Primavera and SAP.

Is it possible to insert the data from SAP table to Oracle Primavera Staging table directly.

Note: Our client using SAP PO as well as HCI.

Can anyone please suggest me the best solution for this integration project?

Thanks & Regards,

Trishika

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 03 at 04:50 PM

    Using PO you can achieve this using JDBC adapter. But, Oracle Primavera drivers are required to be deployed in PO server.

    Using HCI direct data insertion in Oracle staging table not possible.

    Thanks,

    Apu

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Abu,

      Thank you for your feedback.

      I have one scenario in which I need get three files from AL11 server(ECC) in SAP PO system and I need to club the data all together and insert the same data into one staging table?

      Thanks & Regards,

      Trishika

  • May 03 at 09:43 AM

    There are 2 different ways to do this -

    1) Create one File to File scenario. In the receiver File CC user append to make a single file out of your 3 files.

    Now create one File to JDBC scenario to pick up appended file and insert into Oracle/SQL table.

    2) Use NWDS BPM to merge 3 files and put this to the IDBC table. Make sure there is a common filed in 3 files so that BPM can correlate the files.

    Thanks,

    Apu

    Add comment
    10|10000 characters needed characters exceeded