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

Using SAP Data Services as an ETL tool to load data into SAP HANA

We use SAP Data Services to load data into SAP HANA when there are high transformations to be applied before loading. When the scheduled data load is enough, real-time data loading is not required. We can also make use of DS with a real-time mechanism when non-SAP sources are included. In this recipe, we will see the steps to load data using SAP DS to SAP HANA.

Getting ready

To load data using SAP DS, we need a minimum of SAP DS Version 4.0 or higher and SAP HANA installed.

How to do it…

Of the four ways mentioned to create tables, we have already seen the first two ways using SAP HANA Studio, that is, GUI and SQL Console in the Uploading data from flat files recipe.

Now we will see ...

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