Enhancing Synonyms With ERwin Metadata

How to:

Once relational synonyms have been created and ERwin has been added to the list of configured adapters, you can enhance the existing synonyms with ERwin metadata.


Top of page

x
Procedure: How to Enhance Synonyms With ERwin Metadata
  1. Open the Applications pane and select a synonym that has been created for one of the supported relational data sources:
    • DB2
    • Informix
    • Ingres
    • MS SQL Server
    • ODBC/Generic
    • Oracle
    • Progress
    • Redbrick
    • Sybase
    • Teradata
  2. Right-click the synonym and select Refresh Synonym via ERwin, as shown in the following image.

    If business data is available, the synonym Master File will be updated with attributes names, entities, and attributes descriptions. The mapping is as follows:

    ERwin Attribute

    Master File Attribute

    Logical name

    Segment

    Entity description

    Segment description

    Attribute name

    Fieldname

    Note: A blank space in the ERwin model will be replaced with an underscore in the Master File.


iWay Software