SAP BODS/Data Services/Data Integrator Online Training

Share on FacebookShare on LinkedInTweet about this on TwitterGoogle+


BODS (Business Objects data Services) is a graphical user interface space that enables to make jobs that extracts information from heterogeneous sources, transforms that information exploitation inbuilt transforms and functions to fulfil business needs so loads a single data store or data warehouse for additional analysis.

Business Objects data Services (BODS)may be a complicated platform for the data integration method and constitutes the most recent version of Business Objects application.

In comparison with previous versions of BO ETL (Business Objects data Integrator), a data Quality module is that the integral part of data Services.

Course Highlights:

Real Time Scenarios with advanced examples

Real Time Environment Explanation

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

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, work flow, 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 work flow
  • 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 datastore
  • Work with projects in the central repository
  • Create a secure central repository
  • Implement and modify group permissions




Data Services Advance Level cont.… 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



Dataservices 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

For more details about the course please Click Here is an ISO certified online training company providing SAP BASIS Online Training by real time experts.
 A very good Job oriented SAP BASIS Training to you by the industry Expert.

Smart way to learn on internet,