SAP BODS Online Training Course Content
Duration: 4-5 Weeks
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 Transforms
- Text 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