SAP HANA – data import from file

SAP HANA – data import from file

SAP HANA
In SAP BW instant data load from Excel or from CSV file is quite tiring, especially when it’s one time load for testing purposes or Proof of Concept. Fortunately in SAP HANA there is easy and convenient way of data import from file. Using Import Data from Local file you can: Import CSV or Excel files; Create new table as a target or use existing one. When you file is ready, to import it to SAP HANA using HANA Studio: 1. Select File – Import – SAP HANA Content – Data from Local File. 2. Choose target system where you would like to import data. 3. Choose source file (from computer). 4. Define file details (field delimiter, header row, start and end line). 5. Select existing target table or create…
Read More