SAP BODS Training in Chennai
Course Content
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 SAP / SAP BI
Integration
- SAP BODS User & Role creation
in SAP
Data
Services – SAP SAP Extraction
- SAP SAP – Data Flow, Interfaces,
and Objects allowed to BODS
- Creating SAP Application Datastore
– Properties
- SAP SAP – Tables & Hierarchies
Data Extraction
- SAP SAP – Getting RFC enabled
Functions Modules
- SAP SAP – IDOC Data Extraction
& IDOC Data Loading
- SAP SAP – 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
SAP BODS Related Training Courses in Chennai
