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.
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.
Let's load data into SAP HANA from an Excel sheet in three simple steps.
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 ...