Learning outcomes

  • This course will prepare you to:
    • In this course delegates will learn about:
    • creating, executing, and transforming batch jobs using functions, scripts, and basic transforms to change the structure and formatting of data.
    • This course would ideally suit delegates who are new to SAP Data Services.

Content

  • Data Services
    • Defining Data Services
  • Source and Target Metadata
    • Defining Datastores in Data Services
    • Defining a Data Services Flat File Format
  • Batch Job Creation
    • Creating Batch Jobs
  • Batch Job Troubleshooting
    • Writing Comments with Descriptions and Annotations
    • Validating and Tracing Jobs
    • Debugging Data Flows
    • Auditing Data Flows
  • Functions, Scripts, and Variables
    • Using Built-In Functions
    • Using Variables, Parameters, and Scripts
  • Platform Transforms
    • Using Platform Transforms
    • Using the Map Operation Transform
    • Using the Validation Transform
    • Using the Merge Transform
    • Using the Case Transform
    • Using the SQL Transform
  • Error Handling
    • Setting Up Error Handling
  • Changes in Data
    • Capturing Changes in Data
    • Using Source-Based Change Data Capture (CDC)
    • Using Target-Based Change Data Capture (CDC)
  • Data Services Integrator Transforms
    • Using Data Services Integrator Transforms
    • Using the Pivot Transform
    • Using the Data Transfer Transform

Audience

  • Data Consultant / Manager
  • Solution Architect

Course Based on Software Release

  • SAP Data Services 4.3

Languages

Available in English

Prerequisites

Essential

  • Basic Knowledge of SQL

Recommended

  • Data Warehousing Concepts

Find a course date

Can't find a suitable date?

Booking for 1-2 people?

Make a request for us to schedule training around what works for you? We will do our best to consider your request.

Request a training date

Booking for 3 or more participants?

With our 3 to RUN initiative, you can request any standard classroom or virtual SAP Live Class on your timeline. Once the minimum participant threshold for your region is met, SAP and our partners will do our best to add it to the schedule.

Find out more

Languages

Available in English

Prerequisites

Essential

  • Basic Knowledge of SQL

Recommended

  • Data Warehousing Concepts