SAP BODS Technical


The purpose of SAP BODS Technical is to give every student a good grasp of BODS product so that he/she can create his or her product repository, configure a job server and start and execute job plans smoothly. BODS currently is an ETL tool acquired by SAP and designed for use in all types of disparate systems, extract and transform information from them and finally load them in all types of systems. Since it is fully integrated with SAP now, it can also be used as an extremely efficient tool for transferring data from legacy systems to current generation SAP systems with a highly efficient debugging and monitoring capabilities.

Here at, we primarily focus on the core areas of SAP BODS technical along with touching upon the fringe areas as well which we think comes handy at times. If you take a look at our syllabus, you will see that it is extensive and follows a pattern which would help every student learn everything about BODS. So join us today and let us turn you into a BODS expert in no time at all.


  • Introduction
      What is Data Warehouse
      Data Warehouse Functions & Implementation
      Data Warehouse Products & Venders
      About SAP’s DatawareHouse-SAP BW
      SAP BW functions, Benefits & Limitations
      About Business Objects & their Products
      Why SAP Acquired Business Objects
      Data Centric Vs Process Centric DWH system.
  • SAP BO Data Service Overview
      About Data Services - Introduction
      Functions - Data Integration & Data Management
      Data Services Product Evolution(ATL, DI & DQ)
      Architecture – by Components
      Data Services Tools & its functions
      Data Services Objects & Objects 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
      Repository Creation & Up gradation
      Server Manager-Job Server(JS) & Access Server(AS)
      JS & AS Creation, Job Server-Repository Assignment
      Management Console – Introduction & Components
      Data Service Designer – Introduction & GUI
      Getting Started with Designer to Develop First ETL Flow
  • Data store & Formats
      Datastore-Overview & Types
      Datastore Creation - DB,SAP, Adopter, Web Service
      Formats – Flat files, Excel, DTD, XSD, COBAL Copybooks
      Data Extraction from Database Tables
      Data Extraction from Excel Workbook – Multiple Sheets
      Data Extraction from Flat files ( CSV, Notepad, SAP Transport)
      Data Extraction from XML File ( DTD, XSD)
      Data Extraction from COBOL Copybooks
      Data Distribution to Flat File & XML
      Dynamic Extraction – Files Selection & Sheet Selection
  • Data Services-Transforms
      Transforms & Categories (DI, DQ, PF)
      Data Integration – Data_Transfer, Date_Generation
      Data Integration – Effective_Date, Hierarchy_Flattening
      Data Integration – History_Preserving, Key_Generation
      Data Integration – Pivot, Reverse_Pivot, XML_Pipeline
      Platform – Case, Map_Operation, Merge, Query
      Platform – SQL, Validation Custom ABAP Transform
  • Data Services-Advance Level
      BODS Admin Console – Administration, Auto Reporting.
      Real time Jobs, Embedded Data Flows Variables, Parameters,
      Substitution Parameters, System Config
      Debugging, Recovery Mechanism
      Data Assessment – Data Profiling
      BODS Performance Tuning Techniques
      Multi-User Development Environment - Intro & Advantages
      Multi-User Environment Implementation & Migration
      BODS Object Migration Techniques
  • Data Services-SAP Systems Handing
      SAP System – Intro, SAP System allowed, Terminology
      SAP BODS and SAP ERP / SAP BI Integration
      SAP BODS User & Role creation in SAP
      SAP ERP – Data Flow, Interfaces, Objects allowed to BODS
      Creation SAP Application Datastore – Properties
      SAP ERP – Tables & Hierarchies Data Extraction
      SAP ERP – Getting RFC enabled Functions Modules
      SAP ERP – IDOC Data Extraction & IDOC Data Loading
      SAP ERP - Extraction Flat file data from SAP APP Server
      SAP BW - Data flow, interfaces, Objects allowed to BODS
      Creating SAP BW Source and 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
      Rapid Marts – Introduction, Advantages, Limitations
      Total Rapid Marts SAP offering, Rapid Marts for SAP Solution
      Rapid Marts – Versions, Dataflow, Content
      Why and Whom to go for Rapid Marts implementation?
      Rapid Marts implementation Out of Box:
      - Environment Checklist
      - Recommend for Upgradation
      - Environment setup ( Pre installation phase)
      - Installation of RM(Data Model, ETL, Visuals)
      - Configuration of RM ( ETL, Visuals)
      - RM File and Custom ABAP Transform Maintenance
      - Rapid Mart directory Maintenance
      Rapid Marts Testing - Sample Data Loads, Testing Reports
      Rapid Marts Recovery Mechanism – For Delta Loads
      Rapid Marts implementation – Customization (as per Req.)
      - Data Model Customization
      - ETL Customization
      - Visuals Customization
      Rapid Marts Performance Tuning Techniques (Standard)

HILL VIEW APARTMENT, Mumbai -400084rnPhone:+91-9930840631rn