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

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
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.

Overview

Section 1: SAP BODS Course Preview

Lecture 1 Course Preview of SAP Data Services (BODS)

Lecture 2 SAP BODS: Briefing of topics covered

Lecture 3 SAP BODS: Create First Batch Job

Lecture 4 SAP BODS: Connection to File Format

Lecture 5 SAP BODS: Process Multiple Files in single job

Lecture 6 SAP BODS: Using Adaptable Feature in File Formats

Lecture 7 SAP BODS: File Format As Target

Lecture 8 SAP BODS: Working with Excel workbooks

Lecture 9 SAP BODS: Working with XML files

Lecture 10 SAP BODS: Case Transform I

Lecture 11 SAP BODS: Case Transform II

Lecture 12 SAP BODS: Merge Transform

Lecture 13 SAP BODS: Validation Transform

Lecture 14 SAP BODS: Pivot Transform

Lecture 15 SAP BODS: Reverse Pivot Transform

Lecture 16 SAP BODS: Row Generation Transform

Lecture 17 SAP BODS: Date Generation Transform

Lecture 18 SAP BODS: SQL Transform

Lecture 19 SAP BODS: Table Comparison Basics

Lecture 20 SAP BODS: Compare Columns in Table Comparison

Lecture 21 SAP BODS: Input Contains Duplicates in Table Comparison

Lecture 22 SAP BODS: Key Generation Transform in Conjunction with Table Comparison

Lecture 23 SAP BODS: Generated Key Column in Table Comparison

Lecture 24 SAP BODS: History Preserving with Table Comparison

Lecture 25 SAP BODS: Map Operation

Lecture 26 SAP BODS: Joins

Lecture 27 SAP BODS: Lookup Function

Lecture 28 SAP BODS: Lookup_Seq Function

Lecture 29 SAP BODS: Lookup_Ext Function

Lecture 30 SAP BODS: Variables| Scripting

Lecture 31 SAP BODS: SQL Function

Lecture 32 SAP BODS: Aggregate Functions

Lecture 33 SAP BODS: Custom Functions

Lecture 34 SAP BODS: If Else Blocks

Lecture 35 SAP BODS: Loops

Lecture 36 SAP BODS: Substitution Parameters

Lecture 37 SAP BODS: System Configurations

Lecture 38 SAP BODS: Auto Correct Load

Lecture 39 SAP BODS: Overflow File Concept

Lecture 40 SAP BODS: Exporting Jobs to Different environment

Lecture 41 SAP BODS: Central Repository

Lecture 42 SAP BODS| Data Migration: Overview

Lecture 43 SAP BODS| Data Migration: Mapping Sheet

Lecture 44 SAP BODS| Data Migration: Connecting BODS with SAP ECC and S/4 HANA

Lecture 45 SAP BODS| Data Migration: Extraction and Staging

Lecture 46 SAP BODS| Data Migration: Transformation

Lecture 47 SAP BODS| Data Migration: Pre-load Generation

Lecture 48 SAP BODS| Data Migration: Load Cost Center using BAPI

Lecture 49 SAP BODS| Data Migration: Reconciliation Report

Lecture 50 SAP BODS| Data Migration: Load Cost Center Group object data using IDOCs- I

Lecture 51 SAP BODS| Data Migration: Load Cost Center Group object data using IDOCs- II

Lecture 52 SAP BODS: Extracting Data from S3

Lecture 53 SAP BODS: Loading Data to S3 using BODS

Lecture 54 SAP BODS: Understanding Data Services Management Console

Lecture 55 SAP BODS: Error Handling using Try/Catch blocks

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