Application Service Guide > Test Data Warehouse Service > Test Data Warehouse Service Properties
  

Test Data Warehouse Service Properties

To view the Test Data Manager Service properties, select the service in the Domain Navigator and click the Properties view. You can configure the following Test Data Warehouse Service properties:

General Properties

The following table describes the general properties for the service:
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.

Test Data Warehouse Repository Configuration Properties

The following table describes the test data warehouse repository configuration properties for the service:
Property
Description
Repository Name
Name of the test data warehouse repository.
Database Type
Type of database for the test data warehouse repository.
  • - Oracle
  • - Microsoft SQL Server
  • - DB2
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>;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
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.

Test Data Warehouse Properties

The following table describes the test data warehouse properties for the service:
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 to use as the test data warehouse.
Target Connection
The database connection to use as the test data warehouse.

Test Data Warehouse Server Configuration Properties

The following table describes the test data warehouse server configuration properties for the service:
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.