Data extraction from Oracle ERP to BPC 11.1 (Standard version)

[KumarPotti]

Hello Friends,

My customer using Oracle ERP and wants to integrate with BPC 11.1 (standard version). Presently using actuals data uploading to BPC using csv files.

Please suggest possible options and share documentation? Thanks.

Our system details: BPC11.1 -SP3 (Standard version).

Regards,

Kumar

[N1kh1l]

kumar_19

There is no standard connector between Oracle ERP and BPC standard. Depending on what actuals you need , you to figure out what table in Oracle ERP can provide the data. You can use DB connect feature of BW4 to stage and transform data in to ADSO. Create BW staging layer to handle delta records. You can create process chains to schedule and autonate these loads. Once data is in BW use Load info provider data manager to load your BPC planning cube. Also BPC data manager can trigger BW process chains. So you can create a Package link to nest all these load in sequence.

Please accept/upvote if this helps you

Regards

Nikhil