Goals

  • 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

Audience

  • Application Consultant
  • Developer
  • Developer Consultant
  • Technology Consultant

Prerequisites

Essential

  • Basic Knowledge of SQL

Recommended

  • Data Warehousing Concepts

Course based on software release

  • SAP BusinessObjects Data Services 4.2

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) Platform Transforms
    • Using Data Services (Integrator) Platform Transforms
    • Using the Pivot Transform
    • Using the Data Transfer Transform