Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"SAP BODS Online Training" is no longer available

No Reviews Yet

Course type: Online Instructor led Course

Platform: Goto Meeting

Course ID: 17041

Course type: Online Instructor led Course

Platform: Goto Meeting

Sekhar picture
No Reviews Yet

About the Course

What is SAP BODS ?

It is an ETL tool currently acquired by SAP used for integration with all types of disparate systems, extracting data from them, transforming them into meaningful information and loading them into all types of systems.
It is tightly integrated with SAP systems and hence really a good tool to migrate data from legacy systems to SAP systems with ease and less development efforts with effective debugging and monitoring capabilities.
BODS Business Objects Data Services is a GUI workspace that allows to create jobs that extracts data from heterogeneous sources, transforms that data using built-in transforms and functions to meet business requirements and then loads the data into a single datastore or data warehouse for further analysis.
SAP Business Objects Data Services can be used for both real-time and batch jobs.

Topics Covered

DW Concepts
Dimensional Modeling
DW Lifecycle
DW Challenges
ETL Overview
ETL introduction
Staging Area
Business Rules
Slowly Changing Dimensions
Surrogate Keys
Facts and Dimension Tables
Different ETL Tools

Business Objects Overview
Data Services
Purpose of Data Services
Data Services architecture
Define Data Services objects
Data Services Designer interface
Data Services Objects
Object Hierarchy
Data Flows
Source and Target Metadata
Data Stores
File formats for flat files
File formats for Excel files
File formats for XML files
Lab Exercises
Environment setup
Creating repository
Setting Job Server
Setup for realtime operation
Setting multiple datastores
Starting Job servers
Lab Exercises
Batch Jobs
Work with objects
Create a data flow
Use the Query transform
Use target tables
Execute the job
Lab Exercises
Troubleshooting Jobs
Use descriptions and annotations
Validate and tracing jobs
Use View Data and the Interactive Debugger
Use auditing in data flows
Lab Exercises

Functions, Scripts and Variables

Define built-in functions
Functions in expressions
Lookup function
Decode function
Variables and parameters
Data Services scripting languag
Scripting custom functions
Lab Exercises
Important Transforms

Map Operation transform
Validation transform
Merge transform
Case transform
SQL transform
Lab Exercises
Other Transforms
Pivot transform
Hierarchy Flattening transform
Data Transfer transform
XML Pipeline transform
Lab Exercises
Error Handling
Error Handling
Recoverable work flows
Change Data Capture
Update data over time
Database native CDC mechanisms
Source-based CDC
Target Comparison
Lab Exercises
Data quality Overview
Fundamentals of DQ and Data Cleansing
Built in DQ Transformations
Data Validation
Name & Address cleansing
De duplication
Cleansing other data
Lab Exercises
Web-Services and Real-Time Integration
Real Time Jobs
SOAP Introduction
Web Services
SAP Integration
Creating datastores for SAP databases
Accessing SAP data
Running ABAP programs
R/3 Data flows

Who should attend

SAP BI & SAP BO Consultants , Data warehousing guys


Basic knowledge of BI & BO

What you need to bring

Just need an internet conncetion

Key Takeaways

Good understanding of BODS.

Date and Time

Not decided yet.

About the Trainer

Sekhar picture

Avg Rating





SAP ABAP Consultant

Mr.Sekhar has been working in SAP ABAP From last 7 yrs and he is Certified ABAP Consultant.. Specialized in SAP ABAP, Webdynpro, OOPs, Workflow Areas and has a track record of completing 250 batches till now from last 4 yrs with us.


No reviews currently


Post your requirement and let us connect you with best possible matches for SAP Training Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more