Table of Contents

Search

  1. About the Test Data Management Configuration Guide
  2. Test Data Management Configuration Overview
  3. Before You Configure Test Data Management
  4. Prepare for Application Services and Databases
  5. Create the Application Services
  6. Configure Test Data Management
  7. Starting and Stopping Informatica Services
  8. Appendix A: Infacmd

Configuration Guide

Configuration Guide

Creating the Test Data Manager Service

Creating the Test Data Manager Service

Use the service creation wizard in the Administrator tool to create the service.
Before you create the Test Data Manager Service, verify that you have created the following services:

    Model Repository Service

    Data Integration Service

    PowerCenter Repository Service

    PowerCenter Integration Service

    Test Data Warehouse Service

  1. In the Administrator tool, click the
    Manage
    tab.
  2. Click the
    Services and Nodes
    view.
  3. Click
    Actions
    New
    Test Data Manager Service
    .
    The
    New Test Data Manager Service
    dialog box appears.
  4. On the
    New Test Data Manager Service - Step 1 of 5
    page, enter the following properties:
    Property
    Description
    Name
    Name of the service. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters or begin with @. It also cannot contain spaces or the following special characters:
    ` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [
    You cannot change the name of the service after you create it.
    Description
    Description of the service. The description cannot exceed 765 characters.
    Location
    Domain and folder where the service is created. Click
    Browse
    to choose a different folder. You can move the service after you create it.
    License
    License object that allows use of the service.
    Node
    Node on which the service runs.
  5. Click
    Next
    .
  6. On the
    New Test Data Manager Service - Step 2 of 5
    page, enter the following properties:
    Property
    Description
    PowerCenter Repository Service
    The PowerCenter Repository Service that the Test Data Manager Service uses to load metadata into the TDM repository.
    PowerCenter Integration Service
    The PowerCenter Integration Service that runs the workflows that you generate in Test Data Manager for TDM operations.
    Model Repository Service
    The Model Repository Service associated with the Test Data Manager Service.
    User Name
    The user name of the Model repository database.
    Password
    The password of the Model repository database user.
    Security Domain
    The name of the security domain that the user belongs to. Select the security domain from the list.
    Data Integration Service
    The Data Integration Service associated with the Test Data Manager Service.
    The Data Integration Service runs the workflows that you generate when you perform data discovery operations in Test Data Manager.
    If you have enabled profiling, or if you use Hadoop connections, you must select the Data Integration Service in the domain.
    Analyst Service
    The Analyst Service associated with the Test Data Manager Service.
    The Analyst Service connects to the Analyst tool, a flat file cache directory to store uploaded flat files and a business glossary export file directory.
    Required if you want to link TDM global objects to Business Glossary assets.
    Test Data Warehouse Service
    The Test Data Warehouse Service associated with the Test Data Manager Service.
    The Test Data Warehouse Service manages the test data warehouse repository.
    Required if you want to create and store data sets in the test data warehouse.
  7. Enable data profiling to perform data discovery tasks in TDM, and click
    Next
    .
  8. On the
    New Test Data Manager Service - Step 3 of 5
    page, enter the following properties:
    The repository connection information must be valid for the service to work.
    Property
    Description
    Database Type
    Type of database for the TDM repository.
    • Oracle
    • Microsoft SQL Server
    • DB2
    • PostgreSQL
    If you use a Microsoft SQL Server database, you must set the collation to
    case insensitive
    on the database.
    Use Trusted Connection
    Available for Microsoft SQL Server. Select this if you want to log in using Windows login credentials.
    Custom Driver Class
    Custom JDBC parameters. Required if you select Custom database type. Enter the custom JDBC driver parameters.
    Username
    User account for the TDM repository database.
    Password
    Password for the TDM repository database. Must be in 7-bit ASCII. To apply changes, restart the Test Data Manager Service.
    JDBC URL
    JDBC connection URL used to access the TDM repository database.
    Enter the JDBC URL in the following format:
    • Oracle:
      jdbc:informatica:oracle://<host name>:<port>;ServiceName=<service name>
    • IBM DB2: j
      dbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>
    • Microsoft SQL Server:
      jdbc:informatica:sqlserver://<host name>:<port>;DatabaseName=<database name>
    • PostgreSQL:
      jdbc:Informatica:postgresql://<host name>:<port number>;DatabaseName=<database name>
    Connection String
    Native connect string to the TDM repository database. The Test Data Manager Service uses the connect string to create a connection object to the TDM repository and the PowerCenter repository or Model repository. To apply changes, restart the Test Data Manager Service.
    Schema Name
    Available for Microsoft SQL Server. Name of the schema for the database. If not selected, the service creates the tables in the default schema.
    Tablespace Name
    Available for DB2. Name of the tablespace in which to create the tables. You must define the tablespace on a single node and the page size must be 32 KB. In a multipartition database, you must select this option. In a single-partition database, if you do not select this option, the installer creates the tables in the default tablespace.
    Creation options for the New Test Data Manager Service
    Options to create content, or use existing content, and upgrade existing content.
    • Do not create new content. Creates the repository without creating content. Select this option if the database content exists. If the content is of a previous version, the service prompts you to upgrade the content to the current version.
      • Previous Test Data Manager Service Name: Enter the name of the previous Test Data Manager Service. Required if you create the service with a different name.
        If you create the Test Data Manager Service with a different name, the source and target connections do not appear in Test Data Manager. Import the connections again if the connections do not appear in Test Data Manager.
      • Upgrade TDM Repository Contents. Upgrades the content to the current version.
    • Create new content. Creates repository content.
    Choose to create new content.
  9. Enable the Test Data Manager Service, and click
    Next
    .
  10. On the
    New Test Data Manager Service - Step 4 of 5
    page, enter the following properties:
    Property
    Description
    HTTP Port
    Port number that TDM runs on. The default is 6605.
    Enable Transport Layer Security (TLS)
    Secures communication between the Test Data Manager Service and the domain.
    HTTPS Port
    Port number for the HTTPS connection. The default is 6643.
    Keystore File
    Path and file name of the keystore file. The keystore file contains the keys and certificates required if you use the SSL security protocol with the Test Data Manager application. Required if you select Enable Transport Layer Security.
    Keystore Password
    Password for the keystore file. Required if you select Enable Secured Socket Layer.
    SSL Protocol
    Secure Sockets Layer protocol to use. Default is TLS.
  11. Click
    Next
    .
  12. On the
    New Test Data Manager Service - Step 5 of 5
    page, enter the following properties:
    Property
    Description
    JVM Params
    The heap size allocated for Test Data Manager.
    - Xms512m - Xmx1024m -XX:MaxPermSize=512m
    The time after which database connections are renewed if the Test Data Manager remains idle. Required if you modified the database configuration settings to values less than the TDM defaults. Configure the following values in TDM to be less than the database values.
    • IDLE_TIME.
      -DIDLE_TIME=<seconds>
      . Default is 300 seconds.
    • CONNECT_TIME.
      -DCONNECT_TIME=<seconds>
      . Default is 5000 seconds.
    Connection Pool Size
    The JDBC connection pool size.
    JMX Port
    Port number for the JMX/RMI connections to TDM. Default is 6675.
    Shutdown Port
    Port number that controls the server shutdown for TDM. The TDM Server listens for shutdown commands on this port. Default is 6607.

0 COMMENTS

We’d like to hear from you!