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
* Requirements
* You would need BODS system access to practiceDescription
*******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
Comments and Annotation Preview 02:24
Question
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
Custom Function Preview 04:47
Question
Transport via File Preview 03:16
Question
Various In-Built Functions Preview 02:29
Question
Connect AWS S3 Preview 05:50
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
New : Data Masking Preview 06:58
New : Data Encryption Preview 05:34
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