Table of Contents

Search

  1. Preface
  2. Prepare to Install Data Validation Option
  3. Install Data Validation Option
  4. Configure Data Validation Option
  5. Configuring Multiple Environments
  6. Upgrade Data Validation Option
  7. Install DVOcmd on UNIX
  8. Appendix A: Installation and Configuration Checklist

Data Validation Option Installation and Configuration Guide

Data Validation Option Installation and Configuration Guide

Add the PowerCenter Repository

Add the PowerCenter Repository

You must add a PowerCenter repository and designate one repository folder to store Data Validation Option mappings, sessions, and workflows. Optionally, you can integrate Metadata Manager to view additional metadata about data sources.
  1. Open the Data Validation Client.
  2. Right-click
    INFA Repositories
    in the Navigator, and select
    Add Repository
    .
    The
    Repository Editor
    dialog box appears.
    The Repository Editor dialog box shows the connection properties for a PowerCenter repository. If the PowerCenter repository is for Data Validation Option objects, you can specify the target folder, PowerCenter Integration Service, and the connection to the Data Validation Option repository. You can also configure the connection to Metadata Manager if you installed Metadata Manager.
  3. Enter the following PowerCenter connection properties:
    Property
    Description
    Name
    Logical name of the PowerCenter repository for Data Validation Option. This name appears in the Navigator pane of the Data Validation Client.
    If this is the repository that contains the target folder, append “target” to the name.
    Client Location
    Location of the pmrep.exe file on the PowerCenter Client machine. For example:
    C:\Informatica\<version>\clients\PowerCenterClient\client\bin
    .
    PowerCenter Version
    The PowerCenter version that runs Data Validation Option.
    PowerCenter Domain
    Name of the Informatica domain.
    If PowerCenter uses Kerberos authentication, the user name and password text boxes become unavailable when you enter the name of the domain.
    Repository
    Name of the PowerCenter repository for Data Validation Option that is defined in the Informatica domain.
    User name
    User name for the PowerCenter repository. The text box is unavailable if PowerCenter uses Kerberos authentication.
    Password
    User password for the PowerCenter repository. The text box is unavailable if PowerCenter uses Kerberos authentication.
    Security Domain
    Security domain for the PowerCenter user. Specify the name of the LDAP security domain. Leave this property blank if you use native authentication.
  4. If the PowerCenter repository that you entered contains the target folder for the data validation metadata, enter the following target repository properties:
    Property
    Description
    Contains Target Folder
    Indicator that determines whether this repository contains the target folder to store Data Validation Option mappings, sessions, and workflows. If you add multiple PowerCenter repositories, select this option for one PowerCenter repository. The Data Validation Option can read from multiple PowerCenter repositories, but it can create objects in only one PowerCenter repository.
    Target Folder
    Name of the target folder that stores Data Validation Option mappings, sessions, and workflows.
    Integration Service
    Name of the PowerCenter Integration Service that runs the Data Validation Option workflows.
    Data Validation Repository Connection
    Name of the repository connection that you created in the PowerCenter Workflow Manager.
  5. If you are integrating Data Validation Option with Metadata Manager, enter the following Metadata Manager properties.
    Property
    Description
    Enable Metadata Manager
    Select to integrate Data Validation Option with the Metadata Manager Service.
    Is secure connection
    Indicator that determines whether the Metadata Manager Service runs over a secure connection.
    Server Host Name
    Host name of the machine on which the Metadata Manager Service runs.
    Server Port
    Port of the Metadata Manager Service.
    Resource Name
    Name of the PowerCenter resource created in Metadata Manager.
  6. Click
    Test
    to test the connection to the PowerCenter repository.
  7. Click
    Save
    .
  8. Click
    OK
    to import the list of folders and connections from the PowerCenter repository into the Data Validation Client.

0 COMMENTS

We’d like to hear from you!