SAP BODS

SAP BODS COURSE CONTENT

Introduction

What is a data warehouse?
Data warehouse Concepts
Data warehouse Products
About SAP and their products
History of Business objects and their Products

SAP BO Data Services

About Data services -Introduction
Data services Product Evolution
Architecture of Data Services
Components of Data Services
Components of Designer
Data services objects and object hierarchy
Repository
Types of Repository
Creation of Repository and assignment of repository
Job Server & Access Server
Metadata Integrator – sharing the BODS Metadata to BOXI
License Manager-Adding or upgrading the keys

Formats: Different types of Formats

Flat file
DTD files
XML Schemas
Excel Workbooks
Data loading using Flat file as a source and target. Data loading using XML file as source
Data loading using Excel Workbooks as source
Dynamic Extraction – File Selection & Sheet Selection
Loading multiple files

Data stores: Different types of data stores

Database (SQL Server)
SAP ECC Application
SAP BI Application
Web Service
Adapter
Data loading using SQL Server as source and flat file as target
Data loading using SQL Server as source and SQL Server as target
Data loading using SAP ECC as source and SAP BI as target
Data loading using SAP ECC as source
Tables
SAP ECC/BI extractors
Data loading using SAP BI as Source
BI Tables
OHD (Open Hub destination)
If & While Loop
Trace, Catch, Script, Annotation Transforms:
Data Integrator Transforms
Platform Transforms
Data Quality TransformsText analysis -Introduction TDP Vs TA
Text analysis-Base Entity Extraction Transform

Advanced Topics

Delta extraction from SQL Server(Change Data Capture)
Delta extraction from SAP ECC(Change Data Capture)
Slowly Changing Dimension1
Slowly Changing Dimension2
Slowly Changing Dimension3
BODS Administrator
Real time jobs
Embedded Data flows
Variables
Parameters, Functions, Custom Functions
Debugging, Recovery mechanism
Data assessment -Data Profiling
BODS Performance Tuning Techniques
Multi-User Development Environment
Real Time Scenarios
Interview Questions
CV Preparation