“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
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.
This course is targeted for technical users that have a basic knowledge of Data Warehousing and ETL concepts.
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
Basic knowledge of ETL processes is required. Also, working knowledge of databases and SQL is required.
What is Data Services
Understanding the Data Services Architecture
Defining System Configurations
Handling Flat Files
Creating Batch Jobs
Creating Data Flows
Using Built-In Functions
Setting and Using Traces
Using the Debugger
Map Operation Transform
Source Based CDC
Target Based CDC
Using Error Handling
Using the Entity Extraction Transform
Using the Pivot Transform
Data Transfer Transform