SAP BODS training is an ETL tool used for datamarts, ODS system etc. Ensure complete and accurate information with enterprise class solution for data integration and data quality. user-define standards are published in a custom Cleansing Package which is useable by Data Services through the Data Cleanse transform. SAP BODS Training enhance to move data from any applications into SAP business suite deployment and master the data management.

By the end of this training you will:
– Acquire the relevant knowledge required to clear the SAP certification exam.
– Understand the core concepts of SAP’s BODS module.
– Be able to apply the knowledge learned to progress in your career as an associate level SAP BODS consultant.


A good bachelor’s degree in any field would be an advantage. Awareness to database technologies and basic software knowledge is advantageous but not a must.

32 Hours

Although there is no guarantee of a job on course completion, we are almost certain that you should be able to find a suitable position within a few weeks after successful completion of the course.

Concepts of DW

- Definition of DW
- Methodology
- Dimensional Modelling
- DW Lifecycle
- DW Challenges

Overview of ETL

- Introduction of ETL
- Stage Area
- Rules of Business
- Performance
- Slowly Changing Dimensions
- Surrogate Keys
- Facts & Dimension Tables
- Different ETL Tools

Overview of Business objects

- History
- Components
- Architecture

Data Services

- Data Services Purpose
- Data Services architecture
- Define Data Services objects
- Data Services Designer interface

Data Services objects

- Hierarchy of Object
- Jobs
- Workflows
- Data Flows

Source and Target Metadata

- Stores of Data
- File formats for flat files
- File formats for Excel files
- File formats for XML files
- Lab Exercises

Environment Setup

- Creation of repository
- Job Server Setting
- Setup for real-time operation
- Setting multiple data stores
- Starting the Job servers
- Lab Exercises

Batch Jobs

- Work with objects
- Creation of data flow
- Use the Query transform
- Use target tables
- Executing the job
- Lab Exercises

Troubleshooting Jobs

- Use descriptions & annotations
- Validate & tracing jobs
- Use View Data & the Interactive Debugger
- Use auditing in data flows
- Lab Exercises

Functions, Scripts & Variables

- Defining the built-in functions
- Functions in expression
- Lookup function
- Decode function
- Variables & parameters
- Data Service scripting language
- Scripting the custom function
- 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 mechanism
- Source based CDC
- Target Comparison
- Lab Exercises

Overview of Data Quality

- Fundamentals of DQ & Data Cleansing
- Built in DQ Transformation
- Data Validation
- Name & Address cleansing
- Deduplication
- Cleansing other data
- Lab Exercises

Webservices and Realtime Integration

- SOAP Introduction
- Web Services

SAP Integration

- Creating the datastores for SAP databases
- Accessing the SAP data
- Running ABAP programs
- R/3 Data flows