SAP BODS — Course Content

Share on FacebookShare on LinkedInTweet about this on TwitterGoogle+

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