Sap Bods

Tags: SAP

S4HANA Data Migration | ETL with BODS|Data Quality | Information Steward | CDC | Cloud Connect | BODS Certification

Last updated 2022-01-10 | 4.5

- You will learn how to create various BODS objects
- You will learn BODS from scratch with all Hand-On exercise
- You will learn learn how to migrate data to S4HANA

What you'll learn

You will learn how to create various BODS objects
You will learn BODS from scratch with all Hand-On exercise
You will learn learn how to migrate data to S4HANA
You will learn various BODS functionality in detail
You will learn how to connect BODS to Data Source and various File formats
You will learn how to consume and produce various XML files and Nested structures
How to work with Data Quality Transforms
How to work with Information Stewards

* Requirements

* You would need BODS system access to practice

Description



*******Use this code for extra discount : JAN2022




"I think that this course is very effective and is as equally effective as a face to face course. " - Karunakaran


"The way concepts explained was good and easy to understand." - Jyoshna


"Explanation and presenting of concepts - excellent!! keep up the good work!" - Goku


If you want to learn SAP Data Services (BODS) from scratch in most comprehensive way then this course if for you.

In this course we will be covering almost all the things required for BODS certification.

No prior BODS experience is required for this course.


Listing down things you will learning with this course :


- Detailed BODS Designer Walk Through

- Creation of Data connection (DS)

- Using File Format as Source and Target

- Using Excel File Format to consume the data

- Using Joins and Filters

- Using Platform Transform Techniques (Merge, Join, SQL, Validation, Query , Case Etc.)

- Using Standard and Custom Functions

- Detailed BODS Admin Panel Walk Through

- Scheduling of  Jobs from Admin Panel

- Pivoting and Reverse Pivoting of Data

- Using Script, Variable and Parameters

- Overview of Slowly Changing Dimensions (SCD)

- Using Source-Based Change Data Capture (CDC)

- Using Target-Based Change Data Capture (CDC)

- Various methods of Error Handling

- Validation, Tracing , Auditing & Debugging of BODS objects

- Using of  Loop Functionality

- How to Transport BODS object

- Using various in-built BODS functions

- Step By Step S4 Data Migration

- Details on various Data Quality Transforms

- How to use Information Steward

- Information Stewards Data Insights, Metapedia, Metadata, Joins, Custom Cleaning Package

- More lectures on File error handling

- BODS Data Compare

- Connect to S4HANA/ECC

- Call S4HANA/ECC Functions in BODS

- BW Datasource (ODP) Extraction

- Connect to AWS cloud

- BODS theory (Optional)


If you have any queries then please contact us or ask in QnA section.


Tags : SAP BODS, SAP BO Data Services, SAP Body

Who this course is for:

  • Anyone who is interested in learning ETL tool like BODS
  • SAP developers, Architects, Delivery Managers, Fresh Graduates

Course content

27 sections • 117 lectures

Introduction Preview 03:29

Introduction

Important Message Preview 03:13

Please watch this video before moving ahead.

How To Use This Course Preview 01:04

ETL Tools : An Overview Preview 01:47

BODS : An Overview Preview 02:58

BODS Designer Walkthrough Preview 04:15

Question

Connect to DB : Create DS Preview 07:20

Create first BODS Job Preview 09:43

Question

Using File as a Source Preview 06:08

Using File as a Target Preview 03:31

Question

Working with Excel File format Preview 02:35

Using Joins and Filters Preview 08:01

Question

Special Gift Preview 00:15

Validation Transform Preview 07:02

New : Validation Transform 2 Preview 08:11

Using Case Tranform Preview 03:53

Using Merge Tranform Preview 02:20

Using SQL Transform Preview 02:45

Using Row Generation Preview 01:34

New : Map Operation Preview 05:50

Question

Function Overview and Lookup Ext Preview 03:21

Aggregate Function Preview 03:29

Question

Request Preview 00:18

Script , Variable and Parameters : Concept Preview 02:46

Script , Variable and Parameters : Demo Preview 09:05

Questions

SCD : Slowly Changing Dimensions Preview 04:13

Question

Source-Based Change Data Capture (CDC) Preview 10:30

Target-Based Change Data Capture (CDC) Preview 09:34

Question

Error Handling : Auto Recovery Preview 05:44

Error Handling : Alternate WF Preview 11:18

Error Handling : Auto Recovery with Try and Catch Preview 06:50

Question

Work with If-Else & Decode Preview 03:28

Work with Loop Preview 02:33

Question

New : Date Generation Preview 03:24

New : Effective Date Preview 03:12

New : Data Transfer Preview 04:43

New : Hierarchy Flattening Preview 08:39

Connect to XML Preview 06:03

Read from XML.

New : XML Various Option Preview 09:13

XML Split Preview 04:36

Generate XML from Table Preview 05:12

New : Unstructured Data Processing Preview 06:23

New : System Configuration Preview 09:31

New : Connect to ECC and HANA System Preview 08:35

Update : Function Call from SAP Preview 08:26

Update : Extract SAP BW (ODP) data source data using BODS Preview 14:33

New : What is Migration? What is Migrated. Preview 06:20

New : Overview of BODS Migration Flow Preview 03:18

New : The Steps We Will Follow Preview 02:34

New : Understanding the Requirement Preview 07:05

New : Migration Step I Preview 07:03

New : Migration Step II Preview 09:28

New : Migration Step III Preview 13:14

New : Migration Step IV Preview 04:00

New : Migration Step V Preview 14:38

Update : Why We Need Quality Data? Preview 05:08

Update : Data Quality Part I Preview 05:30

Update : Data Quality Part II Preview 01:16

Update : Data Quality Part III Preview 18:58

Update : Data Quality Part IV Preview 18:14

Update : Data Quality Part V Preview 14:04

Update : Information Steward Intro Preview 01:33

Update : Information Steward Walk through Preview 02:17

Update : Information Steward : Data Insight Preview 06:49

Update : Information Steward : Data Insight II Preview 11:16

Update : Information Steward : Data Insight III Preview 13:05

Update : Information Steward : Data Insight IV Preview 07:47

Update : Information Steward : Data Insight V Preview 03:16

Update : Information Steward : Metadata Preview 02:21

Update : Information Steward : Metapedia Preview 02:41

Update : Information Steward : Custom Cleaning Package Theory Preview 01:39

Update : Information Steward : Custom Cleaning Package Preview 07:47

Update : Information Steward : Adhoc Details Preview 03:23

Update : File Format Error Handling Preview 09:37

Update : Handling of Special Char Preview 08:49

Update : Data Compare Part I Preview 14:06

Update : Data Compare Part II Preview 09:45

Thing to Note : Before we Start Preview 00:34

BODS Installation Preview 04:57

BODS Server Group and Repo Preview 02:13

BODS Security Preview 02:53

BODS Performance Preview 05:53

Connect to XML Preview 00:03

This has been moved to  Semi-Structured, Unstructured Data Processing (Section 19) Section

Persistent Cache Preview 03:44

Use of Persistent Cache

Thank You Note and Information Preview 00:40