Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SAP Data Services (BODS)| Scratch to Advance
Rating: 4.5 out of 5(199 ratings)
536 students

SAP Data Services (BODS)| Scratch to Advance

Transforms| Data Migration to ECC & S/4 HANA| Connect BODS to AWS| Error Handle | BODS Management Console|Code Migration
Created byRajan B
Last updated 7/2020
English

What you'll learn

  • Students will learn BODS from scratch to Advanced level
  • Students will learn how to connect BODS with Data sources and different file formats
  • Students will learn the data migration to ECC system using IDOCs and BAPIs
  • Students will learn the data migration to S/4 HANA system using IDOCs and BAPIs
  • Students will learn how to connect BODS with AWS S3

Course content

1 section55 lectures6h 7m total length
  • Course Preview of SAP Data Services (BODS)3:00
  • SAP BODS: Briefing of topics covered6:15

    This lecture covers all the topics in brief that are covered throughout the course

  • SAP BODS: Create First Batch Job10:46
  • QUIZ-1
  • SAP BODS: Connection to File Format8:18

    This tutorial explains how to connect Flat files with Data Services

  • SAP BODS: Process Multiple Files in single job6:55

    This tutorial explains how to process multiple files present on shared directory in single job

  • SAP BODS: Using Adaptable Feature in File Formats4:31

    This tutorial explains how to handle issues when source structure is improper.

  • SAP BODS: File Format As Target8:07

    This tutorial explains how to create file format as Target

  • SAP BODS: Working with Excel workbooks7:20

    This tutorial explains how to work with Excel Workbooks

  • SAP BODS: Working with XML files4:30

    This tutorial explains how to work with XML files

  • QUIZ-2
  • SAP BODS: Case Transform I6:30

    This video explains how case transform works in BODS

  • SAP BODS: Case Transform II4:48

    This tutorial explains Preserve Expression order concept of Case Transform

  • QUIZ-3
  • SAP BODS: Merge Transform11:01

    This tutorial explains concept of Merge Transform

  • SAP BODS: Validation Transform10:44

    This tutorial explains concept of Validation Transform

  • QUIZ-4
  • SAP BODS: Pivot Transform7:07

    This tutorial explains concept of Pivot Transform

  • SAP BODS: Reverse Pivot Transform7:48

    This tutorial explains concept of Reverse Pivot Transform

  • QUIZ-5
  • SAP BODS: Row Generation Transform2:57

    This tutorial explains concept of Row Generation Transform

  • SAP BODS: Date Generation Transform4:26

    This tutorial explains concept of Date Generation Transform

  • SAP BODS: SQL Transform5:24

    This tutorial explains concept of SQL Transform

  • QUIZ-7
  • SAP BODS: Table Comparison Basics11:06

    This tutorial explains basics of Table Comparison Transform

  • SAP BODS: Compare Columns in Table Comparison3:24

    This tutorial explains compare columns in Table Compare Transform

  • SAP BODS: Input Contains Duplicates in Table Comparison4:20

    This tutorial explains how table comparison transform deals with duplicate values present in source.

  • SAP BODS: Key Generation Transform in Conjunction with Table Comparison5:57

    This tutorial explains the purpose of Key Generation Transform in BODS

  • SAP BODS: Generated Key Column in Table Comparison6:57

    This tutorial explains how duplicate values in target system is handled by Table Comparison Transform

  • SAP BODS: History Preserving with Table Comparison14:56

    This tutorial explains the purpose of History Preserving Transform. This tutorial is complete solution of implementing SCD Type-2

  • SAP BODS: Map Operation7:01

    This tutorial explains how using Map Operation Transform source data can be manipulated

  • QUIZ-7
  • SAP BODS: Joins8:25

    This tutorial explains the concept of joins in BODS

  • SAP BODS: Lookup Function10:45

    This tutorial explains the concept of lookup function in BODS

  • SAP BODS: Lookup_Seq Function5:55

    This tutorial explains the concept of lookup_seq function in BODS

  • SAP BODS: Lookup_Ext Function8:07

    This tutorial explains the concept of lookup_ext function in BODS

  • QUIZ-8
  • SAP BODS: Variables| Scripting4:21

    This tutorial explains the concept of variables and Scripting

  • SAP BODS: SQL Function3:22

    This tutorial explains the how to use sql function in BODS

  • SAP BODS: Aggregate Functions4:09

    This tutorial explains the concept of Aggregate Functions in BODS

  • QUIZ-9
  • SAP BODS: Custom Functions8:23

    This tutorial explains the concept of Custom Functions in BODS

  • SAP BODS: If Else Blocks7:18

    This tutorial explains how you can use ifelse concept using script and Conditional block

  • SAP BODS: Loops6:26

    This tutorial explains how you can use loops in script and while loop block in BODS

  • SAP BODS: Substitution Parameters5:39

    This tutorial explains the use of Substitution Parameters in BODS

  • SAP BODS: System Configurations8:16

    This tutorial explains System Configuration in BODS

  • SAP BODS: Auto Correct Load2:46

    This tutorial explains the Auto Correct load option in Target table

  • SAP BODS: Overflow File Concept4:23

    This tutorial explains the Overflow file option in Target table

  • QUIZ-9
  • SAP BODS: Exporting Jobs to Different environment4:09

    This tutorial explains the ways of importing jobs to different environments

  • SAP BODS: Central Repository5:45

    This tutorial explains the concept of Central Repository for migrating code to different environments

  • QUIZ-10
  • SAP BODS| Data Migration: Overview3:38

    This tutorial gives an overview of Data Migration

  • SAP BODS| Data Migration: Mapping Sheet2:44
  • SAP BODS| Data Migration: Connecting BODS with SAP ECC and S/4 HANA3:35

    This tutorial explains how to connect BODS with ECC and S/4 HANA systems

  • SAP BODS| Data Migration: Extraction and Staging6:38

    This tutorial explains Extraction and Staging of data

  • SAP BODS| Data Migration: Transformation11:08

    This tutorial explains transformation rules based on Mapping Sheet

  • SAP BODS| Data Migration: Pre-load Generation7:40

    This tutorial explains Preload report generation

  • SAP BODS| Data Migration: Load Cost Center using BAPI13:27

    This tutorial explains how to call BAPI in BODS and load data in SAP ECC system

  • SAP BODS| Data Migration: Reconciliation Report3:56

    This tutorial explains how to generate Reconciliation report

  • SAP BODS| Data Migration: Load Cost Center Group object data using IDOCs- I8:13

    This tutorial explains how to call IDOCs in BODS

  • SAP BODS| Data Migration: Load Cost Center Group object data using IDOCs- II13:05

    This tutorial explains how to load data in S/4 HANA system using IDOCs

  • QUIZ-11
  • SAP BODS: Extracting Data from S36:40

    This tutorial explains how to extract data from Amazon S3 services.

  • SAP BODS: Loading Data to S3 using BODS3:13

    This tutorial explains how to load data to Amazon Storage Services S3.

  • SAP BODS: Understanding Data Services Management Console6:46

    This tutorial explains features of BODS Management Console.

  • SAP BODS: Error Handling using Try/Catch blocks4:40

    This tutorial explains how to Try/Catch block for error handling in BODS

  • QUIZ-12

