SAP BODS 4 2 Training
SAP BODS 4.2 Training
SAP BODS 4.2 TRAINING
COURSE DETAILS & CURRICULUM
Lesson 1: BODS overview
· Overview of SAP Data services
· Data services benefits, associated products, interfaces
· Data services Architecture on single and distributed environment
Lesson 2: BODS Designer concepts
· Creating the repository (Local, Central repository)
· Exploring the menu options in the Designer
· Creating the Project, Job flow, Data flow, Work flows etc.
· Defining different types of Data stores (Source and destination data stores)
· Use data store and system configurations
· Defining file formats for flat, Excel, XML files
Lesson 3: Batch Jobs
· Creating Batch Jobs
· Work with objects
· Create a data flow
· Adding the Query transform to the data flow
· Use target tables
· Execute the job
Lesson 4: Defining Data Integrator Transforms
· Date Generation Transform
· Pivot Transform
· Reverse Pivot Transform
· XML_Pipeline Transform
Lesson 5: Defining Data Platform Transforms
· Query Transform
· Case Transform
· Merge Transform
· Validation Transform
· Row Generation Transform
· SQL Transform
Lesson 6: Defining Data Quality Transform
· Address Cleanse
· Geocoder
Lesson 7: Implementation of SCD
· SCD Type0
a) Query Transform
- SCD Type1
a) Table Comparison Transform
b) Map_Operation Transform· SCD Type2
a) Table Comparison Transform
b) History Preserving Transform
c) Key Generation Transform
Lesson 8: Using Functions, Scripts, and Variables
· Define built-in functions
· Use functions in expressions
· Use variables and parameters
· Create Custom functions
· Use Data Services scripting language
Lesson 9: Data assessment
· Using the data profiler
· Using the validation transform
Lesson 10: Setting up Error Handling
· Set up recoverable work flows
Leson 11: Setting up Exception Handling
· Try/Catch Techniques
Lesson 12: IF Conditional
Lesson 13: While-Loop Implementation
Lesson 14: Capturing Changes in Data
Lesson 15: Data assessment
· Update data over time
· Use source-based CDC
· Use target-based CDC
a) SCD Type 2
Lesson 16: Multi-User Environment (Local Repo vs. Central Repo)
Lesson 17: SAP Integration
· Data extraction from ECC system to File, Table and SAP BI
· Data extraction from ECC Extractors
· Data Extraction from SAP BW
· ABAP Workflows
Lesson 18: SAP HANA and SAP BODS Integration
· Introduction to SAP HANA
· Introduction to SAP HANA Studio
· Create Data Store for SAP HANA
· Perform the load into SAP HANA
· Store the data in Column Store
· Preview the data in SQL console of SAP HANA Studio
Lesson 19: Information Steward
· Data Insight
· Metadata management
· Metapedia
