SAP Data Services is a one-stop solution from SAP to manage your data integration, cleansing, transformations, and data management.

A batch job in SAP Data Services, is a scheduled background program that executes workflows, which extract data from data stores like databases, flat-files, and transform the data, based on the requirements, and load the transformed data into target data store.

Workload Automation plug-in: The SAP Data Services plugin is available in Automation Hub marketplace for download and will help you to schedule and monitor the SAP Data Services workflows and batch jobs from Workload Automation.

Job definition of this plug-in contains two parts such as connection properties and actions.

Workload Automation

Figure 1: Job Definition page

Connection parameters: these details refer to the URL of the data service management console, user credentials and authentication type.

Workload Automation

Figure 2: Connection page

Action: once you establish the connection to SAP Data Services CMS server by providing connection details then it is time to configure the action part by fetching the batch job that needs to be scheduled. It requires additional information like repository name, and the optional job server and server group information.

Workload Automation

Figure 3: Action page

Once you are done the job definition, the next step is to submit the job into the plan and schedule.

 Monitor the job The actual Data Services batch job may take hours to complete based on your ETL/ELT workflows.  This plug-in provides the capabilities to monitor the status of the batch job.

Workload Automation

Figure 4: Workflow Details page

And once the job completes, the different log information available in the SAP Data Services are captured and available as part of the plug-in job log.

Workload Automation

Figure 5: Job log

Workload Automation

Are you curious to try out the SAP Data Services plug-in? Download the integrations from the Automation Hub.



Comment wrap
Further Reading
Automation | September 28, 2022
See your scheduling metrics on Prometheus and Grafana
Recent versions of Workload Automation product are capable of seamless integrating with observability products such as Dynatrace, Instana, Datadog, Splunk and others. This is useful specially for companies that have large operations teams which are already monitoring applications on those observability solutions.
Automation | September 26, 2022
Easy Websphere’s Liberty Management for the Workload Automation Administrator
HWA main components (MDM / DWC) since version 9.5 are deployed on WebSphere liberty, which is a modern Java EE runtime that was designed to be highly efficient and optimized for modern cloud technologies.From an HWA administrator point of view, one of the main noticeable things after upgrading or installing 9.5 /10.1 is the missing WebSphere console, which helped HWA administrators that are not WebSphere experts on configuring WebSphere settings using the friendly UI.
Automation | September 8, 2022
CASE STUDY : Retail SuperMarket UseCases over Self Service Catalogue
In this Blog , we are looking at a Retail Outlet who provide home delivery of Orders by segregating Orders into Vans and segregating Vans into Waves where each Wave would comprise of Several Vans and each Van would comprise of several orders and how the Retail Outlet manages Order Cancellations , Van Closures etc on Stores front through Self Service Catalogue thereby avoiding direct interaction of Store Personnel with the Background DBs or the underlying APIs exposed by the Application.
Filters result by