Skip to Content
Author's profile photo Louis de Gouveia

Data Services Workbench Part 1

In this blog I’m going to focus on introducing Data Services Workbench. Will be showing how we can logon and use the wizard to create a simple batch job to load data from a source to a target.

Other blogs will follow where we will focus on other aspects of Data Services Workbench.

Data Services Workbench is new and was released with Data Services 4.1. So in order to use it you will need to install Data Services 4.1.

So after installing Data Services 4.1 SP 1 you will see a new menu item for Data Services Workbench.

DS Workbench Menu.jpg

When opening the Data Services Workbench you will be prompted for logon details.

Logon Screen.jpg

Once you have logged in you will see the below. In this example I’m going to start the replication wizard to show how we can create a simple job to load data from a source to a target..


The wizard starts with the below screen. You need to provide a project name.


We then have to select our source. As shown the following is supported as a source

  • Database
  • SAP Applications
  • SAP BW Source


For this blog I’m going to use a database as a source. As one can see several databases are supported as a source.


You will need to enter all your connection details once selecting your database, in my example I will be using MS SQL 2008 as my source. The connection details are similar as when creating a datastore in Data Services Designer. You can also test the connection.


We then can select all the tables we would like to use, you will have a list of tables to select from. These are tables that are available from the source.


Then you will need to select your target destination. For target destinations only databases are supported. Then not all databases are supported yet, but a good portion to start with.


Will then need to complete the target destination connection details. We can also test the connection.


Then in the final step we can choose whether we want to execute immediately, can also select the job server we want to use.


The monitoring part then comes up and shows execution details. We can see by table the status and that it completed successfully. 

Data Services Work Bench Execute.jpg

Hope the above gives you a kick introduction into the Data Services Workbench.

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 Arne Weitzel
      Arne Weitzel

      Nice new feature, thanks for the blog.

      Author's profile photo Former Member
      Former Member

      Nice new feature, Thanks for sending the BODS 4.0 SP1 

      where can i download SAP BODS 4.0 .. please let me know..

      Author's profile photo Deepak K Gupta
      Deepak K Gupta

      Hello - Just wanted to understand the benifits of DS workbench. per my understanding we can do all the things from previous versions as well.

      I could see that movement has been less now amongst the screens.


      Author's profile photo Former Member
      Former Member

      Hi Deepak,

      Thanks for replay! If i have any doubts for BODS 4.0 then i will send an e-mail..



      Author's profile photo Former Member
      Former Member

      Hi deepak,

      Thanks for replay!..


      Author's profile photo Former Member
      Former Member

      Thanks for sharing information.

      Nice feature...with Wizard execution  concepts....

      But it doesn't describes about transformation details. where can we do those transformations.In this I could find direct scheduling the tables from source to target.

      Can anyone clarifies this.Or would it provide an interface in between the above describe steps.


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


      Have a look at Part 2 and 3 for more detail.


      Author's profile photo shiva sahu
      shiva sahu

      Hi Louis,


      Above given information is really helpful,but i have one doubt here regarding TARGET DATABASE OPTIONS.

      I am Using BODS 4.1 version.

      As over here you have mentioned database names through screen shot are SYBASE IQ , Teradata ,HANA, SQL server ,Sybase ASE ,DB2,Oracle but when i am trying to create target database,only three options are available mentioned below:


      Can you please suggest me into that.

      Please see the screenshot for the same

      Thanks and Regards,

      Shiva Sahu

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


      Update to the latest patch level and the additional targets will display.



      Author's profile photo Santosh Nirmala
      Santosh Nirmala

      We are on BO 14.0. SP4. BODS 14.1 SP1.

      O/S SuSe Linux 11.2

      How can I enable WorkBench for my team to use it? Any default link to check if it is already eanbled? like Hostname/CMC or similar to that.



      Author's profile photo Ken Guyette
      Ken Guyette


      We just upgraded from 4.0 to 4.2 and I am just starting to play around with the Data Service Workbench.  Just had a basic question on the source and target datastore names.

      Is there a way to modify these to match existing datastore names that may already be in your repository.  Through the replication wizard it appears to default the name to projectname_source and projectname_target.

      If we do not execute the replication job immediately and just save it then it appears I can rename the source and target under the Project Explorer panel but when I try to change the name I get the following error (The file extension must be the same as the old file name).

      8-14-2014 11-47-03 AM.png

      It appears that if I double click on the source I can change the name in the properties but it does not change the name shown under the project.  When I deploy the job it still uses the orignal name and not the name listed under the properties. 

      Any thoughts on this would be appreciated.



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

      Hi Ken

      The Data Services Workbench is very young and is on its second release.

      There is a lot of functionality that is in SAP BusinessObjects Data Services Designer that does not exist yet in workbench. For this reason I do all my development still in the Data Services Designer, I only use this when I want certain end users with little experience to have a way to move data around in a controlled environment.

      I have not tried what you are doing, but yes I'm aware that it creates a new connection and doesn't let you select from existing ones in Data Services Designer.

      Hopefully in the next release 😉