Learning Path for SAP Data Services

New to this topic? Not sure where to start? For your convenience, we have created the below learning path where articles are organised in the order of their relevance and complexity. Start from the beginning and read one by one to master the subject.

OrderTopicLevelCBIP
1One Stop to SAP BODI/BODSBasic
2How to install SAP BODS - StandaloneBasic
3SAP BODS Cluster InstallationBasic
4Why SAP Data ServicesBasic
5Getting Started SAP BODSBasic
6Fools Guide to BODS - Introductory TutorialBasic
7Fools Guide to BODS - Repository CreationBasic
8Fools Guide to BODS - Registering Repository to CMCBasic
9Fools Guide to BODS - DesignerBasic
10SAP BODS TransformsBasic
11Working with Data Services FlatfilesBasic
12How to handle multiple input file in SAP Data ServicesIntermediate
13Data Services Flatfiles TipsBasic
14XML file generation using SAP Data ServicesIntermediate
15Handling XML source files in SAP Data ServicesIntermediate
16Exception Handling While Reading Multiple XML Files in Data ServicesIntermediate
17Learning SAP Data Services - Online TutorialBasic
18How to use Lookup and Join in SAP Data ServicesBasic
19How to use SAP Data Services Case TransformBasic
20Using MERGE Transform in SAP Data ServicesBasic
21Data Services Scenario Questions Part 1Basic
22Data Services Scenario Questions Part 2Basic
23Data Services Scenario Questions Part 3Basic
24Data Services Scenario Questions Part 4Basic
25Data Services Scenario Questions Part 5Basic
26Data Services Scenario Questions Part 6Basic
27Data Services Scenario Questions Part 7Basic
28How to use Data Services Pivot TransformationIntermediate
29How to use Data Services Reverse Pivot TransformationIntermediate
30Table Comparison Transform to Implement Slowly Change Dimension (SCD) in Data ServiceIntermediate
31How to implement SCD Type 2 using History Preserve Transform in Data ServicesIntermediate
32How to implement SCD Type 3 in Data ServicesIntermediate
33SAP Data Services Analytic FunctionsIntermediate
34RANK in Data ServicesIntermediate
35DENSE RANK in Data ServicesIntermediate
36GROUP RANK in Data ServicesIntermediate
37Data Services Scripting LanguageAdvanced
38SAP Data Services Custom FunctionAdvanced
39Auditing in SAP Data ServicesIntermediate
40Error Handling, Recoverability- SAP Data ServicesIntermediate
41Real Time Jobs in Data ServicesIntermediate
42Web Service Call in SAP Data ServicesIntermediate
43Text Data Processing using SAP Data ServicesAdvanced
44Map_CDC_Operation in Data ServicesIntermediate
45SCD implementation from Source based CDC tableIntermediate
46Data Services Metadata Query Part 1Basic
47Data Services Metadata Query Part 2Basic
48Data Services Metadata Query Part 3Basic
49Top 50 SAP Business Objects Data Services (BODS) Interview Questions with AnswersBasic

In this article, we will learn how to use SAP Data Services Reverse Pivot Transform. The Reverse Pivot transformation combines data from several rows into one row by creating new columns. For each unique value in a pivot axis column and each selected pivot column, Data Services produces a column in the output data set. It basically creates one row of data from several existing rows, i.e. to Pivot Rows to Columns.

In this article, we will learn how to use SAP Data Services Pivot Transform. The Pivot transformation allows us to change how the relationship between rows is displayed. For each value in each pivot column, Data Services produces a row in the output data set. We can create pivot sets to specify more than one pivot columns. It basically convert Columns to Rows.

In this tutorial we will discuss some scenario based questions and their solutions using SAP Data Services. This article is meant mainly for Data Services beginners.

In this tutorial we will discuss some scenario based questions and their solutions using SAP Data Services. This article is meant mainly for Data Services beginners.

In this tutorial we will discuss some scenario based questions and their solutions using SAP Data Services. This article is meant mainly for Data Services beginners.

In this tutorial we will discuss some scenario based questions and their solutions using SAP Data Services. This article is meant mainly for Data Services beginners.

In this tutorial we will discuss some scenario based questions and their solutions using SAP Data Services. This article is meant mainly for Data Services beginners.

In this tutorial we will discuss some scenario based questions and their solutions using SAP Data Services. This article is meant mainly for Data Services beginners.

In this tutorial we will discuss some scenario based questions and their solutions using SAP Data Services. This article is meant mainly for Data Services beginners.

This tutorial describes how to use MERGE transform in SAP Data Services (formerly known as BusinessObjects Data Services). A short video is also provided to provide hands-on.

In this tutorial, we will learn how to use SAP data services Case Transform. Case transform provide us a means to implement "If... Then... Else" logic in data services. In the end a short video is provided with this tutorial to give you a hands-on feel in data services.

In this tutorial, we will learn how to perform lookup and join in SAP BusinessObjects data services using the Query Transform. In the way, we will also see how to use some of the basic inbuilt functions that are provided in data services. A short video is provided with this tutorial to give you a hands-on feel in data services.

We are pleased to start this new tutorial page for SAP BusinessObjects Data Services (BODS). If you do not know SAP Data Services (BODS) yet but wish to master this ETL tool, you have come to the right place. Even if you are already familiar with this tool, we hope you can still learn a lot of things from our articles as we progress further. Also please note, all the articles in this series will be backed by corresponding video tutorials and we highly recommend you to watch the videos as and when you read the articles. Let's get started.

This article will demonstrate loading multiple XML files using SAP Data Services including Exception Handling.

This article will demonstrate how to read data from XML based source files using SAP Data Services. Here our objective is to load employee and department information respectively from the source XML based file.

This article will demonstrate how to generate XML target files using SAP Data Services. Here our objective is to generate XML file with employee and department information.

Often we come across scenarios where we have the flat file definition in an excel sheet and we need to create corresponding File Format in SAP Data Services. Alternatively we import file format definition from a Sample Source file.

In this tutorial, we will learn how we can use a single data flow to process multiple input files of same structure using SAP Data Services. Like before, we have included one hands-on video with the tutorial to help you see the technique in action

In this article we will try to cover all the possible scenarios related to flatfiles in SAP Data Services.

This article deals with the various types of transformations available in SAP BODS. Transformations are in-built, optional objects used in dataflow to transform source data to desired output dataset objects available in Local Object Library under the Transforms tab. There are four categories of Transform available in SAP BODS namely Data Integrator, Data Quality, Platform and Text Data Processing.


Have a question on this subject?

Ask questions to our expert community members and clear your doubts. Asking question or engaging in technical discussion is both easy and rewarding.

Are you on Twitter?

Start following us. This way we will always keep you updated with what's happening in Data Analytics community. We won't spam you. Promise.