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.

Course Objectives

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.

Prerequisite

Essential 
None


Recommended/Additional 
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.

Duration

32 Hours

Placement

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.

Course Preview
1
Concepts of DW

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

2
Overview of ETL

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

3
Overview of Business objects

- History
- Components
- Architecture

4
Data Services

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

5
Data Services objects

- Hierarchy of Object
- Jobs
- Workflows
- Data Flows

6
Source and Target Metadata

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

7
Environment Setup

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

8
Batch Jobs

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

9
Troubleshooting Jobs

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

10
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

11
Important Transforms

- Map Operation transform
- Validation transform
- Merge transform
- Case transform
- SQL transform
- Lab Exercises

12
Other Transforms

- Pivot transform
- Hierarchy Flattening transform
- Data Transfer transform
- XML Pipeline transform
- Lab Exercises

13
Error Handling

- Error Handling
- Recoverable work flows

14
Change Data capture

- Update data over time
- Database native CDC mechanism
- Source based CDC
- Target Comparison
- Lab Exercises

15
Overview of Data Quality

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

16
Webservices and Realtime Integration

- SOAP Introduction
- Web Services

17
SAP Integration

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