SAP BODS

SAP BODS Training 

Introduction:

It is an ETL tool currently acquired by SAP used for integration with all types of disparate systems, extracting data from them, transforming them into meaningful information and loading them into all types of systems.

It is tightly integrated with SAP systems and hence really a good tool to migrate data from legacy systems to SAP systems with ease and less development efforts with effective debugging and monitoring capabilities.

Course Description :

Introduction 

  • What is a Data Warehouse?
  • Data Warehouse Functions & Implementation
  • Data Warehouse Products & Vendors
  • About SAP & their Products
  • SAP’s Data Warehouse product – SAP BW
  • SAP BW functions, Benefits & Limitations
  • About BusinessObjects & their Products
  • Why SAP Acquired BusinessObjects
  • Data Centric Vs Process Centric DWH system
  • BusinessObjects Vs SAP BOBJ
  • SAP BOBJ Product Portfolio – BI, EIM, EPM, GRC, AA

SAP BOBJ Data Services Overview

  • About Data Services – Introduction & BI Platform
  • Functions – Data Integration & Data Management
  • Data Services Product Evolution (ATL, DI & DQ)
  • Architecture – by Components
  • Installation of Data Services on Windows
  • Data Services Tools & its functions
  • Data Services Objects & Object 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, Data Package
  • Repository Creation & Upgradation
  • Server Manager – Job Server (JS) & Access Server (AS)
  • JS & AS Creation, Job Server-Repository Assignment
  • Metadata Integrator – Sharing the BODS Metadata to BOXI
  • License Manager – Adding or Upgrading the Keys
  • Management Console – Introduction & Components
  • Data Service Designer – Introduction & GUI 
  • Getting Start with Designer to develop First ETL Flow

Datastore & Formats

  • Datastore – Overview & Types
  • Datastore creation – DB, SAP, Adaptor, Web Service
  • Formats – Flat file, Excel, DTD, XSD, COBOL Copybooks
  • Data Extraction from Database Tables
  • Data Extraction from Excel Workbook – Multiple Sheets
  • Data Extraction from Flat file (CSV, Notepad, and SAP Transport)
  • Data Extraction from XML File (DTD, XSD)
  • Data Extraction from COBOL Copybooks
  • Data Distribution to Flat File & XML
  • Dynamic Extraction – File Selection & Sheet Selection

Data Services – Transforms 

  • Transforms & Category (DI, DQ, PF)
  • Data Integrator – Data_Transfer Transform, Date_Generation Transform 
  • Data Integrator – Effective_Date, Hierarchy_Flattening
  • Data Integrator – History_Preserving, Key_Generation
  • Data Integrator – Map_CDC_Operation, Table_Comparision
  • Data Integrator – Pivot, Reverse_Pivot, XML_Pipeline
  • Platform – Case, Map_Operation, Merge, Query
  • Platform – SQL, Validation, Custom ABAP Transform
  • Text Analysis – Introduction & TDP vs. TA
  • Text Analysis – Base Entity Extraction Transform
  • Text Analysis – Unstructured Data Extraction, Dictionaries & Rules and Language Modules

Data Services – Advance Level

  • BODS Admin Console – Administration, Auto Reporting
  • Real time Jobs, Embedded Data Flows & Security
  • Variables, Parameters, Substitution Parameters, System Config
  • Debugging, Recovery Mechanism
  • Data Assessment – Data Profiling
  • BODS Performance Tuning Techniques
  • Multi-User Development Environment – Into & Advantages
  • Multi-User Environment – Implementation & Migration 

Data Services – SAP Extraction Introduction

  • SAP Systems – Into, SAP Systems allowed, Terminology
  • SAP BODS and SAP ERP / SAP BI Integration
  • SAP BODS User & Role creation in SAP

Data Services – SAP ERP Extraction

  • SAP ERP – Data Flow, Interfaces, and Objects allowed to BODS
  • Creating SAP Application Datastore – Properties
  • SAP ERP – Tables & Hierarchies Data Extraction
  • SAP ERP – Getting RFC enabled Functions Modules
  • SAP ERP – IDOC Data Extraction & IDOC Data Loading
  • SAP ERP – Extracting Flat file data from SAP APP Server

Data Services – SAP BW/BI Extraction & Loading

  • SAP BW – Data Flow, Interfaces, and Objects allowed to BODS
  • Creating SAP BW Source & SAP BW Target Datastores
  • SAP BW – Extracting Data from SAP BW InfoProviders – OHD
  • SAP BW – Extracting Data from SAP BW bases tables – /BIC/
  • SAP BW – Loading data to SAP BW InfoProviders (MD & TD)
  • SAP BW – BW Jobs Execution

Data Services – SAP Advanced Concepts

  • SAP BusinessObjects Rapid Marts– Introduction & Overview and differences between 3.x and 4.x
  • SAP BusinessObjects Extractors Extraction– Introduction of ODP, SAP DataSources Extraction, SAP Delta Mechanism and DOP Queue
  • SAP Data Migration with BODS– Data Migration Techniques, BODS Data Migration to SAP, Data Migration Tool Introduction and Overview

 

 

Comments are closed