Import Data into SAP HANA Cloud, SAP HANA Database

SAP provides a free data model focused on flight data for anyone to use. We’re going to import this sample data and use it to help you complete the mission for Best Run Travel.

Download the SFLIGHT sample data from the public SAP GitHub repository and save it on your local machine.

Note the location of the file.

1. Under Instances and Subscriptions, open SAP HANA Cloud Central.

   

2. In the Actions column, click on the three dots and select the option to Open in SAP HANA Database Explorer.

   

3. SAP HANA database explorer will open in a new tab.

1. In the pane on the left, expand your database and right-click on Catalog.

2. Click on Import Catalog Objects.

   

3. Where it says Local archive, click on Browse and select the SFLIGHT file you previously downloaded to your local machine.

   

4. Wait until the archive is uploaded completely. You can see the status of the upload next to the Browse button.

   

5. Once the upload is completed, you will see a list of Catalog Objects. All of the objects will be automatically selected for import.

   

6. Keep all options as they are and then click on Import.

7. Once the import is completed, you will see a confirmation notification on the top right-hand side of the screen.

   

• Note that you can also import individual .csv files in a similar manner. Simply right click on Tables in your catalog and select Import Data.

  

• A wizard will guide you through the steps. You can select to add the data to an existing or new table and which schema the import should happen in.

  

• You will then be asked to specify the column mappings, as well as how errors should be handled.

  

Once the data is imported, you can take a look at it.

Click on Tables to view all your newly imported tables. Please note that your data will be automatically stored in a new schema named SFLIGHT.

To ensure that you can see your new tables, click on the Choose Schema button next to the schema name on the bottom left-hand side panel.

Then select the schema SFLIGHT. You can uncheck the default DBADMIN schema to see only the SFLIGHT tables you just imported.

Click OK and the list of available tables will be displayed on the same side panel.

If you want to see the data inside any of your tables, right click on any of them and then click on Open Data.

This will open the table on the main panel.

You can browse the dataset to get a better overview of the data available.

Well done!

You have completed the fifth tutorial of this mission! Now you know how to import tar.gz files to your database using the SAP HANA database explorer.

Learn in the next tutorial how to create and manage users and privileges.