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 how to create tables using the import of metadata option from SAP DS.
Creating table in SAP HANA using the import of metadata option
This can be done in four simple steps.
