O'Reilly logo

SAP HANA Cookbook by Ganesh Mahadevan V., Chandrasekhar Mankala

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required