About this Course

SAP Data Services software helps organizations integrate, transform, and improve data at the project or enterprise level – for streamlined processes, greater efficiencies, and smarter, more informed decision making.

Audience Profile

This course is intended for the following audiences:

• Solution Architects
• Data Consultants & Data Managers
• Super Users / Key Users / Power Users

Course Outline

1. Defining Data Services

2. Source & Target Metadata

• Defining Datastores in Data Services
• Defining a Data Services Flat File Format

3. Creating Batch Jobs

4. Batch Job Troubleshooting

• Writing Comments with Descriptions and Annotations
• Validating and Tracing Jobs
• Debugging Data Flows
• Auditing Data Flows

5. Functions, Scripts, and Variables

• Using Built-In Functions
• Using Variables, Parameters, and Scripts

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

7. Setting Up Error Handling

8. Changes in Data

• Capturing Changes in Data
• Using Source-Based Change Data Capture (CDC)
• Using Target-Based Change Data Capture (CDC)

9. Data Services Integrator Transforms

• Using Data Services Integrator Transforms
• Using the Pivot Transform
• Using the Data Transfer Transform