Create a reference mapping - Connect_CDC - aws_mainframe_modernization_service - connect_cdc_mimix_share - 6.x

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
6.x
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last updated
2024-10-15
Published on
2024-10-15T20:38:41.117981

Reference mappings are a way to define target table mapping at one server that are exactly the same as the target table mappings at another server.

Once the Mapping tab manual mapping is complete, you create a reference mapping by using the following steps at each target server that will be referring to an existing table mapping.

Note: The target server for which you are creating a reference mapping must have the same DBMS and table and column names as the server and tables you reference, and the definition of the server must be complete in the Connect CDC Director.
  1. Select Create Reference Mappings from the Server context menu.

  2. From the target server list box to the left, select the target server that contains the table mapping you want to reference.

    Once you select one of the listed target servers, the box to the right displays all the available mappings to tables at this server.

  3. Select the table mapping to reference from the table mappings list box, to the right.

    You may select multiple mappings, select All to select all the table mappings displayed for a given target server.

  4. Click OK.

    A message box displays the number of reference mappings added and replaced, and the Connect CDC Director automatically updates the necessary model entities.

    Your reference mapping displays in the Receiving Tables branch of this target server, in the Target Tables branch of the referenced source server. The name of the referenced server is shown in square brackets.

  5. To create a reference mapping for other targets, repeat the preceding steps for each one. This example demonstrates only a single mapping by reference.

Note the following when working with a reference mapping

  • You cannot modify a reference mapping once it is created, other than by recreating it. However, if a table mapping to which your reference mapping refers is changed, the changes are propagated automatically to your reference mappings.

  • You cannot reference another reference mapping.