cancel
Showing results for 
Search instead for 
Did you mean: 

Store procedure tp update HANA table from CV

0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

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

lbreddemann
Active Contributor
0 Kudos

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.