Course Description

SAP Data Services delivers a single enterprise-class solution for data integration, data quality, data profiling, and text data processing that allows you to integrate, transform, improve, and deliver trusted data to critical business processes.


  • Knowledge of data warehousing and ETL concept
  • Experience with SQL language
  • Data Warehouse Fundamentals
  • Data Warehouse Architecture and Modeling
  • Basics of SQL, Database & Data Warehouse

Duartion40 hours

Mode of Training:  Live instructor –led hands on training

Course Contents

  • What is ERP in Data warehousing.
  • Architecture of Data warehousing.
  • OLTP vs OLAP.
  • Schemas in Data warehousing.

  • SAP DS Modules
  • SAP DS Versions
  • SAP DS Landscape
  • SAP DS Architecture
  • SAP DS Services
  • SAP DS ETL Flow
  • SAP DS vs SAP BW
  • SAP DS vs Other ETL Tools
  • SAP DS with HANA DB
  • SAP DS with BO
  • SAP DS with SAP ERP
  • SAP DS ServicesSAP DS Project overview

  • Create Data stores in DS
  • Connect to SQL Server DB and HANA
  • Copying data from SQL Server DB to HANA with Data services
  • Connecting to SAP HANA
  • Importing a flat file
  • Importing an XML file
  • Importing an Excel worksheet
  • Importing XSD schemas
  • Importing from SQL Server using ODBC
  • Importing from COBOL Copybook
  • Importing SAP ECC using Template Tables

  • Transforms & Category (DI,PF,DQ)
  •  Data Integrator – Date Generation
  •  Data Integrator – Pivot
  •  Data Integrator – Reserve_Pivot
  •  Data Integrator – Effective_Data
  •  Data Integrator – Hierarchy_Flatterning
  •  Data Integrator – Data Transfer
  •  Data Integrator – XML_Pipeline
  •  Data-Integrator – History _Preserving
  •  Data-Integrator – Key _Generation
  •  Platform – Case
  •  Platform – Map_Operation
  •  Platform – Merge
  •  Platform – Query
  •  Platform – SQL
  •  Platform – Validation
  •  Data Quality – Country2IDChar
  •  Data Quality – GeoCoder
  •  Data Quality – Global Address Cleanse
  •  Data Quality – Data Cleanse
  •  Data Quality – Match

  •  BODS Admin Console-Administration
  •  Real time Jobs, Embedded Data Flows
  •  Substitution Parameters
  •  Debugging Usage
  •  System Configuration
  •  BODS Performance Tuning Techniques

Error handling.

  •  Try/Catch Techniques.


  •  Implementation of if-else scenario.
  •  Data Assessment.

Recovery Mechanisms

  •  Job as recovery unit
  •  Workflow as a recovery unit
  • Dataflow as a recovery unit

Variables and Parameters

  •  Global Variables
  •  Local Variables
  •  Parameters and it’s types
  •  Built-in and Custom functions

Data Assessment

  •  Data Assessment using Data Profiler
  •  Prerequisites to perform the Data Profiling
  •  Types of Data Profiling
  •  Importance of validation transform with Data Profiling

Multi-user Development and Environment setup

  •  Defining Central repository
  •  Difference between Central and Local repository
  •  Difference between Secured and Non secure central repository
  •  Activation of Central repository from local repository
  •  Checking in, Checking out, Getting, Filtering,Checking,Labeling objects from central repository

Migrating Multi-User Jobs

  •  Copying contents b/w Central repositories
  •  Central repository migration

  •  Steps to integrate SAP BW and Data Services
  •  Defining an SAP NetWeaver BW Source data store
  •  Defining an SAP Net Weaver BW Target data store
  •  Steps to Integrate SAP ECC and Data Services
  •  Process involved in the data extraction b/w SAP ECC and BODS
  •  Creation of SAP Application Data store
  •  SAP Tables & Hierarchies Data Extraction
  •  Reading data from SAP Extractors
  •  Reading data from SAP NetWeaver BW
  •  Setting up the RFC Server interface in BODS Management console
  •  Reading the Info Provider through SAP Open Hub Service
  •  Creating and running a job to read an Open Hub table
  •  Loading into SAP Net Weaver BW 

  •  SCD Type1
  •  SCD Type2
  •  SCD Type3


  • Creating  repository(Local,Central)
  • Exploring the menu options in designer
  • Creating Project, jobflow, data flow, Workflow etc

  • Create Batch job
  • Work with Objects
  • Create data flow
  • Adding Query transform to data flow
  • Using Target tables
  • Execute the jobs



int(18) int(0) array(3) { ["status"]=> bool(false) ["debug"]=> string(28) "{"course_id":18,"user_id":0}" ["warnings"]=> array(0) { } }

Course Assignments

News forum

Activity 1

SAP Data Services Project Version: 4.2 Support Package 3 ( - 2014-09-02


SQLScript for Source Tables

SQL Script for Target Tables

Material Table - XML

Material - DTD

Comments are closed.