cancel
Showing results for 
Search instead for 
Did you mean: 

CSV upload to HANA

Former Member
0 Kudos

Right now I have an Attribute view pulling from 5 different tables with different data. They are all connected with an ID.

I have a .csv file with columns that need to be uploaded to all 5 tables. The .csv columns dont have the same names as the current columns, but I can change this if i need to.

Right now I am importing the selected columns to each table and after I'm done they show up in my Attribute View fine.

I was just wondering if there is an easier way to do this, instead of importing the csv 5 different times.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

rindia
Active Contributor
0 Kudos

Hi Connor,

Within the HANA studio I guess there is no such feature but thinking out of the box it is possible in SAP Business Objects Data Services (ETL) where we can create batch job in which data flow contains as many flat files (CSV/excel) you want, do the transformations and run the job.

The output will be tables will be created in HANA.

Regards

Raj

Former Member
0 Kudos

Okay I will look into this. Thank you for your input

Answers (1)

Answers (1)

former_member185177
Contributor
0 Kudos

Hi Connor,

The only way to load the CSV files to "n" number of tables with automation is SAP BODS.

Please go through the suggestion which was provided by "Raj".

Regards,

Krishna Chaitanya.

Former Member
0 Kudos

Thanks, I will.