BPC with Oracle E-Business interface

[raghu_ram]

Hi All,

Looking for help in interfacing Oracle E-Business with SAP BPC:

- Download budget data from Oracle E-Business to SAP BPC

- Load budget data from SAP BPC to Oracle E-Business

can't see any document detailing that.

Please help.

Raghu

[Former Member · Accepted solution]

Hi Raghu,

We have solved Oracle EBS-BPC using "Import SQL" package. I asked the Oracle consultant to create a view providing all required columns, then used SSIS to load the data into a staging table on SQL Server and used that as SQL source in BPC Data Manager.

To follow the same path, you'll need to create a server link to Oracle database and use it as source in your SSIS packages:

1. Install and configure Oracle client on BPC database server

2. Create linked server for Oracle database

3. Use OPENQUERY to get the data from Oracle tables as it is much more robust though a bit slower and insert the data into SQL table

4. Configure "Import SQL" package to fetch data from the staging table

5. There is no step 5

Hope this helps,

Madis

[Former Member]

Hi Raghu,

There is no such document readily available. What I can suggest you is that there is a SSIS package which links BPC to MS Access. Please go through that. This will give you the idea.

[raghu_ram]

Hi Nilanjan,

Where can I find that document.

Regards,

Raghu.

[Former Member]

Hi Raghu,

This SSIS package is available in the package files folder under every application. Please go to your application in the server.Then, go to data manager -> package files -> examples. Check the package "import access 2007 into fact table. You can open this SSIS package using BIDS to see the tasks within. Then create a DM package on top of this SSIS to see the advanced script.

Hope this helps.