“I appreciate the fact that we were able to easily deviate from the book when possible to cover more interesting & advanced topics. [Instructor] is very knowledgeable and honest about BO XI capabilities. Thanks.”
John F, FedEx

“[Instructor] is very knowledgeable in this subject and is able to communicate information in an easy, understandable manner. I look forward to doing the advanced class…”
– Kimberley G, Rogers Wireless

“This instructor gets a 10 out of 10. He is brilliant and has the expertise and teaching methodology that makes this type of course fun and educational. Highly recommend for future courses!!! OUTSTANDING!!!!!!!!!!!”
Attendee, Burger King Corporation

Course Description

This course is designed to provide the skills needed to implement Data Integration using ETL (Extract, Transform, Load) techniques with SAP Business Objects Data Services (Data Integrator). The course provides extensive hands on experience with several ETL transformations available within SAP Business Objects Data Services to prepare you for your data integration projects.

Audience

This course is targeted for technical users that have a basic knowledge of Data Warehousing and ETL concepts.

Objectives

After completing this course, students will be able to understand the ETL capabilities of SAP Business Objects Services. The course covers several ETL transforms such as Query, Map, Case, Validation, Merge, SQL, Pivot and more. Students will also learn how to debug their ETL, how to handle errors, manage various data sources, capture changes in data and do text processing. The course provides extensive hands on workshops in order to reinforce topics taught.

Duration & Version

3 Days – 4.x

Prerequisites

Basic knowledge of ETL processes is required. Also, working knowledge of databases and SQL is required.

Topics Covered

What is Data Services
Understanding the Data Services Architecture

Defining Datastores
Defining System Configurations
Handling Flat Files

Creating Batch Jobs
Creating Data Flows
Creating Workflows

Using Built-In Functions
Using Variables
Using Parameters
Using Scripts

Setting and Using Traces
Using the Debugger
Using Auditing

Map Operation Transform
Validation Transform
Merge Transform
Case Transform
SQL Transform

Source Based CDC
Target Based CDC

Using Error Handling

Using the Entity Extraction Transform

Using the Pivot Transform
Data Transfer Transform

Prefer Custom Training?

Schedule A Call