Skip to Content

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.

StartPoint.jpg

By double clicking on the source datastore it will display tables that are made available.

SourceTables.jpg

We can now add additional tables by pressing the import object button

AddTables.jpg

Now the tables is added to the source datastore. Save the settings.

TableAdded.jpg

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.

ReplicationJob.jpg

You can drag the table from the left window to the right window.

ReplicationTableAdded.jpg

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.

TableProp.jpg

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.

Formula.jpg

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.

AdvancedEditor.jpg

Then save the work, then press execute.

Execute.jpg

Will then ask you what repository you would like to execute against. Select one and say next

Execute1.jpg

You can then set further settings. We will keep it on initial load.

/wp-content/uploads/2013/02/execute2_188647.jpg

The job will then execute. You will then also be able to view load status by table.

ExecuteResults.jpg

When you then view the data you will notice that the table loaded all columns plus the additional one added.

ViewData.jpg

That is how one manually add tables to be replicated.

For more info follow me on twitter @louisdegouveia   🙂

To report this post you need to login first.

1 Comment

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

Leave a Reply