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 ...
Get SAP HANA Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
