loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for SAP BODS Online Training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Marks Solutions

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

SAP BODS Online Training

Online Instructor led Course

Platform: Goto Meeting

30,000

No Reviews Yet
0 Interested

About the Course


What is SAP BODS ?

It is an ETL tool currently acquired by SAP used for integration with all types of disparate systems, extracting data from them, transforming them into meaningful information and loading them into all types of systems.
It is tightly integrated with SAP systems and hence really a good tool to migrate data from legacy systems to SAP systems with ease and less development efforts with effective debugging and monitoring capabilities.
BODS Business Objects Data Services is a GUI workspace that allows to create jobs that extracts data from heterogeneous sources, transforms that data using built-in transforms and functions to meet business requirements and then loads the data into a single datastore or data warehouse for further analysis.
SAP Business Objects Data Services can be used for both real-time and batch jobs.

Topics Covered

DW Concepts
Definition
Methodologies
Dimensional Modeling
DW Lifecycle
DW Challenges
ETL Overview
ETL introduction
Staging Area
Business Rules
Performance
Slowly Changing Dimensions
Surrogate Keys
Facts and Dimension Tables
Different ETL Tools

Business Objects Overview
History
Components
Architecture
Data Services
Purpose of Data Services
Data Services architecture
Define Data Services objects
Data Services Designer interface
Data Services Objects
Object Hierarchy
Jobs
Workflows
Data Flows
Source and Target Metadata
Data Stores
File formats for flat files
File formats for Excel files
File formats for XML files
Lab Exercises
Environment setup
Creating repository
Setting Job Server
Setup for realtime operation
Setting multiple datastores
Starting Job servers
Lab Exercises
Batch Jobs
Work with objects
Create a data flow
Use the Query transform
Use target tables
Execute the job
Lab Exercises
Troubleshooting Jobs
Use descriptions and annotations
Validate and tracing jobs
Use View Data and the Interactive Debugger
Use auditing in data flows
Lab Exercises

Functions, Scripts and Variables

Define built-in functions
Functions in expressions
Lookup function
Decode function
Variables and parameters
Data Services scripting languag
Scripting custom functions
Lab Exercises
Important Transforms

Map Operation transform
Validation transform
Merge transform
Case transform
SQL transform
Lab Exercises
Other Transforms
Pivot transform
Hierarchy Flattening transform
Data Transfer transform
XML Pipeline transform
Lab Exercises
Error Handling
Error Handling
Recoverable work flows
Change Data Capture
Update data over time
Database native CDC mechanisms
Source-based CDC
Target Comparison
Lab Exercises
Data quality Overview
Fundamentals of DQ and Data Cleansing
Built in DQ Transformations
Data Validation
Name & Address cleansing
De duplication
Cleansing other data
Lab Exercises
Web-Services and Real-Time Integration
Real Time Jobs
SOAP Introduction
Web Services
SAP Integration
Creating datastores for SAP databases
Accessing SAP data
Running ABAP programs
R/3 Data flows


Who should attend

SAP BI & SAP BO Consultants , Data warehousing guys

Pre-requisites

Basic knowledge of BI & BO

What you need to bring

Just need an internet conncetion

Key Takeaways

Good understanding of BODS.
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Sekhar

SAP ABAP Consultant


Mr.Sekhar has been working in SAP ABAP From last 7 yrs and he is Certified ABAP Consultant.. Specialized in SAP ABAP, Webdynpro, OOPs, Workflow Areas and has a track record of completing 250 batches till now from last 4 yrs with us.
Seats Left-

Students Interested 0

Course Id: 17041