SAP BODS

SAP BUSINESS OBJECTS DATA SERVICES & RAPIT MARTS COURSE CURRICULUM

 

  • Introduction
  • What is Data Warehouse
  • Data Warehouse Functions & Implementation
  • Data Warehouse Products & Venders
  • About SAP’s Data ware House-SAP BW
  • SAP BW functions, Benefits & Limitations
  • About Business Objects & their Products
  • Why SAP Acquired Business Objects
  • Data Centric Vs Process Centric DWH system.
  • SAP BO Data Service Overview
  • About Data Services – Introduction
  • Functions – Data Integration & Data Management
  • Data Services Product Evolution(ATL, DI & DQ)
  • Architecture – by Components
  • Data Services Tools & its functions
  • Data Services Objects & Objects Hierarchy
  • BODS Objects Naming standards
  • BODS Objects comparison with SAP BW Objects
  • Data Services – Basic Level:
  • Repository Manager-BODS Repository
  • Repository Types- Local, Central, Profile
  • Repository Creation & Up gradation
  • Server Manager-Job Server(JS) & Access Server(AS)
  • JS & AS Creation, Job Server-Repository Assignment
  • Management Console – Introduction & Components
  • Data Service Designer – Introduction & GUI
  • Getting Started with Designer to Develop First ETL Flow
  • Data store & Formats
  • Data store-Overview & Types
  • Data store Creation – DB,SAP, Adopter, Web Service
  • Formats – Flat files, Excel, DTD, XSD, COBAL Copybooks
  • Data Extraction from Database Tables
  • Data Extraction from Excel Workbook – Multiple Sheets
  • Data Extraction from Flat files ( CSV, Notepad, SAP Transport)
  • Data Extraction from XML File ( DTD, XSD)
  • Data Extraction from COBOL Copybooks
  • Data Distribution to Flat File & XML
  • Dynamic Extraction – Files Selection & Sheet Selection
  • Data Services-Transforms
  • Transforms & Categories (DI, DQ, PF)
  • Data Integration – Data _Transfer, Date _Generation
  • Data Integration – Effective _Date, Hierarchy _Flattening
  • Data Integration – History _Preserving, Key _Generation
  • Data Integration – Pivot, Reverse _Pivot, XML _Pipeline
  • Platform – Case, Map _Operation, Merge, Query
  • Platform – SQL, Validation Custom ABAP Transform
  • Data Services-Advance Level
  • BODS Admin Console – Administration, Auto Reporting.
  • Real time Jobs, Embedded Data Flows Variables, Parameters,
  • Substitution Parameters, System Configuration
  • Debugging, Recovery Mechanism
  • Data Assessment – Data Profiling
  • BODS Performance Tuning Techniques
  • Multi-User Development Environment – Intro & Advantages
  • Multi-User Environment Implementation & Migration
  • BODS Object Migration Techniques
  • Data Services-SAP Systems Handing
  • SAP System – Intro, SAP System allowed, Terminology
  • SAP BODS and SAP ERP / SAP BI Integration
  • SAP BODS User & Role creation in SAP
  • SAP ERP – Data Flow, Interfaces, Objects allowed to BODS
  • Creation SAP Application Data store – Properties
  • SAP ERP – Tables & Hierarchies Data Extraction
  • SAP ERP – Getting RFC enabled Functions Modules
  • SAP ERP – IDOC Data Extraction & IDOC Data Loading
  • SAP ERP – Extraction Flat file data from SAP APP Server
  • SAP BW – Data flow, interfaces, Objects allowed to BODS
  • Creating SAP BW Source and SAP BW Target Data stores
  • SAP BW – Extracting Data from
  • SAP BW info providers – OHD
  • SAP BW – Extracting Data from SAP BW Bases tables-/BIC/
  • SAP BW – Loading Data to SAP BW info providers(MD & TD)
  • SAP BW – BW Jobs Execution
  • SAP BOBJ RAPID MARTS:
  • Rapid Marts – Introduction, Advantages, Limitations
  • Total Rapid Marts SAP offering, Rapid Marts for SAP Solution
  • Rapid Marts – Versions, Dataflow, Content
  • Why and Whom to go for Rapid Marts implementation?
  • Rapid Marts implementation Out of Box:
    • Environment Checklist
    • Recommend for Up gradation
    • Environment setup ( Pre installation phase)
    • Installation of RM(Data Model, ETL, Visuals)
    • Configuration of RM ( ETL, Visuals)
    • RM File and Custom ABAP Transform Maintenance
    • Rapid Mart directory Maintenance
  • Rapid Marts Testing – Sample Data Loads, Testing Reports
  • Rapid Marts Recovery Mechanism – For Delta Loads
  • Rapid Marts implementation – Customization (as per Req.)
    • Data Model Customization
    • ETL Customization
    • Visuals Customization
  • Rapid Marts Performance Tuning Techniques (Standard)

Course Video

The Course Videos Section.

Course Overview

The Course Overview Section.