• phone icon +44 7836 212635 email message icon info@uplatz.com
  • Register
Job Meter = 9

SAP BODS 4.2 Training

40 Hours
Online Instructor-led Training
USD 700 (USD 1120)
Save 38% Offer ends on 31-Dec-2019
SAP BODS 4.2 Training online course and certification
62 Learners

About this Course
SAP BODS (SAP BusinessObjects Data Services, now known as SAP Data Services) is an ETL tool and a data processing platform used for extracting data from all types of dissimilar systems, transforming it into meaningful information and loading it into diverse types of systems. With full visibility into data quality, business users of an organization can see how their data measures up against information governance rules and standards.
In any enterprise data is one of the most valuable assets, but as the amount and variety of data keeps exploding, it is difficult for IT to manage and for business users to comprehend this data. SAP resolved this issue by introducing BODS to enable companies to transform, access, cleanse, enrich and deliver any kind of data from any source to any target at any frequency.

Uplatz offers this comprehensive SAP BODS training with complete focus on teaching students the core concepts of SAP BODS 4.2 and its implementation.
Through this SAP Data Services training you will understand the working and importance of SAP BODS to deliver data streamlining and management. Our training will cover each topic of SAP BODS in great detail for e.g. Basic Data Profiling, Query Transform, Platform Transforms Overview, Data Integrator Transforms, and more.

Did you know?

1. SAP BODS consolidates all information in the Enterprise Data Warehouse resulting in easy access to all data sources through local interfaces.
2. It fixes the data quality issues thereby harmonizing non-SAP data and SAP standards, enrich and cleanse data, remove duplicates.
3. It acts as a single platform for all data extraction, validation and cleansing rules, so that SAP and non-SAP data can be combined, cleansed and validated before loading into BW.


Why learn and get certified in SAP BODS 4.2?

1. Over a decade, since SAP acquired Business Objects, there is an never ending demand for Business Objects Data Services aka BODS or simply SAP DS as data migration tool.
2. The simplicity of development and maintenance of the code in terms of graphical flows helps the customers to move from SAP LSMW (Legacy Systems Migration Workbench) to BODS with minimal efforts.
3. Observing at SAP Data Services customers by industry, we find that Computer Software (15%) and Information Technology and Services (14%) are the largest segments. Hence validating your SAP BODS skill through certifications will always benefit you with better positions and salaries in these industries.


Objectives of SAP BODS 4.2 Training

1. Gain the knowledge to participate in implementing, administering, and managing data integration projects
2. Acquire the basis for more advanced training in Data Quality Services
3. Gain the ability to troubleshoot batch jobs and set up error handlings
4. Attain potential to create batch jobs for the data integration


SAP BODS 4.2 Training

Course Details & Curriculum

Lesson 1: BODS overview

·       Overview of SAP Data services
·       Data services benefits, associated products, interfaces
·       Data services Architecture on single and distributed environment


Lesson 2: BODS Designer concepts

·       Creating the repository (Local, Central repository)
·       Exploring the menu options in the Designer
·       Creating the Project, Job flow, Data flow, Work flows etc.
·       Defining different types of Data stores (Source and destination data stores)
·       Use data store and system configurations
·       Defining file formats for flat, Excel, XML files


Lesson 3: Batch Jobs

·       Creating Batch Jobs
·       Work with objects
·       Create a data flow
·       Adding the Query transform to the data flow
·       Use target tables
·       Execute the job


Lesson 4: Defining Data Integrator Transforms

·       Date Generation Transform
·       Pivot Transform
·       Reverse Pivot Transform
·       XML_Pipeline Transform


Lesson 5: Defining Data Platform Transforms

·       Query Transform
·       Case Transform
·       Merge Transform
·       Validation Transform
·       Row Generation Transform
·       SQL Transform


Lesson 6: Defining Data Quality Transform

·       Address Cleanse
·       Geocoder


Lesson 7: Implementation of SCD

·       SCD Type0
     a)       Query Transform

·       SCD Type1
     a)       Table Comparison Transform
     b)      Map_Operation Transform

·       SCD Type2
     a)       Table Comparison Transform
     b)      History Preserving Transform
     c)       Key Generation Transform


Lesson 8: Using Functions, Scripts, and Variables

·       Define built-in functions
·       Use functions in expressions
·       Use variables and parameters
·       Create Custom functions
·       Use Data Services scripting language


Lesson 9: Data assessment

·       Using the data profiler
·       Using the validation transform


Lesson 10: Setting up Error Handling

·       Set up recoverable work flows


Lesson 11: Setting up Exception Handling

·       Try/Catch Techniques


Lesson 12: IF Conditional

Lesson 13: While-Loop Implementation

Lesson 14: Capturing Changes in Data

Lesson 15: Data assessment

·       Update data over time
·       Use source-based CDC
·       Use target-based CDC
     a)       SCD Type 2


Lesson 16: Multi-User Environment (Local Repo vs. Central Repo)

Lesson 17: SAP Integration

·       Data extraction from ECC system to File, Table and SAP BI
·       Data extraction from ECC Extractors
·       Data Extraction from SAP BW
·       ABAP Workflows


Lesson 18: SAP HANA and SAP BODS Integration

·       Introduction to SAP HANA
·       Introduction to SAP HANA Studio
·       Create Data Store for SAP HANA
·       Perform the load into SAP HANA
·       Store the data in Column Store
·       Preview the data in SQL console of SAP HANA Studio


Lesson 19: Information Steward

·       Data Insight
·       Metadata management
·       Metapedia


SAP Certified Application Associate (C_DS_42), SAP Certified Application Associate (C_DS_41)

SAP BODS certification exams verify that the candidate has skills proficiency and comprehensive knowledge to use SAP Data Services in implementing, administering and managing ETL projects. They also measure the candidate’s knowledge of applying SAP BODS concepts to practical scenarios in data management for any organization such as sizing methods and performance tuning, implementing complex design methodology, performing data transformation, troubleshooting and recovery.


SAP BODS Certifications

1.       SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 (C_DS_42)

2.       SAP Certified Application Associate - Data Integration with SAP Data Services 4.x (C_DS_41)



SAP Certified Application Associate (C_DS_42)


There are no such prerequisites to register for this exam


Exam Details

1.       Exam duration is 180 minutes

2.       There are 80 Questions to be answered

3.       68% is the passing score

4.       Certification level is Associate



SAP Certified Application Associate (C_DS_41)


There are no such pre-requisites to register for this exam


Exam Details

1.       Exam duration is 180 minutes

2.       There are 80 Questions to be answered

3.       64% is the passing score

4.       Certification level is Associate


Didn't find what you are looking for?  Contact Us