Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Test Data Management 10.5.2
  • All Products

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

Back Next

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!