Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data load from SAP to HFM using ODI

1057422Nov 28 2013 — edited Nov 29 2013

Hi,

I´m trying to load data from a SAP ERP system to a HFM application. In order to achieve that I´m following the doc "Getting Started with SAP ABAP ERP Adapter for Oracle Data Integrator". In the chapter 3 of this document, configuring the topology, the target data server is an Oracle DB. In this section also we can read that "Please use respective settings when configuring a non-Oracle Target Data Server for use with LKM SAP ERP to SQL" and i cant find the steps i should follow If I want to use HFM as the target data server. Also i read that SAP generates a flat file wich is loaded into de Oracle DB, and I dont know how to achive this also with my enviroment.

Im using ODI 11g, HFM 11.1.2.1 and MS SQLServer.

1) Is it possible to set up a direct connection between SAP R3 and HFM?

2) What LKM, IKM and RKM should I use in that case?

3) Is there any document that covers this case?

4) If not, What should i do to achieve my goal?

Thank you

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2013

Added on Nov 28 2013

#business-intelligence-applications, #data, #data-integrator, #hfm, #load, #odi, #system-management-and-integration

4 comments

1,180 views