Signup as a Tutor

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

SAP BODS Online Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: Goto Meeting

Course ID: 17041

Course type: Online Instructor led Course

Platform: Goto Meeting

Students Interested 0 (Seats Left 0)

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

5 Avg Rating

13 Reviews

1 Students

15 Courses


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 Be the First to Review


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for SAP Training Post your requirement now


Submit your enquiry for SAP BODS Online Training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Marks Solutions

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer 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