SAP BODS Training

SAP BODS Online Training

Introduction

  • What is Data Warehouse
  • Data Warehouse Functions & Implementation
  • Data Warehouse Products & Venders
  • About SAP’s Data warehouse-SAP BW
  • SAP BW functions, Benefits & Limitations
  • About Business Objects & their Products
  • Why SAP Acquired Business Objects

SAP Data Services 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 & Upgradation
  • 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 Config
  • 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 Handling

  • 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, and 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 Upgradation
  • 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)

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message