Exercise 2.2 - Source System Metadata and Target Interface

Modified on Fri, 13 Oct 2023 at 06:23 PM

In this exercise, you will verify that you have imported the Source System metadata necessary for the Business Object Card. Afterwards you will import the Target interface you have published from the Target Map in the previous exercise.


In other words, you have lined up the task ahead of you (assign values to the fields of the Target interface) and assured that you have the metadata required for the job imported from the Source System.


Open the Workshop Source Map

  • Open Studio and click the Open buttonin the Toolbar
  • Locate and open the file Documents\MigFx\Mapping\Workshop\Source\Workshop.migsrc


Import Source System Metadata

In fact, we are cheating a little bit here, because the Source System metadata for the Card related structure (named DebitCard) in the Source System has already been imported as part of the Source System metadata, but it is marked with the Usage Skip. You can see that for yourself if you open the item Metadata/SourceStructure

The 3 different Usage types (Active, Inactive and Skip) relate in part to what is happening down the line. The Usage Active means that you can use the metadata structure in the mapping. The Usages Inactive and Skip determine whether a staging table for the structure will be created or not:


Skip
A table corresponding to the structure will not be created in the staging database and you cannot use this structure in the Source Map at all
Inactive
A table corresponding to the structure will be created in the staging database but you still cannot use this structure in the Source Map

This comes in handy because you can then load the data from the Source System into the staging table and thus be able to analyze the data with the powerful aid of SQL. If you then decide you need this structure in the Source Map, you can just change the Usage to Active
Active
A table corresponding to the structure will be created in the staging database and you can use this structure in the mapping.

However, if a structure is marked Active, and you do not use it anywhere in the mapping, the Studio validation will mark that as an error: You said you needed the structure, but you are not using it anywhere


All you need to do in this part of the exercise is to 

  • check out the Metadata/SourceStructure item 
  • and change the Usage from Skip to Active for the structure DebitCard
  • Save and Check-in 
    • If you cannot check in, you probably forgot to add the Source Map to Repository in Exercise 0.2). If so - not to worry, you can just do it now by clicking the Add to Repository buttonin the toolbar.

Import the Target interface published from the Target Map

Next thing is to import the Target interface that you have just published from the Target Map in the previous exercise. However, before doing that have a look in the Project Explorer tree view:

The Card Business Object you have been working on is not there, only the Customer and Account Business Objects that have already been worked on by you and your teammates in earlier stages of the migration project.


In order to import the new Target interface, you must first open and check out the Source Map itself. This is the top-most root node in the Project Explorer tree view: Workshop. When you Check out, you will be presented with a dialog that by default will check out the root Workshop node and all its descendants. Uncheck as necessary to only check out the root node itself - nothing else.



Once opened and checked out, on the Target tab you will notice that the previously imported interface does not include the Card Business Object - neither does the comment on the last import correspond to the one you typed, when you published the Target interface in the previous set of exercises.



Click the Import button to Import the Target interface. When you published the Target interface in the previous exercise, you could choose to either publish to the Repository or to a local folder. Likewise, now you can choose to import the published Target interface from either the Repository or from a local folder.


Choose to import from Repository, click the Browse button, select Workshop in the Project drop-down and finally select the publish you did in the previous exercise.


Clicking the Ok button and afterwards the Import button will import the new Target interface into the Source map. The Card Business Object now appears in the Target tab of the Workshop item, and also in the Project Explorer tree view together with its child CardStatus.


The icons of the 2 new Business Objects are faded because you have not yet worked on the Source mapping and saved anything.


Remember to Save and Check in.


What happened here?


You have now prepared the Workshop Source Map in order to start working on your new Card root Business Object 

  • You have activated the DebitCard structure in the Source System metadata, because you need this structure in order to deliver the Card data to the interface published from the Target Map
  • And you have imported the new version of the Target interface you just published from the Target Map. This version contains the Card Business Object and its child CardStatus.

The following exercises are all about how to satisfy the Target interface using the Source structures available in the SourceStructure metadata.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article