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)
|
