Skip to Content
author's profile photo Former Member
Former Member

Automate Data Loads from Staging to Core tables

Hi Experts,

We are using S&OP on-premise system and integrating data from ECC through Data Services. How can we automate data loads from SOPDD_STAG_* for master data and SOPDD_STAGING_KFTAB_* for key figure data into core tables.

Is there a stored procedure which can be run on periodic basis for the same?

Thanks in advance.

Regards,

Aditya G

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 01, 2014 at 05:41 AM

    Hi Aditya,

    Please check the following note.

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

    Thanks,

    Pramod

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 16, 2015 at 07:18 PM

    Hi Aditya,

    Were you able to implement the third party ETL integration with OnPrem S&OP?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Aditya,

      I am new on S&OP. We are facing the same issue. We will use SLT as a Data services

      Please could you explain in details how did you do to automate loads from Staging Tables into core tables. Have you used a standard Hana Stored procedure or you developped a specific one ?

      Please also explain how to pass parameters to the Hana stored procedure.

      Thanks for your help

      Best Regards,

      Amir

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.