Skip to Content

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..

DSWorkBenchAfterLogin.jpg

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

Wizzard1.jpg

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

  • Database
  • SAP Applications
  • SAP BW Source

Source1.jpg

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

SourceDB.jpg

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.

DW_Source.jpg

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.

DWTables.jpg

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.

Target.jpg

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

Target2.jpg

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

FinalStep.jpg

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

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. 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.

    -deep

    (0) 
  2. mohammed fasiur rahman

    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.

    Thanks

    (0) 
  3. 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:

    Teradata,SYBASE,HANA.

    Can you please suggest me into that.

    Please see the screenshot for the same

    Thanks and Regards,

    Shiva Sahu

    (0) 
      1. 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.

        Regards.

        Santosh.

        (0) 
  4. Ken Guyette

    Louis,

    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.

    Thanks,

    Ken

    (0) 
    1. Louis de Gouveia 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 😉

      (0) 

Leave a Reply