Table of Contents

Search

  1. Preface
  2. Analyst Service
  3. Content Management Service
  4. Data Integration Service
  5. Data Integration Service Architecture
  6. Data Integration Service Management
  7. Data Integration Service Grid
  8. Data Integration Service Applications
  9. Metadata Manager Service
  10. Model Repository Service
  11. PowerCenter Integration Service
  12. PowerCenter Integration Service Architecture
  13. High Availability for the PowerCenter Integration Service
  14. PowerCenter Repository Service
  15. PowerCenter Repository Management
  16. PowerExchange Listener Service
  17. PowerExchange Logger Service
  18. SAP BW Service
  19. Search Service
  20. System Services
  21. Test Data Manager Service
  22. Web Services Hub
  23. Application Service Upgrade
  24. Application Service Databases
  25. Connecting to Databases from Windows
  26. Connecting to Databases from UNIX
  27. Updating the DynamicSections Parameter of a DB2 Database
  28. Reporting Service (Deprecated)
  29. Reporting and Dashboards Service (Deprecated)

Creating the Test Data Manager Service

Creating the Test Data Manager Service

Log in to the Administrator tool to create the Test Data Manager Service. You can also create the Test Data Manager Service using the TDM command line program.
  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 that the Test Data Manager Service uses to connect to the Model Repository Service.
    Password
    The password that the Test Data Manager Service uses to connect to the Model Repository Service.
    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
    • Custom. Select this option to use custom database drivers instead of the Informatica database drivers.
    If you select Custom, you must save the JDBC driver JAR to the following locations:
    • <INFA_HOME>/tomcat/endorsed
      . If the
      endorsed
      folder does not exist, create the folder. Restart the domain after you copy the JAR.
    • <INFA_HOME>/TDM/lib
      .
    • <INFA_HOME>/TDM/offline/lib
      .
    • <INFA_HOME>/services/TDMService
      .
    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. Set up this account using the appropriate database client tools. To apply changes, restart the Test Data Manager Service.
    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: jdbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>
    • Microsoft SQL Server: jdbc:informatica:sqlserver://<host name>:<port>;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. 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.
  9. Select the required content creation option.
    • If no content exists, select
      Create new content
      . You cannot select this option if the database has content.
    • If the database content exists, select
      Do not create new content
      . If you entered a different name for the Test Data Manager Service, you are prompted to enter the name of the previous Test Data Manager Service. The application checks the version of the content. If the content is of a previous version, an option to upgrade the repository content appears. Upgrade the repository content. Creating the service without upgrading the content to the current version generates a warning.
  10. Enable the Test Data Manager Service, and click
    Next
    .
  11. 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.
  12. Click
    Next
    .
  13. 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.