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.
When opening the Data Services Workbench you will be prompted for logon details.
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
- 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.
Hope the above gives you a kick introduction into the Data Services Workbench.
For more information follow me on twitter @louisdegouveia