Loading data in SAP HANA with Data Services Workbench

SAP Data Services is an all-in-one solution for data integration. It helps customers with various information management capabilities such as ETL, profiling, text analytics, and metadata management.

Up until now, before Data Service Workbench was introduced, we used to perform the following steps for data loading in SAP HANA via Data Services: Import Metadata into Data Services Workbench (source system HANA relevant) | create DS jobs to push data in SAP HANA | schedule/run the DS job | data is then available in the relevant schema in SAP HANA.

With Data Services Workbench, the job is much simpler, and we will focus on it here. Data Services Workbench is a new feature and was released with Data Services 4.1. It's part of the installation package for Data services 4.1.

Data Load with SAP Data Services Workbench

These are the steps to set up data provisioning in HANA using Data Services Workbench:

Note

Source Database setting | Test the connection...