Table of Contents

Search

  1. Preface
  2. Getting started with PowerCenter modernization
  3. Repository Assessment
  4. Asset Conversion
  5. Bulk Metadata Update
  6. Jobs
  7. Configurations

PowerCenter Modernization

PowerCenter Modernization

Creating a connection map configuration

Creating a connection map configuration

Create a Connection Map configuration to map the PowerCenter connections to IDMC connections.
The Connection Map configuration is associated with a domain and a repository. This configuration contains connection types and connection names used in the assessed repository. If you want to repoint the assets to a new endpoint, map these connections to relevant IDMC connections.
  1. On the left navigation menu, click
    New
    .
    The
    New Asset
    dialog box appears.
  2. Click
    Configuration
    , and then click
    Create
    .
    The
    New Configuration
    page appears.
  3. From the
    Configuration Type
    list, select
    Connection Map
    .
  4. Enter the required information as shown in the following table:
    Property
    Description
    Task Name
    Name of the configuration.
    Description
    (Optional) Description of the configuration.
    Domain
    The domain where you want to use this configuration.
    The list of repositories within the selected domain appears in the
    Repository
    field.
    Repository
    Repository where you want to use this configuration.
    Make sure that the selected repository is assessed.
  5. Click
    Next
    .
    On the
    Set Properties
    tab, the
    Connection Map Configuration
    section displays the list of PowerCenter connections used in the repository. You can filter the connections based on a PowerCenter connection type.
  6. In the
    Cloud Connection Type
    and
    Cloud Connection Name
    columns, select the IDMC connection type and connection name of the endpoint to which you want to repoint the assets.
  7. In the
    Transformation
    column, select the transformations where you want to use this repoint.
    You can use the following transformations for a repoint:
    • Source
    • Target
    • Lookup Transformation
    • SQL Transformation
    • Stored Procedure Transformation
  8. If you want to configure additional properties for the repoint, click
    Set Properties
    in the
    Advanced Properties
    column.
  9. Click
    Save Configuration
    .
    The configuration is saved. You can use this configuration in conversion tasks.

0 COMMENTS

We’d like to hear from you!