Mapping Example For Complex Repository Structure

A complex repository structure where one of the child repositories is related to the parent repository by multiple relationships. Consider the following scenario where four repositories are related to each other:

Customer > Account > Address and Customer > Status > Address

The relationship among these four repositories is as follows:

CustomerAccount, CustomerStatus, AccountAddress, and StatusAddress

Complex Repository Structure

In this scenario, the Address repository is related to the Customer repository by AccountAddress and StatusAddress relationships.

  • Forward Relationship Mapping

    While creating an output map for a parent repository, you can select all forward cross-repository relationships with a common synchronization format or different synchronization formats for different relationships. You can use the same output map from the related repository to be related to the parent repository by two different relationships. In the following scenario, you can use the Address repository to be related with the parent output map in the Customer repository by AccountAddress and StatusAddress relationships.

    Multiple Relationship Mapping for Complex Repository Structure
  • Reverse Relationship Mapping

    You can add a related output map in the reverse relationship. Consider the following scenario: Customer > Address and Account > Address

    For the Customer repository and the CustomerAddress forward relationship, if you create an output map as CustomerOutputMap and the related output map as AddressOutputMap, then for the Address repository, when you select the AccountAddress reverse relationship, you can create the related output map as AccountOutputMap for the AddressOutputMap.

    Tip: While creating related output maps in a complex metadata structure, a relationship either self or cross-repository can be used only once in any given direction, that is, forward and reverse.
    Note: To create and modify output maps and map multiple relationships with the related maps, use TIBCO MDM Studio. Refer to TIBCO MDM Studio Repository Designer User’s Guide.