Skip to Content
Author's profile photo Louis de Gouveia

Data Services Workbench Part 2

In Part 1 of my blog which can be found here I focused on how to create content with the wizard. Today I’m going to focus on what did that wizard create.

So once you have logged in again this will be the first screen you see. You can just click the welcome tab closed.


Once you have done that you will have a project explorer view. Note that the look and feel of all new tools are being delivered in the eclipse base look and feel shell. Similar to Information Design Tool and Design Studio (AKA ZEN).

Project Explorer.jpg

The project explorer will have a project, the name of the project we defined in the first step of the wizard. Then it has created two datastores, one for a source and one for a target. Once again we defined this in the wizard and is the same thing as a datastore in Data Services. Then there is a “Workbench_Example.rep”, this is new but basically has all the mappings of which tables we want to replicate.

Project Explorer Detail.jpg

So now let’s have a look at what the workbench has done in the background. If we log into SAP BusinessObjects Data Services you will see a new project, a new job with workflows and dataflows. Also datastores created. You will notice all the names and settings match what we used in the workbench.

Data Services.jpg

If we look at the detail you will notice it has done the following.

  • Created a script to create all the tables. Uses SQL to create the tables.
  • Created one dataflow per table.
  • Created a script that creates all indexes on the table, also creates a load status table.

Project Details.jpg

So as one can see everything done in the workbench creates the content for you in Data Services, so the workbench is the new front end SAP is trying to make that will be easier to work with and will rapidly decrease deployment time.

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 Deepak K Gupta
      Deepak K Gupta

      Hello ,

      Help me to understand this, this DS Work Bench feature is nothing but help you to work all aspects collectively.

      if yes, why do we have other components also in place after installing DS ?


      Author's profile photo Louis de Gouveia
      Louis de Gouveia
      Blog Post Author


      The workbench over time will be the new GUI instead of Data Services Designer. Over time more features will be added and will make it easier to design. Currently not all the features exist in the workbench.

      Hope this helps.