In Part 1 and Part 2 I focused on content created by the Data Services Workbench wizard.
Now we all know that a wizard does not always compensate for the more complex scenarios, or sometimes we just prefer to create content without the wizard.
So this blog i’m going to focus how you can create content more manually.
I have the same project created with the wizard open, we will add extra tables manually and map them.
By double clicking on the source datastore it will display tables that are made available.
We can now add additional tables by pressing the import object button
Now the tables is added to the source datastore. Save the settings.
You can now add the replication job, you will see that on the left window the new table added does not have a green tick, this means it is not being used.
You can drag the table from the left window to the right window.
By clicking on the table on the right you can then see a window that displays all teh properties for that table. From here you can magae several things
- Add/Remove Columns
- Create Primary Keys
- Create Indexes
- Apply Filters
- Control how data is loaded, full or delta. etc.
On the columns tab I have added a column and provide it a name.
Once the column is created you can map the column or provide a formula. By clicking on the edit button you will open the advanced formula editor.
You will notice that the advanced editor looks similar to the editor we first saw in information steward 4.0. From here we can add the formula, for my purposes I have said Sales-Cost in order to calculate profit. Can also validate.
Then save the work, then press execute.
Will then ask you what repository you would like to execute against. Select one and say next
You can then set further settings. We will keep it on initial load.
The job will then execute. You will then also be able to view load status by table.
When you then view the data you will notice that the table loaded all columns plus the additional one added.
That is how one manually add tables to be replicated.
For more info follow me on twitter @louisdegouveia 🙂