You will learn
This tutorial will guide you through the process of downloading sample data and database artifacts and importing it into SAP HANA using SAP Web IDE for SAP HANA.
SAP HANA XS Advanced, import tables and large datasets
Previous
Next
SAP HANA XS Advanced, import tables and large datasets
By Lsubatin
Import SHINE sample tables and data using SAP WebIDE for SAP HANA
Details
Step 1: Download the archive
Step 2: Import Archive
Import the archive into the data folder. This will probably be src\data. Right-click on the folder and choose Import->From File System:
Browse for the downloaded data.zip file, keep the Extract archive flag and click on OK.
Confirm that files with the same name will be overwritten
Step 3: Purge duplicates and Build
Delete the files FLIGHT.hdbcds, header.csv, item.csv and Purchase.hdbtabledata to avoid conflicts during build:
Build the db module:
Step 4: Check the imported entities in the Database Explorer
Formerly known as HANA Runtime Tools or HRTT in previous versions, the Database Explorer allows you to see the database artifacts you create in the different HDI containers. Use the middle icon on the left sidebar or from the menu, Tools->Database Explorer:
In SPS12, the HANA Runtime Tool was accessed from
https://<hostname>:51006or, forSAP HANA, express edition. fromhttp://<hostname>:51018
Next Steps
Updated 12/12/2017
Contributors Provide Feedback
Time to Complete
5 Min
Beginner
Prerequisites
- Tutorials: Create an HDI Module