Import Data in hana database

[#1]

Hi,

i create a fiori application with sap web ide that consume data from hana database ,

I need to import data from excel or csv file from my desktop to my hana database but i don't find how to do this knowing that i work with the sap web-based workbench and not with hana studio

Could some one help me please

Best Regards,

Ameni,

[Michał · Accepted solution]

Hi Ameni,

try to load mock data from a CSV file using Table Import Definition object (.hdbti). Please refer to SAP HANA Developer Guide > 4.3 Data Provisioning Using Table Import for further details.

Best regards,

Michal

[Former Member · Accepted solution]

Hi Michal,

Thank you ,

I need to automate the process , i mean without copy my data  ,

to be able to load automatically the content of csv from desktop into HANA

Best Regards,

Ameni,

[Michał · Accepted solution]

In this case, depending on your license option, privileges and volume of data, you may think of:

• executing INSERT SQL statement from the command line HDBSQL tool (or combination of XSCRON and SQLScript/XSJS)
• coding script to post your data via XSODATA web service
• making usage of ODBC/JDBC client or ETL tool

Best regards,

Michal

[Former Member · Accepted solution]

Thanks Michal,

Please Is there an example that i can follow ?

Best Regards,

Ameni,

[Michał · Accepted solution]

For IMPORT SQL statement (I've written INSERT by mistake, but attached the right link) please refer to:

• SAP HANA Academy
• IMPORT SQL statement reference (section: examples)
• Best Practices for SAP HANA Data Loads by John Appleby for further discussion

Best regards,

Michal