“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