SAP Data Migration along with SAP Data Services (BODS)

The course will prepare the beginners who are willing to make career into SAP Data Migration. The course covers SAP Data Services (BODS) as well in depth.

Here is the course that you will be learning throughout the course. It mainly focuses on the SAP Data Migration from scratch until go-live of a project. You will learn what are the things required to setup Data Migration project, various phases of data migration like working on Mocks and learn the cut-over to make project go-live.

After taking this course, the learners will be able to work as SAP Data Migration Consultant or as SAP Data Services (BODS) developer.

In the end of the course the certification path will also be discussed.

Overview

• Overview of the SAP Data Migration

• Overview of the Data services

• Data services Architecture on single and distributed environment

BODS Concepts

• Creating the repository (Local, Central repository).

• Exploring the menu options in the designer.

• Creating the project, Job flow, Data flow, Workflows etc., defining different types of Data stores (Source and destination data stores).

• Use data store and system configurations.

• Defining file formats for flat, Excel.

Working with Batch Jobs

• Creating Batch Jobs

• Working with objects

• Create a data flow

• Adding the Query transform to the data flow

• Use target tables

• Execute the job

Working with BODS Transforms

• Query Transform

• Case Transform

• Merge Transform

• Validation Transform

• Row Generation Transform

• Validation Transform

• SQL Transform

• Pivot Transform

Using Functions, Scripts, and Variables

• Define built-in functions

  • Decode()

  • nvl()

  • gen_row_num()

  • gen_row_num_by_group()

  • Aggregate function – count, min, max

  • current_system_configuration()

  • substr()

  • replace_substr() help me

  • word_ext() –

  • host_name( )

  • job_name()

  • rpad() –

  • lpad()

  • rtrim_blanks()

  • ltrim_blanks()

• Use functions in expressions

• Use variables and parameters

• Create Custom functions

• Use Data Services scripting language

Setting up Error Handling

• Set up recoverable workflows

Setting up Exception Handling

• Try/Catch Techniques

IF Conditional

While-Loop Implementation

Multi-User Environment (Local Repo Vs Central Repo)

SAP ECC / S4HANA Integration

Working with IDoc

Working with LSMW

Working with LTMC / LTMOM