SAP BODS (Business Objects Data Services) Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

SAP BODS is a single enterprise solution used for data quality, integration, profiling which further allows the user to integrate, transform and provide meaningful information that contains business processes and provides better decisions owing business.

This SAP BODS (Business Objects Data Services) training course provides the knowledge to understand the process to take part in execute, regulate and manage data integration projects. This course covers process chains, trouble shooting, scripts & variables, platform transfers and much more.

By attending SAP BODS (Business Objects Data Services) workshop, delegates will learn to:

Gain the knowledge to participate in implementing, administering, and managing data integration projects
Gain the ability to troubleshoot batch jobs and set up error handlings
Attain potential to create batch jobs for the data integration
Modify data for prediction and analysis
Gain intense understanding about Data quality services

The SAP BODS (Business Objects Data Services) class is ideal for:

ETL Developers
Information technology and business intelligence professionals
SAP HANA consultant
Business Analyst
Business Professionals who want to enhance the business intelligence skills

BODS overview

Overview of SAP Data services
Data services benefits, associated products, interfaces
Data services Architecture on single and distributed environment

BODS Designer concepts

Creating the repository (Local, Central repository)
Exploring the menu options in the Designer
Creating the Project, Job flow, Data flow, Work flows etc.
Defining different types of Data stores (Source and destination data stores)
Use data store and system configurations
Defining file formats for flat, Excel, XML files

Batch Jobs

Creating Batch Jobs
Work with objects
Create a data flow
Adding the Query transform to the data flow
Use target tables
Execute the job

Defining Data Integrator Transforms

Date Generation Transform
Pivot Transform
Reverse Pivot Transform
XML_Pipeline Transform

Defining Data Platform Transforms

Query Transform
Case Transform
Merge Transform
Validation Transform
Row Generation Transform
SQL Transform

Defining Data Quality Transform

Address Cleanse
Geocoder

Implementation of SCD

SCD Type0

Query Transform

SCD Type1

Table Comparison Transform
Map_Operation Transform

SCD Type2

Table Comparison Transform
History Preserving Transform
Key Generation Transform

Using Functions, Scripts, and Variables

Define built-in functions
Use functions in expressions
Use variables and parameters
Create Custom functions
Use Data Services scripting language

Data assessment

Using the data profiler
Using the validation transform

Setting up Error Handling

Set up recoverable work flows

Setting up Exception Handling

Try/Catch Techniques

While-Loop Implementation

Capturing Changes in Data

Data assessment

Update data over time
Use source-based CDC
Use target-based CDC

SCD Type 2

Multi-User Environment (Local Repo vs. Central Repo)

SAP Integration

Data extraction from ECC system to File, Table and SAP BI
Data extraction from ECC Extractors
Data Extraction from SAP BW
ABAP Workflows

SAP HANA and SAP BODS Integration

Introduction to SAP HANA
Introduction to SAP HANA Studio
Create Data Store for SAP HANA
Perform the load into SAP HANA
Store the data in Column Store
Preview the data in SQL console of SAP HANA Studio

Information Steward

Data Insight
Metadata management
Metapedia

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

SAP BODS (Business Objects Data Services)

COURSE AGENDA

BODS overview

BODS Designer concepts

Batch Jobs

Defining Data Integrator Transforms

Defining Data Platform Transforms

Defining Data Quality Transform

Implementation of SCD

Using Functions, Scripts, and Variables

Data assessment

Setting up Error Handling

Setting up Exception Handling

IF Conditional

While-Loop Implementation

Capturing Changes in Data

Data assessment

Multi-User Environment (Local Repo vs. Central Repo)

SAP Integration

SAP HANA and SAP BODS Integration

Information Steward

Encarta Labs Advantage