Requirements

  • Basic Knowledge on SQL
  • SAP Data Services (BODS) remote server to practice

Description



From Basic to Advance Learning!!

If you're looking to master SAP Data Services then you're at the right place. The course covers all major transformations in detail with all real time scenarios. You will learn how to load data in SAP S/4 HANA and ECC using BAPIs and IDOCs. Apart from understanding transforms and migration you will learn code migration methods.

Below points have been covered throughout the course:

· Extracting data from different sources like Flat File, Excel, XML.

· Transformations covered in the course includes: Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation, Date Generation, SQL, Table Comparison, Map Operation, History Preserving, Key generation.

· Explanation of SCD type1/2

· All types of lookup functions explain such as lookup_ext, lookup_seq, lookup

· Scripting

· Custom Functions

· If/else Conditional blocks

· Loops

· Substitution Parameters

· Variables such as local, global variables & parameters

· Auto Correct Load

· Overflow file functionality

· Exporting jobs to different environments

· Central Repository

· Data Migration Overview

· Mapping Sheet

· Connecting BODS with ECC & S/4 HANA

· Stages of Data Migration from SAP Data Services standpoint such as Extraction, transformation, validation, load using BAPI/IDOCs.

· Data Extraction from AWS S3 buckets.

· Load data to AWS S3 buckets.

· Understanding of Data Services Management Console

· Error handling using Try/Catch blocks.

The course also covers real time interview questions asked in the industry.


Who this course is for:

  • Students who are looking forward to move into SAP BODS
  • Students who know BODS and are looking forward to learn Data Migration using IDOCs and BAPIs