Course Details

Business Objects’s Data Integrator is a data integration and ETL tool that was previously known as ActaWorks. Newer versions of the software include data quality features and are named SAP BODS (BusinessObjects Data Services). The Data Integrator product consists primarily of a Data Integrator Job Server and the Data Integrator Designer. It is commonly used for building data marts, ODS systems and data warehouses, etc.

SAP BODI Training Concepts

Overview of Data Services

Introduction of Data Services Architecture, Data Services Designer, Data Services repository, Data Services Job Server, Data Services engine, Data Services Access Server, Data Services Address Serveraz, Data Services Administrator, Data Services Metadata Reports applications, Data Services Service, Data Services SNMP Agent, Data Services Adapter SDK, Data Services SAP RAPID MARTS.

Preparing to Install Data Services Client /Server Components

Pre-installation overview, Installation scenarios

Repository Creation

Repository database requirements and preparation, Creating a Data Services repository and Selecting a repository, Central versus local repository creation with live examples, Using the Repository Manager, Multi-user Environment Setup, Activating a central repository, Implementing Central Repository Security, Data Services and multiple users, Security and the central repository, Version Checking, Adding objects to the central repository Checking out.

Logging into the Designer

Project area, Tool palette, Workspace, Local object library, Object editors and Working with objects

About Projects and Jobs

Executing Jobs, Overview of Data Services job execution,Preparing for job execution, Monitoring Jobs

Datastore creation and Overview

Datastores and Data Flows — What is a data flow, Datastore and system configurations, Multi-user Development, Creating and managing multiple datastore configurations, File Formats and what are file formats?, File format editor, Creating file formats and Editing file formats

Configure a Job Server

Changing Job Server options, Configure an Access Server, To configure Metadata Integrator, To select a web application server

Using the Server Manager

Performing a scripted installation, Logging in to the Management Console, Connecting the Data Profiler,Troubleshooting installation problems, Running Data Services components in multi-user mode

Publishing Data Services

Transformations and usage in data services, Descriptions of transforms, Query transforms overview, Data Quality transforms overview, Lookup tables and the lookup_ext function

Data flow execution

Creating and defining data flows, Calling data flows to perform data movement operations, Defining the conditions appropriate to run data flows, Pass parameters to and from data flows

Work Flows and what is a work flow

How to Creating a work flows, Steps in a work flow and Order of execution in work flows

Creating real-time jobs

Real-time source and target objects, Testing real-time jobs

Overview of variables and parameters

How to create Variables and Parameters, Using local variables and parameters and about global variables, Local and global variable rules

Overview of data quality

Address Cleanse transformation overview, Data Cleanse
Match, Design and Debug, Using View Data to determine data quality, Using the Validation transform

Understanding changed-data capture

Using CDC with Oracle sources, Using CDC for targets/Sources

Data Services Management Console: Administrator

Scheduling, monitoring, and executing batch jobs, Connecting repositories to the Administrator, Configuring, starting, and stopping real-time services, Configuring Job Server, Access Server, and repository usage, Configuring and managing adapters
Managing users, Publishing batch jobs and real-time services via Web services

Functions and Procedures About functions, Descriptions of built-in functions

Raising Exceptions by usingTry/catch blocks

Catch error functions and other function calls, Nested try/catch blocks, If statements to perform different actions for different exceptions

Job Scheduling using scripting and How to use Scripts in BODS

Data Services Scripting Language, Python, Python in Data Services

Batch Jobs

Executing batch jobs, Scheduling jobs and Monitoring batch jobs

Using the Data Profiler

Defining the profiler repository, Column level profiling, Detail profiling

Recovery Mechanisms

Recovering from unsuccessful job execution, Automatically recovering jobs, Manually recovering jobs using status tables

Salary Trends

Average SAP BODI Salary in USA is increasing and is much better than other products.


Course Reviews


225 ratings
      • Tekslate has been one of the finest global online learning portals with clear information and learning. I attended the Apache Spark Certification training. The best part is that they have provided IDE ...
      • I have taken 2 instructor-led courses (SAP HANA and BO). The course contents were really rich, and trainers are experts in the technology fields. I would like to recommend the course to my colleagues ...
        Katelyn Thomas
      • After a great research on available online courses, I have decided to opt Tableau Training from Tekslate, am quiet satisfied with that. Coursework is well calibrated to make student more comfortable w ...
        Christinia Beth
      • I have enrolled last month, and finished the course... As a working professional, they given me an exposure to the domain, but also helped to learn the cross technologies and develop an inclination to ...
        Alison Benhar
    drop query

    Send us a Query

    Enroll into this course

    Register for Free Demo

    Three + 6

    Related Articles

    No Related Articles found


    Please leave a message and we'll get back to you soon.
    Three + 6