Skip to Content
Author's profile photo Louis de Gouveia

Data Services 4.2 Workbench

A while ago I posted about the new Data Services 4.2 features. The post can be found here Data Services 4.2 What’s New Overview

There is obviously several new features. But one of the new features that SAP will add more and more features to with each release will be the workbench.

In Data Services 4.1 the workbench was first released but had limited functionality. I posted about 4,1 workbench in Data Services Workbench Part 1 and Data Services Workbench Part 2 .

In 4.2 SAP has extended the Workbench functionality. This blog will focus more on the new functionality.

One of the biggest changes would be that you can now design the dataflow in the workbench, the first release did not have this functionality yet. In comparison with Data Services Designer the concept is to be able to do most of the dataflow in one window. So in this version when you click on the query transform all the mapping will be shown in the below windows. This is illustrated in Figure 1 below.

DS 4.2 Eclipse.jpg

Figure 1

Unfortunately not all transforms are available yet in the workbench. Figure shows the transforms that are available in the workbench with this version.

DS 4.2 Transforms.jpg

Figure 2

Nice little feature I noticed was that when you click on a column it shows the path of where that column came from. This could be very handy for complex dataflows.

DS 4.3.jpg

Figure 3

As shown in figure 4, you can now go to advanced editor when doing your mappings if needed. The functions have been also arranged in a similar manner as in Information Steward.

DS 4.2 Functions.jpg

Figure 4

The workbench makes us of projects still. However in the workbench the projects shows everything related. So in the below example it shows the Data Store called STSSouthEastDemo, also shows two dataflows. Can also create folders to arrange contentDS 4.2 Project Explorer.jpg

Figure 5

As shown in figure 6 below the log is slightly different, shown in a table, but still shows the same info.

DS 4.2 Log.jpg

Figure 6

In Data Services you have always been able to view the data. But now that the workbench is using the eclipse based shell in we can then view data as other eclipsed based sap products. Figure 7 illustrates this. You will notice this has same look as feel as hana studio and as IDT. This unfortunately doesnt allow you to view two tables of data next to each other like, a feature that is available in the designer and is useful.

DS 4.2 DisplayData.jpg

Figure 7

So I have shown you some of the new features in the workbench. Many of them being the replication of the Data Services Designer but into the eclipse look and feel, in some instances some new little features or end user experience improvements.

But I’m still missing a lot before I will switch from the Designer to the workbench.

Here is a list of what is missing

  • No workflows, so cant link multiple dataflows to make one workflow.
  • No Jobs. Every dataflow is basically creates a job in the background. So limits how many dataflows and workflows you can string together.
  • No debug, break point options
  • No scripts yet
  • Not all the transforms are available yet
  • No cobol support, excel or xml yet

For more information follow me on twitter @louisdegouveia

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Tammy Powlas
      Tammy Powlas

      Very good summary, Louis

      I have not tried the workbench - I am still using the Designer

      Thank you for sharing

      Author's profile photo Nirav Gandhi
      Nirav Gandhi

      Good article Louis....thanks for sharing new info....