SAP Data Services Designer tool

 See more in sap bods step by step

This post gives you a short overview of the Data Services product and terminology. Refer to the post SAP BO DATA Integrator / Data Services for more details.

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
Blueprints

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 http://www.sdn.sap.com/irj/boc/blueprints.

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.

 

Refer to the ebook for more details: New Ebook – SAP BODS Step by Step

Comments

Post a Comment

Popular posts from this blog

Domains and Data Elements

  Domains A domain provided Technical attributes (type, length and possible values) for a field. The definition of domain in ABAP is same as that in Mathematics. In the world of Mathematics, a domain is defined as the set of input values that are valid for a given function. The same holds true for domains in ABAP. To understand this, let us first see what is the role of domains in ABAP data dictionary. Domains -> Data Elements -> (Structures, DB tables, program references etc.)
Read more

How to update exchange rates via process chain in BW

Image
 The exchange rate in the BW system may not be updated one. Also the business wants to see the amounts according to the exchange rates in the source. In such cases, you have to update the exchange rate in the BW system via process chain. Include the step ‘Execute ABAP Program’ in the process chain. Give the program name as ‘RSIMPCURR’. Create a variant for the program.
Read more

Sample ABAP program for Updating notepad file data to Internal table and Sending it to Application server

 *--Structure type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10. END OF TY_STD. *--Header line and internal table DATA WKA TYPE TY_STD. DATA INT_TAB TYPE TABLE OF TY_STD. *--Application server files are known as "Datasets" *--here "fname" is the Dataset DATA FNAME TYPE C LENGTH 40 VALUE "StudentsInfo.txt". *--Convert notepad file data into internal table CALL FUNCTION 'GUI_UPLOAD' EXPORTING FILENAME = 'C:Documents and SettingsAdministratorDesktopstudents.txt' HAS FIELD_SEPARATOR = 'X' TABLES DATA_TAB = INT_TAB. *--Sending data to Application Server OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE ENCODING DEFAULT. LOOP AT INT_TAB INTO WKA. TRANSFER WKA TO FNAME. ENDLOOP. CLOSE DATASET FNAME.
Read more