SAP BODS stands for Business Objects Data Services (BODS) is an ETL tool which used for Data migration, data quality, data profiling and data processing such as Data ware housing, Data migration, Business Intelligence. SAP BODS is 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. SAP BODS will provides a easy and efficient interface to perform these specialist task which involve data manipulation. Proline Infotech will handle this SAP BODS Online Training with depth knowledge of subject matter for all the BODS topics. This BODS Training will provide good hands on experience and make you as a professional SAP BODS consultant.

Proline Infotech will handle this SAP BODS Module in Classroom and Online Training based on your flexible timings.

SAP BODS Training Road-map:

Lession-1: Introduction to SAP and BODS
  • Overview of SAP R/3 Architecture

  • Data Warehouse Overview

  • SAP Data warehouse product -SAP BW

  • Data Objects and Object Hierarchy

  • Data Service Tools and process

  • SAP BO Product Process and overview

  • Introduction to Repositories Objects

  • Overview of ETL tool in SAP BODS

  • Overview of Data warehouse implementations
Lession-2: SAP BODS Designer Overview
  • Overview of SAP BODS Designer

  • Introduction to CMC

  • Creating and Registering Repository to CMC (Local and Central)

  • Exploring the menu options in the designer

  • Creating the project, job flow, Data flow, Work flows etc.

  • Adding Repository to Job Server

  • Overview Source and Target metadata

  • Introduction to Data Stores and System Configurations

  • Defining file formats for flat, excel, XML files

  • Benefits and Uses of BODS Designer
Lession-3: Configure Batch Job
  • Overview of Batch Job

  • Create a project and Job

  • Configure work flow, data flow

  • Add query transform into data flow

  • Job execution, scheduling using Management

  • Query Transform

  • Use target tables

  • Use template tables

  • Benefits and Uses
Lession-4: Using built-in transforms and nested data
  • Overview of Built-In and Nested Data

  • Using the case, merge, and validation transforms

  • Benefits of the Pivot, reverse Pivot

  • Concept of Hierarchy flattening

  • Benefits and Uses
Lession-5: SAP BODS - Basic Configuration outline
  • Overview of Resiportary

  • Flow of Resiportary Manager-BODS Resiportary

  • Configure of Resiportary Types-Local, Central, Profile, Data Package

  • Flow of Resiportary Creation & Up gradation

  • Resiportary Server Manager Job Server

  • Introduction & Components-Management Console

  • Overview of Data Service Designer

  • Flow of ETL Tool
Lession-6: SAP Data Store and Formats
  • Data store-Overview & Types

  • Data store creation - DB, SAP, Adaptor, and Web service

  • Formats - Flat file, DTD, XSD, COBOL, copybooks

  • Flow of Data Extraction from Database Tables

  • Flow of Data Extraction from Excl Workbook- Multiple Sheets

  • Flow of Data Extraction from flat files (CSV, Notepad, and SAP Transport)

  • Flow of Data Extraction from XML FILE (DTD, XSD)

  • Flow of Data Extraction from COBOL Copybooks

  • Flow of Data Distribution to flat file & XML

  • Flow of Dynamic Extraction-File Selection & Sheet Selection

  • Benefits and Uses
Lession-7: SAP BO Data Services - Transforms
  • Overview of Transforms & Category (DI, DQ, PF)

  • Configuration of Data Transfer, Date Generation in Data Integrator

  • Configuration of Effective_Data, Hierarchy_Flatterning in Data Integrator

  • Concept of History _Preserving, Key _Generation in Data Integrator

  • Overview of Pivot, Reserve_Pivot, XML_Pipeline in Data Integrator

  • Concept for Platform-Case, Map_Operation, Merge, query

  • Concept for Platform-SQL, Validation, Custom ABAP Transform

  • Introduction, standard content directions in Data Quality

  • Dictionaries Configuration in Data Quality-

  • Data-Country_ID, Geocoder, Global_Adress_Cleanse

  • Benefits and Uses
Lession-8: Data Services in Scripting Language and Variables
  • Overview of Scripting Language and Variables

  • Explain differences between global and local variables

  • Create global variables and custom functions

  • Use strings and variables in Data Integrator scripting language

  • Benefits and Uses
Lession-9: Capturing Changes in Data
  • Overview of Change Data Capture (CDC)

  • Use Change Data Capture (CDC) with time-stamped sources

  • Flow of Source CDC concept and working

  • Flow of Target CDC concept and working

  • Working with Slowly changing Dimensions (type1,2,3)

  • Create an initial and delta load job

  • Use history preserving transform

  • Benefits and Uses
Lession-10: SAP BODS Data Services - Systems Handling
  • Overview of SAP BODS Data Services

  • SAP systems into, SAP Systems allowed, Terminology

  • SAP ERP/SAP BI Integration in SAP BODS

  • User & Role Creation in SAP BODS

  • SAP ERP -Data Flow, Interfaces, and Objects allowed to BODS

  • CREATING sap Application Data store-Properties

  • Flow of SAP ERP-Tables & Hierarchies Data Extraction

  • Flow of SAP ERP-Getting RFC enabled Functions Modules

  • Configure SAP ERP-IDOC Data Extraction & IDOC Data Loading

  • Flow of SAP ERP- Extracting Flat files data from SAP APP Server

  • Configure SAP BW-Data Flow, Interfaces Objects allowed to BODS

  • Flow of Creating SAP BW Source & SAP BW Target Data stores

  • Data from SAP BW info Providers-OHD in SAP BW-Extracting

  • Data from SAP BW bases tables-/BIC/ in SAP BW -Extracting

  • SAP BW -Loading data to SAP BW info Providers (MD & TD)

  • SAP BW -BW Jobs Execution overview

  • Benefits and Uses
Lession-11: SAP Integration - SAP BODS Training
  • Integration Overview in SAP BODS

  • Data extraction from ECC system to File, Table and

  • SAP BI Integration overview

  • Flow of Data extraction from ECC Extractors

  • Flow of Data Extraction from SAP BW

  • ABAP Workflows integration

  • Benefits and Uses
Lession-12: Introduction to SAP HANA
  • HANA Overview

  • Architecture overview of SAP HANA

  • Configurations in HANA and BODS

  • Loading data to SAP HANA using BODS

  • Benefits and features of HANA


Proline Infotech services are professional and solutions are unique and result oriented...

HCL Company Logo
Iteanz Company Logo
IBM Company Logo
Accenture Logo
Atos Company Logo
Genpact Company Logo
Infosys Company Logo
Wipro Company Logo


Enter your contact details,
we will call you back.