SAP BODS
SAP BODS Course Content
INTRODUCTION
- 1. Overview of ERP
- 2. Overview of DW
- 3. Overview of ETL
- 4. Overview of SAP BODS (SAP DS)
SAP BODS (SAP DS)
- 1. SAP Data Services Designer
- 2. Data Services Objects in Designer
- 3. SAP BODS Architecture and its Components
SAP BODS System Setup
- 1. Database Creation
- 2. Repository Creation(Local, Central, Profiler)
- 3. Repository Registration in CMC
- 4. Job Server Creation
SAP BODS Metadata Reporting Tool and its Modules
- 1. Data Services Management Console(DSMC)
- a. Administrator
- b. Auto Documentation
- c. Data Validation
- d. Impact and Lineage Analysis
- e. Operational Dashboard
- f. Data Quality Reports
SAP BODS Datastores
- 1. Database Datastores(MS Sql Server ; SAP HANA)
- 2. Application Datastores(SAP ECC)
- 3. Memory/ Linked/Adapter Datastores
SAP BODS File Format
- 1. Extraction of Data from Flat File(CSV; TXT)
- 2. Extraction of Data from Excel Workbook
- 3. Extraction of Data from XML file
Data Flow and Work Flow
- 1. Creation of Work Flow
- 2. Creation of Data Flow
- 3. Replication of Data Flow
- 4. Nested Data Flow
Batch Job Creation and Execution
- 1. Manual Execution
- 2. Execution through Scheduling
- 3. Execution Properties
Troubleshooting, Debugging and Exception Handling
- 1. Interactive Debugging
- 2. Filter Option
- 3. Validating and Tracing Jobs
- 4. Auditing
Functions, Scripts, Variables
- 1. Built-In Functions(lookup_ext()
- 2. Aggregate Functions
- 3. Creation of custom Functions
- 4. Use of Variables, Parameters, Scripts
SAP BODS Platform Transform
- 1. Case
- 2. Merge
- 3. Validation
- 4. SQL
- 5. Map_Operation
- 6. Row_Generation
- 7. XML_Map
SAP BODS Data Integrator Transform
- 1. Data Transfer
- 2. Date_Generation
- 3. Effective_Date
- 4. Hierarchy_Flattening
- 5. History_Preserving
- 6. Key_Generation
- 7. Pivot
- 8. Reverse_Pivot
- 9. Table_Comparison
- 10. XML_Pipeline
SAP BODS Data Quality Transform
- 1. Global_Address_Cleanse
- 2. Data Cleanse
- 3. Match
Changes in Data(CDC)
- 1. Source-Based Changed Data Capture(SCDC)
- 2. Target-Based Changed Data Capture(TCDC)
SAP BODS Recovery Mechanism
- 1. Recovery Mechanism
- 2. Describing Levels of Data Recovery Strategies
- 3. Recovery Units
- 4. Recovery Mode
- 5. Automatic Recovery
SAP BODS Multi-User Environment
- 1. Central Repository
- 2. Check-In and Check-Out from Central Repository
- 3. Exporting Repository
- 4. Exporting Selected Objects
SAP BODS Performance Optimization
- 1. Distributed Data Flow Execution
- 2. Full Push Down/ Partial Push Down/No Push Down
- 3. Performance Optimization Parameters
