Import Data into a Table in SAP HANA Database Project

Now you can create the first object in your project: an HDBTABLE that will store the sample data used in this tutorial. After you have opened your dev space in SAP Business Application Studio, click to select the project you created in the previous tutorial.

1. In the explorer panel on the left side, expand the folders under your Project WS3_1. Click on the src folder.

   

2. To create a new SAP HANA Database Artifact, you can press the F1 key or click on View – Find Command at the top of the screen to open a search prompt. Enter HANA in the field and from the dropdown list of functionalities, choose SAP HANA: Create SAP HANA Database Artifact.

   

3. In the window for creating a new SAP HANA Database Artifact, click on the folder icon in the first field (Choose path where you want to create the artifact). Navigate to your project, the src folder, and then click on Open.

4. Select the artifact type as Table (hdbtable).

5. In the field Specify the artifact name, enter ‘inventory’.

6. The database version should be HANA Cloud, by default. Without making any further changes, click on Create.

7. A new file inventory.hdbtable can be seen under the src folder in the EXPLORER panel.

1. Click on the inventory.hdbtable file to open the file window. You can see that the file only contains the code column table "inventory" (). Remove the default code in this file and paste the code below in it to add the column definitions to this new table.

   The name of the table in this code must be written in upper case characters.

   SQL

   Copy

     column table "INVENTORY" (
      "PRODUCT"  NVARCHAR(10),
      "PRODUCTDESCRIPTION"  NVARCHAR(80),
      "MATERIAL"  NVARCHAR(80),
      "MATERIALDESCRIPTION"  NVARCHAR(80),
      "DESTINATIONCOUNTRY"  NVARCHAR(2),
      "DESTINATIONCOUNTRYDESCRIPTION"  NVARCHAR(80),
      "DESTINATIONREGION"  NVARCHAR(80),
      "REGIONDESCRIPTION"  NVARCHAR(80),
      "INVENTORYLOCATION"  NVARCHAR(80),
      "INVENTORYLOCATIONDESCRIPTION"  NVARCHAR(80),
      "LOCATIONLAT"  DECIMAL(22, 6),
      "LOCATIONLONG"  DECIMAL(22, 6),
      "TARGETSTOCKQTY"  DECIMAL(22, 3),
      "ONHANDSTOCK"  DECIMAL(22, 3),
      "REPORTINGTIME"  DATE,
      "TARGETANALYSIS"  NVARCHAR(80),
      "TARGETANALYSISDESCRIPTION"  NVARCHAR(80),
      "SOURCECOUNTRY"  NVARCHAR(2),
      "SOURCECOUNTRYDESCRIPTION"  NVARCHAR(80),
      "SOURCEREGION"  NVARCHAR(80),
      "SOURCEREGIODESCRIPTION"  NVARCHAR(80),
      "SOURCESITE"  NVARCHAR(80),
      "SOURCESITEDESCRIPTION"  NVARCHAR(80),
      "SOURCELAT"  DECIMAL(10, 6),
      "SOURCELONG"  DECIMAL(10, 6),
      "LOGISTICCENTERS"  NVARCHAR(80),
      "LOGISTICCENTERDESCRIPTION"  NVARCHAR(80),
      "PHYSICALROUTECONNECTION"  NVARCHAR(1),
      "PHYSICALROUTECONNECTIONDESCRIPTION"  NVARCHAR(1)
   )
   

   You can right-click inside the file window and choose Format document to clean up the formatting of the file.

2. On the bottom left corner, you can see in the SAP HANA Projects panel that the table has been added.

   

3. Click on the

   
   deploy icon next to the inventory.hdbtable to deploy the table to your HDI container. You can check in the terminal if the table was successfully deployed. Alternately, you can also deploy by clicking on the deploy icon on the project level (WS3_1/db).

1. In the SAP HANA Project panel, click on the

   
   HDI container icon. The SAP HANA Database Explorer will open in a new tab.
   

2. In the catalog of the HDI container connection, click on Tables. If you cannot see the INVENTORY table, right-click on Tables and select Refresh.

3. Click on the INVENTORY table to view the list of all the columns you have just defined.

   

If you click on Open Data, you can see that the table does not contain any data yet. Let’s change that!

1. To download the sample data from the GitHub repository, click here. Select the Download option for the Sample Data.zip file under the folder location SAP-samples/ hana-cloud-learning/ Workshop: Collaborative Development.

2. You need to unzip the Sample Data.zip file before it can be used to upload into the table.

3. Go back to the SAP HANA Database Explorer, right-click on the INVENTORY table and select Import Data.

   

4. A wizard opens where you can select Import Data as IMPORT TYPE. Click on Step 2.

5. Under IMPORT SOURCE, select Local to specify where the data is imported from. Click on Browse to find the unzipped CSV file on your local machine. Click on the CSV file and select open. Click on Step 3.

6. Under IMPORT TARGET, name the Table as INVENTORY unless it’s not named so by default. Click on Step 4.

7. Under TABLE MAPPING, verify that the column properties match with the column definition that you had used to create the inventory.hdbtable. After the check is complete, click on Step 5.

8. Under ERROR HANDLING, select the option Save all successful rows and list the errors (if any). Click on Review.

9. After reviewing the Import Summary, click Import into Database. Wait until the Import Status shows the Import complete notification.

   

10. To verify the data import, click on INVENTORY table from the left side panel. Select Open Data to view the data added into the table.

1. Now that your data is imported successfully, you can preview it using the Analysis functions of the SAP HANA Database Explorer.

2. In the Open Data window, click on Analysis to view the data in the form of graphs.

3. For example, you can drag PRODUCT from the list of Available Columns to the Value Axis and REGIONDESCRIPTION to the Label Axis to see how products are distributed over regions.

   

4. You can select different graphical options provided in a main toolbar at the top or access the corresponding SQL code to these graphical views.

You have successfully completed the second tutorial. In the next tutorial, you will change data structures by adding columns to a table using HDBTABLE and HDBMIGRATIONTABLE objects.