Information Management, SAP Data Services

SAP Data Services performance gain from 3 hours to 30 seconds

A performance gain of 3 hours down to 30 seconds is impressive and what's even more remarkable is that it was only one minor change to an existing dataflow that was responsible for the gain. Recently I had built a Job that was to do the historical data load for a data warehouse. The Job… Continue reading SAP Data Services performance gain from 3 hours to 30 seconds

Business Intelligence, How To, Information Management, SAP Data Services

Automated Unit Testing in SAP Data Services. Part II

The previous article provided an introduction to unit testing in general covering the purpose and benefits of unit testing. This article now looks at a method of unit testing that can be utilised in a SAP DataServices project. First we’ll discuss what objects are candidates for unit testing and then look at how we implement… Continue reading Automated Unit Testing in SAP Data Services. Part II

Business Intelligence, Delivery Methodology, Information Management, SAP Data Services

Automated Unit Testing in SAP Data Services. Part I

Introduction One of the key drivers of this article is that although there are many articles on unit testing in general on internet there are hardly any on unit testing with SAP DataServices. Unit testing has been accepted as a key part of the software development lifecycle for projects building applications in languages such as… Continue reading Automated Unit Testing in SAP Data Services. Part I

Delivery Methodology, Information Management, SAP Data Services

SAP Data Services: 10 Reasons for never using Global Variables (and one where you can)

In software programming it is widely held that using global variables or other constructs to maintain global state is a poor programming practice[1] and many of those reasons can also be applied to development of jobs in SAP Data Services. The following is my list of 10 reasons for why you should never use global… Continue reading SAP Data Services: 10 Reasons for never using Global Variables (and one where you can)