Uploading data from flat files
Having learned about SAP HANA, its components, and its architecture, let's begin loading data into SAP HANA now. In this recipe, we will see how to load data from flat files.
Getting ready
To load data into SAP HANA from flat files, we will require the files in the form of a CSV or an Excel file (Office 1997 or above) saved in the client machine where we use SAP HANA Studio.
How to do it…
Let's load data into SAP HANA from an Excel sheet in three simple steps.
Step 1 – creating a table in the SAP HANA system
Initially, we create a table in the SAP HANA system. Then, we load the data to the newly created table. A table can be created either using SQL Console by writing a SQL code, or by using the graphical interface. We will see both the cases, as follows:
- Using SQL Console: From Quick Launch, select SQL Console. This will launch SQL Console. Write the following code and execute it to create a table. On successful execution, a message will...
