Data Services Workbench Part 2
In Part 1 of my blog which can be found here http://t.co/WMIlAIpR 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).
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.
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.
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.
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