SAP BODS — Course Content

COURSE: SAP BODS/Data Services/Data Integrator


  • Introduction to Integration Approaches
  • What is ETL?
  • What is Data Warehouse?
  • Introduction to Data warehouse implementations

SAP Business Objects Data Services Overview

  • History of SAP BODS [evolution, acquisitions etc.]
  • Data Services Architecture
  • Data Services Tools & its functions
  • Data Services Objects & Object Hierarchy
  • Various implementations using BODS

Data Services Basic Level

Understanding Data Integrator

  • Describe components, management tools, and the development process
  • Explain object relationship

Defining source and target metadata

  • Create a database datastore and import metadata
  •  Create a new file format and handle errors in file formats

Validating, tracing, and debugging jobs

  • Using descriptions and annotations
  • Validate and trace jobs
  • Using View Data and the Interactive Debugger

Creating a batch job 

  • Create a project, job, workflow, and data flow
  • Using the Query transform in a data flow
  • Using template tables

Data Services Advance Level

Using built-in transforms and nested data 

  • Using the case, merge, and validation transforms
Data Services Advance Level cont.…

  • Import metadata from XML documents
  • Using the XML_Pipeline in a data flow

Using built-in functions

  • Using date and time functions and the date generation transform to build a dimension table
  • Using the lookup functions to look up status in a table
  • Using match pattern functions to compare input strings to patterns
  • Using database type  functions to return information on data sources

Using Data Integrator Scripting Language and variables

  • Explain differences between global and local variables
  • Create global variables and custom functions
  • Using strings and variables in Data Integrator scripting language

Capturing Changes in Data

  • Using Changed Data Capture (CDC) with time-stamped sources
  • Create an initial and delta load job
  • Using history preserving transforms
  • Implementing SCD Type 0,1,2,3

Handling errors and auditing

  • Recover a failed job
  • Create a manual, recoverable workflow
  • Define audit points, rules, and actions on failures

Supporting a multi-user environment 

  • Describe terminology and repository types in a multi-user environment
  • Create and activate the central repository
  • Work with objects in the central repository

Migrating Projects

  • Create multiple configurations in a data store
  • Work with projects in the central repository
  • Create a secure central repository
  • Implement and modify group permissions

Profiling Data

  • Set up the Data Profiler and users
  • Submit a profiling task
  • Monitor profiling tasks in the Administrator

Managing Metadata

  • Import and export metadata
  • Using Metadata Reports

Performance Tuning

Datastore & Formats

  • Datastore – Overview & Types
  • Datastore creation- DB, SAP, Adaptor, Webservice
  • Formats-Flat file, Excel, DTD, XSD

Data Services Transforms

  • Overview of Transforms & Category (DI, DQ, and PF)
  • All Transforms of Data Integrator and PF will be covered with examples
Data Services Administration

  • Management Console operations
  • Server Manager Operations
  • Repository Manager Operation
  • License Manager – adding and upgrading license keys
  • Execute, schedule, and monitor batch jobs

Data services SAP System Handling

  • SAP Systems-Introduction
  • SAP BODS and SAP ERP/BW integration
  • Creation of SAP ERP Datastore and overview of properties
  • Creation of SAP BW source & target Datastores and overview of properties
  • SAP ERP creating and getting RFC enabled Function Modules
  • SAP ERP Tables data extraction
  • SAP BW Dataflow, Interfaces, objects allowed to BODS
  • SAP BW Extracting data from SAP BW Infoproviders
  • Introduction to RAPID MARTS

Introduction to SAP HANA 

  • Configurations in HANA and BODS
  • Loading data to SAP HANA using BODS


Real Time Scenarios with advanced examples

Real-Time Environment Explanation

  • Project Landscape
  • Deployment Procedure
  • Production Support Procedure
  • Documentation

Suggestions for Resume Preparation

Suggestions for Interview Preparation

SAP DATA SERVICES 4.0 Introduction


  • About SAP Business Objects Suite (BI & EIM).
  • SAP Data Services 4.0 Introduction & Overview.
  • SAP Data Services4.0 Administration & Configuration (Server Manager, DSM Console).

New Functionalities & Features

Graphical User Interface

  • Server Manager, Designer.
  • Management Console, CMC/Information Platform Services (IPS).

New Security Features

  • User Management in CMC/IPS.
  • Data Services Standard Users & User Groups.
  • User Security-Local Repository & Central Repository & DSM Console.
  • Transforms- Data Integrator, Data Quality & Platform.
  • Password Encryption.

Text Data Processing

  • About SAP Data Services Text Analysis.
  • Text Analysis in Data Services 4.0.
  • Introduction to Text Services Platform and Administrator.
  • Maintaining Text Services Platform.
  • Extracting Text Data- Email, Text, Portal Data, Internet Data.
  • New Flat File Format Types – Unstructured Text, Unstructured Binary.

Architecture & New Services

  • 64 Bit Server Components.
  • Adaptive Processing Server (EIM Service).
  • Performance & Memory Utilization Performance features.

Transforms & Functions

  • New Validation Transform Features.
  • New Joins in Query Transform.
  • New Hierarchy Flattening Transform Features.
  • New Functions- Cryptographic, gen_UUID, BLOB, Copy Query.

SAP Extraction

  • SAP Business Content Extractors i.e. Data Sources extraction from ERP.
  • SAP SLD & SMD Integration.

Other Features

  • New Operational Features-Designer GUI Keyboard accessibility, Multi-Language support.
  • Source & Target additional properties.
  • Migration Techniques.

About SAP BODS Online Training @ BigClasses

BigClasses is one of the best online training organizations offer SAP BODS training. We have qualified and experienced faculties who are responsible for taking the online sessions. We provide study materials and 24 hours support to our national and international learners as well. If you are interested in SAP BODS online training, contact us for the detailed course and the free demo classes.

India: +91-8008114040, USA: +1-7323251626
Website:, Email: