SAP BODS Online Training

SAP BODS Online Training


    SAP BODS Course Content :

    1. DW Concepts

    • Definition
    • Methodologies
    • Dimensional Modeling
    • DW Lifecycle
    • DW Challenges

    2. ETL Overview

    • ETL introduction
    • Staging Area
    • Business Rules
    • Performance
    • Slowly Changing Dimensions
    • Surrogate Keys
    • Facts and Dimension Tables
    • Different ETL Tools

    3. Business Objects Overview

    • History
    • Components
    • Architecture

    4. Data Services

    • Purpose of Data Services
    • Data Services architecture
    • Define Data Services objectsData Services Designer interface

    5. Data Services Objects

    • Object Hierarchy
    • Workflows
    • Data Flows

    6. Source and Target Metadata

    • Data Stores
    • File formats for flat files
    • File formats for Excel files
    • File formats for XML files
    • Lab Exercises

    7. Environment setup

    • Creating repository
    • Setting Job Server
    • Setup for realtime operation
    • Setting multiple datastores
    • Starting Job servers
    • Lab Exercises

    8. Batch Jobs

    • Work with objects
    • Create a data flow
    • Use the Query transform
    • Use target tables
    • Execute the job
    • Lab Exercises

    9. Troubleshooting Jobs

    • Use descriptions and annotations
    • Validate and tracing jobs
    • Use View Data and the Interactive Debugger
    • Use auditing in data flows
    • Lab Exercises

    10.Functions, Scripts and Variables

    • Define built-in functions
    • Functions in expressions
    • Lookup functionDecode function
    • Variables and parameters
    • Data Services scripting language
    • Scripting custom functions
    • Lab Exercises

    11. Important Transforms

    • Map Operation transform
    • Validation transform
    • Merge transform
    • Case transform
    • SQL transform
    • Lab Exercises

    12. Other Transforms

    • Pivot transform
    • Hierarchy Flattening transform
    • Data Transfer transform
    • XML Pipeline transform
    • Lab Exercises

    13. Error Handling

    • Error Handling
    • Recoverable work flows

    14. Change Data Capture

    • Update data over time
    • Database native CDC mechanisms
    • Source-based CDC
    • Target Comparison
    • Lab Exercises

    15. Data quality Overview

    • Fundamentals of DQ and Data Cleansing
    • Built in DQ Transformations
    • Data Validation
    • Name & Address cleansing
    • De duplication
    • Cleansing other data
    • Lab Exercises
    • Web-Services and Real-Time IntegrationReal Time Jobs
    • SOAP Introduction
    • Web Services

    16. SAP Integration

    • Creating datastores for SAP databases
    • Accessing SAP data
    • Running ABAP programs
    • R/3 Data flows

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 1 month, 1 week

    Drop us a query

    Job Support

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies


    This web site or team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. All SAP Systems operate under INITIAL evaluation license. All trademarks mentioned on this web site belongs to their owners. We do not share or distribute ANY personal information we collect on this web site. For any additional information


    +91 9989754807