Import Data into SAP HANA Cloud, SAP HANA Database
- How to import catalog objects from your local machine to your database using the SAP HANA Database Explorer
Christopher KollhedAugust 29, 2021
Prerequisites
- Sign up for the SAP HANA Cloud trial.
- Provision an instance of SAP HANA Cloud, SAP HANA database.
- If you have a production environment of SAP HANA Cloud, SAP HANA database, you may also follow the steps described in this tutorial.
Reminder: This tutorial is part of a mission, in which you will help Alex, the CEO of Best Run Travel, to answer a concrete business question with SAP HANA Cloud, SAP HANA database.
Alex needs to know the top 5 partners of their agency and wants to find out the days with maximum booking of each partner.
This mission consists of 9 modules that contain the necessary steps you need to follow in your mission to help Alex:
-
Start using an SAP HANA Cloud trial in SAP BTP Cockpit
-
Provision an instance of SAP HANA Cloud, SAP HANA database
-
Tools to manage and access the SAP HANA Cloud, SAP HANA Database
-
Create users and manage roles and privileges
-
You are here
-
Query the database using SQL statements
-
Create a development project in SAP Business Application Studio
-
Create a calculation view
-
Grant access to Calculation Views
In this tutorial, you will learn how to import data to your SAP HANA database in SAP HANA Cloud.
You can follow the steps in this tutorial also by watching this video:
About this video
This video is meant as additional support material to complete the tutorial. However, we recommend that you only use it for visual guidance but primarily focus on the written steps in this tutorial.
- Step 2
-
Open SAP BTP cockpit or SAP HANA Cloud Central.
-
Click on your instance and select the option to Open the SAP HANA Database Explorer.
-
The SAP HANA Database Explorer will open in a new tab.
Log in to complete tutorial -
- Step 3
-
In the pane on the left, expand your database and right-click on Catalog.
-
Click on Import Catalog Objects.
-
Where it says Local archive, click on Browse and select the
SFLIGHTfile you previously downloaded to your local machine.
-
Wait until the archive is uploaded completely. You can see the status of the upload next to the Browse button.
-
Once the upload is completed, you will see a list of Catalog Objects. All of the objects will be automatically selected for import.
-
Keep all options as they are and then click on Import.
-
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
.csvfiles 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.
Log in to complete tutorial -
- Step 4
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, called
SFLIGHT.To make sure 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 defaultDBADMINschema to see only theSFLIGHTtables 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, you can right click on any of them and then click on Open Data.
This will open the table on the main panel.
Feel free to browse the dataset now to get an 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 query the data.
Log in to complete tutorial