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

Lesson 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