Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Implementing Data Masking and Data Subset with Sequential or VSAM Sources

Implementing Data Masking and Data Subset with Sequential or VSAM Sources

Implementing Data Masking and Data Subset with Sequential or VSAM Sources

Step 5. Import PowerExchange Source Definitions into PowerCenter

Step 5. Import PowerExchange Source Definitions into PowerCenter

When you import source definitions into PowerCenter, they become available for import into the TDM Workbench.
After you connect to a source database from PowerCenter, you can import source metadata into the PowerCenter repository. You must create a folder in the PowerCenter repository to store source definitions and metadata that you import into the PowerCenter repository. When you import metadata from PowerCenter into the TDM repository, the TDM Workbench creates a copy of the PowerCenter folder in the TDM repository.
You do not need to import PowerExchange target definitions into PowerCenter. When you generate a workflow from the TDM Workbench, the required target definitions are generated automatically.
Persistent Data Masking and Data Subset 9.5.1 and 9.5.2 do not support importing multiple records at a time from sequential or VSAM data sources with multiple-record data maps. You can include only one record and table per source definition.
  1. In the PowerCenter Designer, connect to a PowerCenter repository.
  2. Create a folder for the source that you are importing.
  3. Click
    Sources > Import from PowerExchange
    .
  4. Enter the following information in the dialog box:
    Attribute
    Required/
    Optional
    Description
    Location
    Required
    Name of the PowerExchange Listener (node name from PowerExchange dbmover.cfg) on the system on which the database resides.
    User Name
    Required
    User name for the database to connect to.
    Password
    Required
    Password associated with the user name.
    Multi-Record Datamaps
    Optional
    Clear this option. You can import only a single record and table per source definition for data subset and masking operations.
    Use Sequence Fields
    Optional
    Clear this option. This option applies only to multi-record data maps.
    Source Type
    Required
    Select
    SEQ
    or
    VSAM
    .
    CDC Datamaps
    n/a
    Clear this check box.
    Network Timeout
    Optional
    Number of seconds that elapse during a network send or receive operation before PowerExchange ends the connection and issues a timeout error message.
    Schema
    Optional
    Enter a schema name to filter the resulting data maps.
    Map name
    Optional
    Enter a data map name to filter the resulting data maps.
    Respect Case
    Optional
    If this attribute is selected, PowerExchange filters data maps by using the exact case of the Schema and Map name fields. Otherwise, PowerExchange ignores the case when searching for data maps.
    Selected Datamaps
    n/a
    Lists the available data maps for the connection, source type, and filter details that you entered.
  5. Optionally, enter a filter to view particular schemas and tables from the database.
    You can also enter a filter condition to display schemas and tables that meet the filter condition. To use a filter condition, enter a schema name in
    Schema
    , a table name in
    Map name
    , or enter both values.
  6. Click
    Connect
    .
    The available schemas appear in the
    Selected Datamaps
    list.
  7. Expand the schema to display all the tables for all the data maps in the schema, and select the tables that you want to import. You can import multiple tables from a single data map or from multiple data maps.
  8. Click
    OK
    .
    The source definitions appear. The PowerCenter source is named
    mapname
    _
    tablename
    .


Updated October 18, 2019