Loading Data (MD + KF) in S&OP 3.0 on premise without BODS

[former_member230658]

Hello,

My customer is implementing S&OP 3.0 on premise. The Planning Area has been set up and the manual data load with CSV files for both MD and KF is working correctly.

Now we are in step to make this data integration stuff running in a much more automated way, but unfortunately the customer is not ready to use an ETL tool like BODS. So we are thinking of using an alternative way like Hana SDI (ETL Embeded within Hana) or Hana SQL scripts !

Does someone have some experience and/or recommendation of implementing such approach for automatic data integration from flat file (ex. CSV) to Hana S&OP or IBP.

Thanks for your help

Luc

[Former Member]

Hi Luc,

We are facing the same issue. We will use SLT as a Data services.

Please could tell us if you have get a solution to automate loads data into core tables on S&OP.

Thanks for your help

Regards

Amir

[former_member230658]

Hi Amir,

Yes I have made some progess on that topic thanks to the following OSS note :

2045922 : S&OP on HANA On-Premise Data Integration using any ETL

The overall logic is then to fill the stagging tables (ex. SAPSOPG.SOPMD_STAG_O1CUSTOMER for Master Data Type O1CUSTOMER) and after to call the SOPINTEG_DATA_UPLOAD procedure to execute the batch job that send data from the stagging table to the S&OP application tables.

I am doing some promising tests with such process.

Not sure SLT can be used as the SLT is more dedicated to table replication, or you have to create the same stagging table in your sending system.

Regards

Luc

[Former Member]

Hi Luc,

Thanks a lot for your reply.

I'll look in detail the solution proposed by this note. I have one last question, just would like to know if the automation of the Call SOPINTEG_DATA_UPLOAD procedure is done at the ETL side ?

I guess you're using BODS as ETL. I will look at this point on the SLT. If we can not use it, it'll be a big big issue for us.

Thanks & Best Regards

Amir

[former_member230658]

Hi Amir,

If fact in our case we are not using BODS. The call of SOPINTEG_DATA_UPLOAD must be triggered by the ETL.

But in our case, we plan to use SQL scripts to do the data integration.

Regards