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