SAP BODS Introduction

• BODS Overview - What & Why?
• BODS Product Evolution
• BODS Component Architecture
• BODS Components and their functionalities
• BODS Objects Hierarchy and their functionalities

SAP BODS - Foundations

• Creating a simple job
• Configuring Datastores - Types
• Defining File formats - Types
• Extracting data from different file sources and database tables
• Loading data to database tables and flat files
• Naming Conventions of Objects
• Monitor, Trace and Error logs

SAP BODS – Transformations

Data Integrator Transformations

• Data Transfer
• Date generation
• Effective Date
• Pivot
• Reverse Pivot
• Table Comparison
• History Preserving
• Key generation
• XML Pipeline
• Hierarchy Flattening
• Map CDC Operation

Platform Transformations

• Query
• Case
• Validation
• Merge
• Row-generation
• Map operation
• SQL
• XML Map

Text Data Processing Transformation

• Basic Entity Extraction
• Entity Extraction - using dictionaries and rules

SAP BODS - Advanced topics

• Inbuilt Functions
• Variables

Controlling Objects

• While loop
• Conditional flow
• Try & Catch - Exceptional errors handling

• Scripts & Annotations
• Custom Functions
• Recovery Mechanism
• Debugging
• Embedded Dataflow
• Auditing
• Source and Target CDC techniques
• SCD Implementations
• Real Time Jobs

SAP BODS - Project Deployment

• BODS Landscape
• Substitution Parameter, Datastore and System Configurations
• Deploying Repository content

SAP BODS - Multi User Environment

• Central Repository Configurations
• Code Migration using Check in and Check out Mechanism
• Code Migration using .atl file/ .xml file.

SAP BODS - Management Console

• Administration
• Job Scheduling&Monitoring
• Auto Documentation
• Auto Reporting

SAP BODS - Data Profiling

• Profiler server Configuration
• Data Profiling - using BODS Designer
• Data Profiling - using SAP BO Information Steward

SAP BODS - ECC (ERP)

SAP ECC Extraction

• SAP BODS and SAP ECC Integration
• SAP Applications Datastore Configuration
• Importing of SAP ECC tables
• Using SAP ECC table as source - Direct Method
• Using SAP ECC table as source - using ABAP Dataflow

SAP ECC Loading

• SAP Rapid Data Migration - using AIO jobs and Idocs
• Introduction to AIO jobs
• Prerequisite jobs in Data migration
• Datastore Configuration
• Mapping, Validation and Enrichment
• Data Loading to Idoc

SAP BODS - BW

SAP BW Extraction

• SAP BW Source Datastore Configuration
• Import of Infoobjects - Master Data
• Import of Infocubes and DSO's - Transaction Data
• Using SAP BW tables as source and loading the data into data base tables
• Extraction using Open Hub Destinations

SAP BW Loading

• SAP BW Target Datastore Configuration
• Configuring of Data Services Source System in SAP BW
• Configuring of RFC Interface in Data Services Management Console
• Import Infosources and loading the data into SAP BW
• Execution of Job in Data Services
• Execution of Data Services Job in SAP BW