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 Warehouse Service

Creating the Test Data Warehouse Service

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

    Model Repository Service

    Data Integration Service

    PowerCenter Repository Service

    PowerCenter Integration Service

  1. In the Administrator tool, click the
    Manage
    tab.
  2. Click the
    Services and Nodes
    view.
  3. Click
    Actions
    New
    Test Data Warehouse Sevice
    .
    The
    New Test Data Warehouse Service
    dialog box appears.
  4. On the
    New Test Data Warehouse Service - Step 1 of 4
    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
    .
    The
    New Test Data Warehouse Service - Step 2 of 4
    page appears.
  6. Enter the following properties for the test data warehouse repository database:
    Property
    Description
    Repository Name
    Name of the test data warehouse repository.
    Database Type
    The type of database for the test data warehouse repository.
    • Oracle
    • Microsoft SQL Server
    • DB2
    • PostgreSQL
    User Name
    User account for the test data warehouse repository database. Set up this account using the appropriate database client tools.
    Password
    Password for the test data warehouse repository database user. Must be in 7-bit ASCII.
    JDBC URL
    JDBC connection URL used to access the test data warehouse repository database.
    Enter the JDBC URL in one of the following formats:
    • Oracle:
      jdbc:informatica:oracle://<host name>:<port>;SID=<database name>
    • IBM DB2:
      jdbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>
    • Microsoft SQL Server:
      jdbc:informatica:sqlserver://<host name>:<port>;SelectMethod=cursor;DatabaseName=<database name>
    • PostgreSQL:
      jdbc:Informatica:postgresql://<host name>:<port number>;DatabaseName=<database name>
    Schema Name
    Available for Microsoft SQL Server. Optional. 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.
    Content creation options for the new Test Data Warehouse 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.
    • Create new content. Creates repository content.
    Choose to create new content.
  7. Choose to enable the Test Data Warehouse Service.
  8. Click
    Next
    .
    The
    New Test Data Warehouse Service - Step 3 of 4
    page appears.
  9. Enter the following properties for the test data warehouse database:
    Property
    Description
    Test Data Warehouse Name
    Name of the test data warehouse.
    Description
    Description of the test data warehouse. The description cannot exceed 765 characters.
    Connection Type
    The type of connection for the test data warehouse.
    • Oracle
    • ODBC
    Target Connection
    The database connection to use as the test data warehouse.
    Connection Database Type
    The type of database for the test data warehouse. Required if you choose the ODBC connection type.
    • PostgreSQL
    JDBC Connection for ODBC
    The connection that the ODBC test data warehouse uses for the JDBC connection string.
    Staging Schema
    The schema to use for creation of staging tables. Some jobs that you run from the self-service portal require a staging connection for staging tables. The test data warehouse connection must have access to the schema.
  10. Select the required connection from the list of target connections.
  11. Click
    Next
    .
    The
    New Test Data Warehouse Service - Step 4 of 4
    page appears.
  12. Enter the following properties for the test data warehouse server configuration:
    Property
    Description
    HTTP Port
    Port number of the Test Data Warehouse Service. The default is 7705.
    Enable Transport Layer Security (TLS)
    Secures communication between the Test Data Warehouse Service and the domain.
    HTTPS Port
    Port number for the HTTPS connection.
    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 warehouse. 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.
    JVM Params
    The heap size allocated for the Test Data Warehouse Service processes.
    - Xms256m -Xmx512m -XX:MaxMetaspaceSize=256m
    The time after which database connections are renewed if the Test Data Warehouse Service remains idle. Required if you modified the database configuration settings to values less than the test data warehouse defaults.
    Configure the following test data warehouse values 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.
  13. Click
    Finish
    .
    The domain creates the Test Data Warehouse Service, starts the service, and creates content for the test data warehouse repository.

0 COMMENTS

We’d like to hear from you!