SAP BODS Course Overview:

ETL stands for Extract-Transform-Load, and it is a process of how data is loaded from the target system to the data warehouse. Data is extracted from a database and transformed to match according to the data warehouse schema. After that, it is loaded back to the data warehouse database in the form of dimension and fact tables.SAP BODS is an ETL tool by SAP which can extract data from disparate systems, transform them into meaningful information and load them in various kinds of systems.Full form of SAP BODS is Business Objects Data Services. It is designed to deliver an enterprise-class solution for data integration, data quality, data processing, data profiling, and text data.

Target Students: Must be aware with ETL Tools basic concepts of SAP ERP

Training Overview

Unit 1: Defining Data Services

  • Defining Data Services

Unit 2: Defining Source and Target Metadata

  • Defining Datastores in Data Services
  • Defining Data Services System Configurations
  • Defining a Data Services Flat File Format
  • Defining Datastore Excel File Formats

Unit 3: Creating Batch Jobs

  • Creating Batch Jobs

Unit 4: Troubleshooting Batch Jobs

  • Setting Traces and Adding Annotations
  • Using the Interactive Debugger
  • Setting up and Using the Auditing Feature

Unit 5: Using Functions, Scripts and Variables

  • Using Built-In Functions
  • Using Variables, Parameters and Scripts

Unit 6: Using Platform Transforms

  • Using Platform Transforms
  • Using the Map Operation Transform
  • Using the Validation Transform
  • Using the Merge Transform
  • Using the Case Transform
  • Using the SQL Transform

Unit 7: Setting Up Error Handling

  • Setting Up Error Handling

Unit 8: Capturing Changes in Data

  • Capturing Changes in Data
  • Using Source-Based Change Data Capture (CDC)
  • Using Target-Based Change Data Capture (CDC)

Unit 9: Using Text Data Processing

  • Using the Entity Extraction Transform

Unit 10: Using Data Services (Integrator) Platform Transforms

  • Using Data Services (Integrator) Platform Transforms
  • Using the Pivot Transform

Using the Data Transfer Transform and Performance Optimization

Course Duration: 35 – 40 hrs
Timing Week Days: 1 hrs per day (OR) 3 Times a week or Weekends: 3 hrs per day
Method: Instructor led, with exercises.
Breaks: As Required, but limited to 2 of 10 min. In weekend batch
Email ID
Study Material SAP BODS Online Training
Phone +91 9356913849
Fees Structure 50% After introduction lectures balance  After 50% Lecture
Server access Throughout the course 24/7
Timings Flexible