Category: how2BODS

Posts and helpful articles on BODS.
The tool named Data Integrator and Data Quality end with version 11.x. These two tools have now been combined into one tool called Data Services XI.

The posts here are valid for the Data Services 4.0 version.

ABAP Dataflow & Transports in BODS

Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images are copyright of the SAP Software. In this post you will create two local repositories and one central repository and perform the tasks associated with sharing objects using Data Services.

Multiuser functionality in SAP Data Services

In this post you will create two local repositories and one central repository and perform the tasks associated  with sharing objects using Data Services. You can also check the post Central Repository in BODS for more details. Multiuser Development This section introduces you to Data Services features that support multiuser development. Data Services enables multiple users to work…

Read the full article

Recoverable workflow in BODS

This post describes on how to: • Design and implement recoverable work flows. • Use Data Services conditionals. • Specify and use the Auto correct load option. • Replicate and rename objects in the object library.   Recovery Mechanisms Creating a recoverable work flow manually A recoverable work flow is one that can run repeatedly…

Read the full article

CDC in BODS

Changed-Data Capture This post introduces the concept of changed-data capture (CDC). You use CDC techniques to identify changes in a source table at a given point in time (such as since the previous data extraction). CDC captures changes such as inserting a row, updating a row, or deleting a row. CDC can involve variables, parameters, custom (user-defined)…

Read the full article

Debugger in SAP Data Services

Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images also are copyright of the SAP Software. Data Services Components The following diagram illustrates Data Services product components and relationships-

SAP Data Services Designer tool

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-

Pivot in BODS

Pivot in Data Services: This creates a new row for every value that you specify as a pivot column. Observe the icon, it says that it will convert column to rows. Options: