SAP Business Objects Data Services (BODS)

The SAP Business Objects Data Services application can help by delivering a single enterprise-class solution for data integration, data quality, data profiling, and text analysis that allows you to integrate, transform, improve, and deliver trusted data that supports critical business processes and enables sound decisions.

SAP Business Objects Data Services combines industry-leading data quality and integration into one platform. With Data Services, your organization can transform and improve data anywhere. You can have a single environment for development, runtime, management, security and data connectivity.

One of the fundamental capabilities of Data Services is extracting, transforming, and loading (ETL) data from heterogeneous sources into a target database or data warehouse. You create applications (jobs) that specify
data mappings and transformations by using the Designer.

Use any type of data, including structured or unstructured data from databases or flat files to process and cleanse and remove duplicate entries. You can create and deliver projects more quickly with a single user interface and performance improvement with parallelization and grid computing.

Data Services Real Time interfaces provide additional support for real-time data movement and access. Data Services Real Time reacts immediately to messages as they are sent, performing predefined operations with message content. Data Services Real Time components provide services to web applications and other client applications.

The Data Services product consists of several components including:


The Designer allows you to create, test, and execute jobs that populate a data warehouse. It is a development tool with a unique graphical user interface. It enables developers to create objects, then drag, drop, and configure them by selecting icons in a source-to-target flow diagram. It allows you to define data mappings, transformations, and control logic. Use the Designer to create applications specifying work flows (job execution definitions) and data flows (data transformation definitions).

• Job Server

The Job Server is an application that launches the Data Services processing engine and serves as an interface to the engine and other components in the Data Services suite.

• Engine

The Data Services engine executes individual jobs defined in the application you create using the Designer. When you start your application,the Data Services Job Server launches enough engines to effectively accomplish the defined tasks.

• Repository

The repository is a database that stores Designer predefined system objects and user-defined objects including source and target metadata and transformation rules. In addition to the local repository used by the Designer and Job Server, you can optionally establish a central repository for object sharing and version control.

Business Objects Data Services (along with Xcelcius) Version 4.0

What is Data Services

Importance of Data Services

Position of Data Services in BI Solution

Architecture of Data Services

  • Components of Data Services

Repository Concept

Building blocks in Data Services Designer

  • Datastores
  • Jobs
  • Workflows
  • Dataflows
  • Sources – Files, Tables
  • Targets – Files, Tables
  • Query Transform
  • Few Important Transforms

Running the BODS Jobs

  • Scheduling the BODS Jobs
  • Troubleshooting


What is Xcelcius / SAP BO Dashboard Designer

Importance of Xcelcius

Position of Xcelcius in BOBJ Solution

Understanding the Interface of Xcelcius

Quick walk through the types of Components

Using the Excel connectivity to Components

Design simple dashboard

Query / Web service connectivity to Xcelcius components


BODS Training, BODS Training Toronto, BODS Training Mississauga

Comments are closed.