Skip to Content
0

Store procedure tp update HANA table from CV

Jul 28, 2017 at 04:28 AM

46

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Lars Breddemann
Jul 28, 2017 at 05:45 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
David Jones Aug 01, 2017 at 03:35 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded