Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




SAP Business Objects Data Services 4.0

This web-based training course on SAP Business Objects Data Services 4.0 functionality, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.


SAP BODS or Business Object Data Services is a single software tool for all data integration, data profiling, data quality, and text data processing needs of a business. BODS has been designed by Business Objects, which allows users to build and implement workflows by taking data from predetermined sources known as data stores. SAP Business Objects Data Services performs functions such as Data warehousing, Data Migration, Business Intelligence and ETL or Extraction Transformation and Loading. The software tool offers users a very easy and effective interface that allows them to handle all the data manipulation tasks with utmost perfection.


Overview of BODS

  • BODS as compared to other DI software package
  • Advantage of BODS
  • ETL and ELT methodologies
  • Combining ETL and ELT into one tool
  • Components and Architecture of Data Services

Basics of BODS

  • Job, Workflow and Data Flow
  • Datastore
  • Basic Batch Job
  • Transforms overview

Data profiling and Query Transform

  • Analyzing Sources of data
  • Joining data received via multiple sources
  • Transformations and build-in functions
  • Aggregating data with BODS
  • Lookup in BODS

Working with Files

  • File formats for file data source
  • XML files(XSD,DTD)
  • COBAL COPY BOOKS
  • File Formats as Source and Targets

Platform Transforms Overview

  • Case and Merge transforms
  • SQL transforms
  • Validation transforms
  • Generation of Rows
  • Operations on Maps
  • Validation and Auditing

Data Integrator Transforms

  • Working on hierarchical data
  • Hierarchy Flattening
  • Merging data
  • Table Comparison transforms
  • More ways of Merging data for RDBMS datastores
  • Dimension support in BODS
  • Transformation for History preserving
  • Built-in functions
  • Date and time functions
  • Date generation transform for building a dimension table
  • Lookup functions
  • Match pattern functions
  • Database type functions

Metadata Management

  • Local and Central repositories
  • Working in groups
  • Moving Job from development to staging and production environment
  • Backing up metadata
  • ATL file. Export\Import operations
  • Validating, tracing, and debugging jobs
  • Description and annotations
  • Validating and tracing jobs
  • View data
  • Interactive Debugger

Management Console

  • Administrating BODS
  • Major tools
  • Executing Job from server
  • Scheduling jobs
  • Auto-Documentation reporting
  • ETLs with auto documentation

BODS Scripting Language

  • Scope of variable
  • Advantages and limitations of scripting language
  • Custom functions
  • Creation of simple function
  • Procedures of Database
  • Custom functions and database functions comparison

SAP BW 7.3 AND SAP ECC,SAP CRM BODS INTEGRATION

  • SAP Applications integration
  • ABAP data Flow processing with Dataservices
  • IDoc interface connectivity with Dataservices
  • SAP Application table source with Dataservices
  • Executing Batch jobs having ABAP Dataflows
  • SAP Net weaver Business warehouse
  • Dataservices in SAP NW BW environments
  • Openhub tables
  • SAP Net Weaver BW Datastores with Data services
  • Loading SAP NW BW wiht Dataservices.

SAP HANA 1.0 SPS5 BODS INTEGRATION

  • BODS 4.2 With SAP HANA to build Agile Datamarts
  • Diffrennt Transforms and File systems

Error Handling in BODS

  • Validating Data Flow, Workflow and Job
  • Error handling at Workflow level
  • Analyzing execution of Batch Job
  • Debugging with BODS
  • Handing execution errors

Performance optimization in BODS

  • Push-down concept
  • When push-down doesn't work
  • Data Transfer transform
  • Cashing with BODS
  • Defining caching in lookups and Table Comparisons
  • Degree of parallelism
  • Custom functions for parallel execution
  • Bulk loading operations
  • Using MultiLoad with Teradata targets
  • Execution parameters
  • Rows per commit
  • Number of loaders

Using BODS Metadata

  • BODS metadata Accessing
  • Operational metadata
  • Metadata Auditing
  • Creation of personal metadata using BODS metadata

Possible Alternative Topics

  • Data Quality with BODS
  • SAP and SAP BODS
  • Real-time jobs
  • Integration with other applications
  • Automatic job creation with template

In the world of SAP, Business Objects Data Services 4.0 is not just another tool. The significance of SAP BODS in SAP is really increasing because it integrates with a large number of SAP products. In the present IT world there are many other products and tools that do the same function but the reliability and performance delivered by SAP BODS 4.0 is above all. The functions and programs inside Business Objects Data Services 4.0 are completely designed to fulfill all the data needs of organizations. Talking about the professional scope for individuals, a SAP Business Objects Data Services 4.0 is all you need to shine out in the world of SAP.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright © 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.