SAP Data Services Designer tool

This post gives you a short overview of the Data Services product and terminology.

Data Services Components

The following diagram illustrates Data Services product components and relationships-

Data Services Configuration

You can configure SAP BusinessObjects Data Services in various ways. The following diagram illustrates
one possible system configuration-


The Designer Window


Transform Objects in Data Services Object Library

Object Hierarchy for key object types in Data Services

Work Flow in BODS

Data Flow in BODS


SAP has identified a number of common scenarios that you are likely to handle with Data Services.
Instead of creating your own job from scratch, look through the blueprints. Instructions for downloading and installing the content objects are located on the SAP
BusinessObjects Community Network at

Object Naming Convention

Follow for easy understanding-

Prefix  Suffix  Object  Example
JOB Job JOB_SalesOrg
WF Work flow WF_SalesOrg
DF Data flow DF_Currency
DS Datastore ODS_DS

New Terms

Term  Description
Attribute Property that can be used as a constraint for locating objects.
Data flow Contains steps to define how source data becomes target data. Called by a workflow or job.
Datastore Logical channel that connects Data Services to source and target databases.
Job The smallest unit of work that you can schedule independently for execution. A job is a special work flow that cannot be called by another work flow or job.
Metadata Data that describes the objects maintained by Data Services.
Object Any project, job, work flow, data flow, datastore, file format, message, custom function, transform, or transform configurations created, modified, or used in Data Services.
Object library Part of the Designer interface that represents a “window” into the local repository and provides access to reusable objects.
Option A choice in a dialog box that controls how an object functions.
Project Logical grouping of related jobs. The Designer can open only one project at a time.
Property Characteristic used to define the state, appearance, or value of an object; for example, the name of the object or the date it was created.
Repository A database that stores Designer predefined system objects and user-defined objects including source and target metadata and transformation rules. Can be local or central (shared).
Source Table, file, or legacy system from which Data Services reads data.
Target Table or file to which Data Services loads data.
Work flow Contains steps to define the order of job execution. Calls a data flow to manipulate data.


Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images also are copyright of the SAP Software.