Data Services - Platform and Transforms



This course is based on software release SAP BusinessObjects Data Services 4.2.


  • Application consultant
  • Developer
  • Developer consultant
  • Technology consultant


  • Basic Knowledge of SQL


  • Data Warehousing Concepts

Learning Objectives

  • Define Data Services
  • Define source and target connections
  • Trace, validate, and debug Data Services jobs
  • Use data services transforms
  • Implement change data capture in Data Services

1. Data Services

  • Defining Data Services

2. Source and Target Metadata

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

3. Batch Job Creation

  • 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. Error Handling

  • 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) Platform Transforms

  • Using Data Services (Integrator) Platform Transforms
  • Using the Pivot Transform
  • Using the Data Transfer Transform