SAP BODS

SAP BODS Training 

Course Description

Introductions and Course Overview

• OLAP and OLTP
• Data ware housing concepts
• SQL concepts

Describing Data Services

• Describing the purpose of Data Services
• Describing Data Services architecture
• Defining Data Services objects
• Using the Data Services Designer interface

Defining Source and Target Metadata

• Using data stores
• Using data store and system configurations
• Defining file formats for flat files
• Defining file formats for Excel files
• Defining file formats for XML files

Creating Batch Jobs

• Working with objects
• Creating a data flow
• Using the Query transform
• Using target tables
• Executing the job

Troubleshooting Batch Jobs

Using descriptions and annotations

• Validating and tracing jobs
• Using View Data and the Interactive Debugger
• Setting up auditing

Using Functions, Scripts, and Variables

• Defining built-in functions
• Using functions in expressions
• Using the lookup function
• Using the decode function
• Using scripts, variables, and parameters
• Using Data Services scripting language
• Scripting a custom function

Using Platform Transforms

• Describing platform transforms
• Using the Map Operation transform
• Using the Validation transform
• Using the Merge transform
• Using the Case transform
• Using the SQL transform

Capturing Changes in Data

• Updating data over time
• Using source-based CDC
• Using target-based CDC Including SCD Type0,SCD Type1,SCD Type2

Using Data Integrator Transforms

• Describing Data Integrator transforms
• Using the Pivot transform
• Using the Hierarchy Flattening transform
• Describing performance optimization
• Using the Data Transfer transform
• Using the XML Pipeline transform

SAP BW AND R3 in BODS

• Creating SAP R3 Data Store and Extractions
• Creating SAP BW Source and BW Target data store and Extractions