SAP BODS 4.2

SAP BODS 4.2 Accounting Training ✔40 Hrs ✓Hands on Assignments ✓Project Based Scenario ✓10+ yrs exp Trainer ✓Recorded Sessions ✔Lifetime access to Course Material

$850.00

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.

Pre-Requisites:

  • 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

Duartion: 40 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.

Conditional.

  • 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
  • MAP_CDC_OPERATION
  • 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

Course Assignments

News forum

Activity 1

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

Sales_org

SQLScript for Source Tables

SQL Script for Target Tables

Material Table - XML

Material - DTD

Product FAQ