Skip to Content

Store procedure tp update HANA table from CV

Hi ,

Is it possible to use a store procedure to read from a CV and then populate the result into a table which will have same structure as the CV with certain filters applied?

Then I would like to use external ETL tool to call this store procedure on daily basis.

If you someone has done this before, can you please share the details as to how it is done?

Thanks,

DJ

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 28, 2017 at 05:45 AM

    Yes, that's possible.

    Why do you want to duplicate data, though?

    As for the scheduling of such a stored procedure, you could use the XS scheduler in SAP HANA.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 01, 2017 at 03:35 AM

    Hi Lars,

    Thanks for your response. Actually the target table will have less number of columns. Is there any online resource available on scheduling SP using XS Scheduler?

    Thanks,


    DJ

    Add comment
    10|10000 characters needed characters exceeded