SAP BODS 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.

Section Heading

Course Information

Duration: 40 Hours

Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

Method: Online/Classroom Training

Study Material: Soft Copy

System Access: For 1 month

Course Content


  • What is a Data Warehouse?
  • Data Warehouse Functions & Implementation
  • Data Warehouse Products & Vendors
  • About SAP & their Products
  • SAP’s Data Warehouse product – SAP BW
  • SAP BW functions, Benefits & Limitations
  • About BusinessObjects & their Products
  • Why SAP Acquired BusinessObjects
  • Data Centric Vs Process Centric DWH system
  • BusinessObjects Vs SAP BOBJ
  • SAP BOBJ Product Portfolio – BI, EIM, EPM, GRC, AA

SAP BOBJ Data Services Overview

  • About Data Services – Introduction & BI Platform
  • Functions – Data Integration & Data Management
  • Data Services Product Evolution (ATL, DI & DQ)
  • Architecture – by Components
  • Installation of Data Services on Windows
  • Data Services Tools & its functions
  • Data Services Objects & Object Hierarchy
  • BODS Objects Naming standards
  • BODS Objects comparison with SAP BW Objects

Data Services – Basic Level

  • Repository Manager – BODS Repository
  • Repository Types – Local, Central, Profile, Data Package
  • Repository Creation & Upgradation
  • Server Manager – Job Server (JS) & Access Server (AS)
  • JS & AS Creation, Job Server-Repository Assignment
  • Metadata Integrator – Sharing the BODS Metadata to BOXI
  • License Manager – Adding or Upgrading the Keys
  • Management Console – Introduction & Components
  • Data Service Designer – Introduction & GUI
  • Getting Start with Designer to develop First ETL Flow

Datastore & Formats

  • Datastore – Overview & Types
  • Datastore creation – DB, SAP, Adaptor, Web Service
  • Formats – Flat file, Excel, DTD, XSD, COBOL Copybooks
  • Data Extraction from Database Tables
  • Data Extraction from Excel Workbook – Multiple Sheets
  • Data Extraction from Flat file (CSV, Notepad, and SAP Transport)
  • Data Extraction from XML File (DTD, XSD)
  • Data Extraction from COBOL Copybooks
  • Data Distribution to Flat File & XML
  • Dynamic Extraction – File Selection & Sheet Selection

Data Services – Transforms

  • Transforms & Category (DI, DQ, PF)
  • Data Integrator – Data_Transfer Transform, Date_Generation Transform
  • Data Integrator – Effective_Date, Hierarchy_Flattening
  • Data Integrator – History_Preserving, Key_Generation
  • Data Integrator – Map_CDC_Operation, Table_Comparision
  • Data Integrator – Pivot, Reverse_Pivot, XML_Pipeline
  • Platform – Case, Map_Operation, Merge, Query
  • Platform – SQL, Validation, Custom ABAP Transform
  • Text Analysis – Introduction & TDP vs. TA
  • Text Analysis – Base Entity Extraction Transform
  • Text Analysis – Unstructured Data Extraction, Dictionaries & Rules and Language Modules

Data Services – Advance Level

  • BODS Admin Console – Administration, Auto Reporting
  • Real time Jobs, Embedded Data Flows & Security
  • Variables, Parameters, Substitution Parameters, System Config
  • Debugging, Recovery Mechanism
  • Data Assessment – Data Profiling
  • BODS Performance Tuning Techniques
  • Multi-User Development Environment – Into & Advantages
  • Multi-User Environment – Implementation & Migration

Data Services – SAP Extraction Introduction

  • SAP Systems – Into, SAP Systems allowed, Terminology
  • SAP BODS and SAP SAP / SAP BI Integration
  • SAP BODS User & Role creation in SAP

Data Services – SAP SAP Extraction

  • SAP SAP – Data Flow, Interfaces, and Objects allowed to BODS
  • Creating SAP Application Datastore – Properties
  • SAP SAP – Tables & Hierarchies Data Extraction
  • SAP SAP – Getting RFC enabled Functions Modules
  • SAP SAP – IDOC Data Extraction & IDOC Data Loading
  • SAP SAP – Extracting Flat file data from SAP APP Server
  • Data Services – SAP BW/BI Extraction & Loading
  • SAP BW – Data Flow, Interfaces, and Objects allowed to BODS
  • Creating SAP BW Source & SAP BW Target Datastores
  • SAP BW – Extracting Data from SAP BW InfoProviders – OHD
  • SAP BW – Extracting Data from SAP BW bases tables - /BIC/
  • SAP BW – Loading data to SAP BW InfoProviders (MD & TD)
  • SAP BW – BW Jobs Execution

Data Services – SAP Advanced Concepts

  • SAP BusinessObjects Rapid Marts – Introduction & Overview and differences between 3.x and 4.x
  • SAP BusinessObjects Extractors Extraction – Introduction of ODP, SAP DataSources Extraction, SAP Delta Mechanism and DOP Queue
  • SAP Data Migration with BODS – Data Migration Techniques, BODS Data Migration to SAP, Data Migration Tool Introduction and Overview

Key Features

Instructor Led Online Training

Flexible Time At Your Convenience

Over 1,00,000+ Professionals Trained Across 100 Countries

24x7 Live Support via Chat, Mail and Phone

Corporate Training and On-Job Support

Request For Demo

Training Calendar

Module Classroom/Online Location
SAP EWM  Online Instructor-Led Online
SAP TM Online Instructor-Led Online
SAP GTS Online Instructor-Led Online
SAP MM Online Instructor-Led Online

Our Clients