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.

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

Learn the answers of some critical questions commonly asked during SAP BO Data Services interview.

This article is a continuation of the previous topic related to Data Services Metadata Query. Let us explore more into the Data Services Repository Metadata.

This article is a continuation of the previous topic related to Data Services Metadata Query. Let us explore more into the Data Services Repository Metadata.

Data Services provides full access to the repository metadata tables and views for metadata analysis. To access this metadata either we can use SQL SELECT statements or use the metadata reporting from Management Console.

Consider a scenario where we want to capture all or any changes in the source table to be maintained as history in our data warehouse dimension table. So if we consider day end batch load we will miss out any intermediate changes to the master data as the OLTP system doesn't maintains version. But what if we have already captured the changes via database CDC mechanism. Then based on the operation type and operation order of CDC based source table we can ascertain the corresponding operations to the dimension table. We can even avoid lookup to the target dimension table for SCD Type 2 implementation with optimum performance.

Map CDC Operation is used to support relational or mainframe changed-data capture (CDC). This transform reads the source DML changes i.e. INSERT/UPDATE/DELETE and reflects the same in the target system. So the transform maps all the source rows logged as insert to an insert, all updates to update and the deletes to delete in the target table.

This article deals with Text Data Processing using SAP Business Objects Data Services with the intension of Text Analytics. SAP BODS provides a single ETL platform for both Structured and Unstructured data as well as Data Quality, Data Profiling and Data Cleansing functionalities.Entity Extraction transform available as a part of Text Data Processing of Data Services, helps to extract entities, entity relationships and facts from unstructured data for downstream analytics. The transform performs linguistic processing on content by using semantic and syntactic knowledge of words, to identify paragraphs, sentences, clauses, entities and facts from textual information.

This article demonstrates, how to implement external web services call in SAP Data Services.

SAP Data Services provides Realtime Data Integration features. Data Services can generate realtime event messages and can also listen to input XML messages. Real Time Job means, some message with content will trigger the Job or Dataflow processing. A RealTime Job is started once and keeps running basically for ever. So Data Services acts like a server process.

Error Handling, Recoverability are the important aspects of any ETL tool. Some of the ETL tools have some sort of in-built error-handling and automatic recovery mechanisms in place.

A proper data reconciliation process must be in place in any data Extraction-Transformation-Load (ETL) process. A successful reconciliation process should only indicate whether or not the data is correct. But data reconciliation is not easy. Fortunately for us, Data Services (BODS) provides an in-built data reconciliation feature called Auditing. Auditing is a way to ensure that a dataflow loads correct data into the target warehouse. Let's see how...

We can create our own functions by writing script functions in SAP Data Services scripting language using the smart editor. User-script functions return a value.

We can use the Data Services Scripting Language to write scripts and custom functions to address complex logical expressions.

In this article, we will learn how to implement RANK and DENSE RANK operations on GROUP in SAP Data Services.

In this article, we will learn how to implement DENSE RANK operation in SAP Data Services.

In this article, we will learn how to implement RANK operation in SAP Data Services.

In this tutorial we will learn how to implement Cumulative Sum in SAP Data Services (BODS). Since there is no available in-built Analytic Functions in SAP Data Services, we will achieve the end result by exploiting some in-built Data Services features. Also this tutorial will show us how to manipulate Data Flow Parameter values at Data Flow level itself by using the trick of Custom Function calls.

In this tutorial we will learn how to implement Slowly Changing Dimension of Type 3 using SAP Data Services. SCD type 3 design is used to store partial history. Here we are only interested to maintain the "current value" and "previous value" of an attribute. That is, even though the value of that attribute may change numerous times, at any time we are only concerned about its current and previous values.

This tutorial teaches you how to use the "History Preserving Transform" in SAP Data Services (BODS) by demonstrating a practical use of this transform for the implementation of SCD Type 2. We have also provided hands-on video below so that you can see how to do it yourself.

In this tutorial we will learn a new SAP Data services transform, known as Table Comparison Transform and we will see how we may use this transform to implement "slowly changing dimension" (SCD) Type - I. Like before, we have added a video tutorial at the end to perform a little hands-on.

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.