cancel
Showing results for 
Search instead for 
Did you mean: 

Periodically import excel in HANA XS

0 Kudos
267

Dear Devs,

I have an application which gets his data from a HANA XS database.

An export of employees and country codes is generated each month and saved onto the local file system.

Now I would like to make HANAXS import the excel automatically each month. Is this possible.

If not, is it possible to use the excel file as database?

Looking forward for your responses.

Best regards,

pfefferf
Active Contributor
0 Kudos

How is this question related to SAPUI5 (as you have chosen tag tag) and how do you import the excel file manually today in your database?

View Entire Topic
MustafaBensan
Active Contributor
0 Kudos

Hi,

I suggest you try scheduling an import with the Excel Adapter or File Adapter (CSV) for Smart Data Integration (SDI). Here are some related references:

https://www.youtube.com/watch?v=z_P3sygRUuo

https://blogs.sap.com/2016/01/06/hana-smart-data-integration-the-file-adapter/

Regards,

Mustafa.

0 Kudos

Hi,

Thank you for your response. We have decided to take another approach but this one isn't really clear to me either.

Maybe you have some suggestions?

https://answers.sap.com/questions/602286/synch-hana-xs-with-data-from-ecc.html

Thanks in advance