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

CreateService

CreateService

Creates a Test Data Warehouse Service in a domain.
The infacmd tdw CreateService command uses the following syntax:
CreateService <-DomainName|-dn> Domain Name <-ServiceName|-sn> Service Name [<-ServiceDesc|-sd> Service Description] [<-UserName|-un> Username] [<-Password|-pd> Password] [<-SecurityDomain|-sdn> Security Domain] [<-ResilienceTimeout|-re> Timeout Period in seconds] <-NodeName|-nn> Node Name <-LicenseName|-ln> License Name <-RepoName|-rn> Repository Name <-RepoDBType|-rdt> Repository Database Type (ORACLE, DB2, SQLSERVER) <-RepoDBUsername|-rdu> Repository Database User <-RepoDBPassword|-rdp> Repository Database Password <-RepoDBUrl|-rdl> Repository Database Url [<-RepoDbSchema|-rds> Repository Database Schema (used for SQL Server only)] [<-RepoDbTablespace|-rdts> Repository Database Tablespace (used for DB2 only)] <-TDWName| -tdwn> Test Data Warehouse Name [<-TDWDescription| -tdwdesc> Test Data Warehouse Description] <-TDWConnType|-tdwct> Test Data Warehouse Connection Type (ORACLE/ODBC) <-TDWConnName|-tdwcn> Test Data Warehouse Connection Name [<-TDWConnDBType|-tdwcdbt> Test Data Warehouse Connection Database Type (POSTGRESQL)] [<-TDWJDBCConnName|-tdwjdbccn> Test Data Warehouse JDBC Connection Name] <-TDWStagingSchema|-tdwstsc> Test Data Warehouse Staging Schema Name [<-HttpPort> httpPort] [<-HttpsPort> httpsPort] [<-KeystoreFile|-kf> Keystore File Location] [<-KeystorePassword|-kp> Keystore Password] [<-SSLProtocol|-sp> SSL Protocol] [<-jvmParams|-jp> JVM Parameters]
The following table describes infacmd tdw CreateService options and arguments:
Option
Argument
Description
-DomainName
-dn
Domain Name
Required. Name of the Informatica domain. You can set the domain name with the -dn option or the environment variable INFA_DEFAULT_DOMAIN. If you set a domain name with both methods, the -dn option takes precedence.
-ServiceName
-sn
Service Name
Required. Name of the Test Data Warehouse Service.
The name is not case sensitive and must be unique within the domain. The characters must be compatible with the code page of the associated repository. The name cannot exceed 230 characters, have leading or trailing spaces, or contain carriage returns, tabs, or the following characters:
/ * ? < > " |
-ServiceDesc
-sd
Service Description
Description of the service. The description cannot exceed 765 characters.
-UserName
-un
Username
Required if the domain uses Native or LDAP authentication. User name to connect to the domain. You can set the user name with the -un option or the environment variable INFA_DEFAULT_DOMAIN_USER. If you set a user name with both methods, the -un option takes precedence.
Optional if the domain uses Kerberos authentication. To run the command with single sign-on, do not set the user name. If you set the user name, the command runs without single sign-on.
-Password
-pd
Password
Required if you specify the user name. Password for the user name. The password is case sensitive. You can set a password with the -pd option or the environment variable INFA_DEFAULT_DOMAIN_PASSWORD. If you set a password with both methods, the password set with the -pd option takes precedence.
-SecurityDomain
-sdn
Security Domain
Required if the domain uses LDAP authentication. Optional if the domain uses native authentication or Kerberos authentication. Name of the security domain to which the domain user belongs. You can set a security domain with the -sdn option or the environment variable INFA_DEFAULT_SECURITY_DOMAIN. If you set a security domain name with both methods, the -sdn option takes precedence. The security domain name is case sensitive.
If the domain uses native or LDAP authentication, the default is Native. If the domain uses Kerberos authentication, the default is the LDAP security domain created during installation. The name of the security domain is the same as the user realm specified during installation.
-ResilienceTimeout
-re
Timeout Period in seconds
Optional. Amount of time in seconds that infacmd attempts to establish or re-establish a connection to the domain. You can set the resilience timeout period with the -re option or the environment variable INFA_CLIENT_RESILIENCE_TIMEOUT. If you set a the resilience timeout period with both methods, the -re option takes precedence. Default is 180 seconds.
-NodeName
-nn
Node Name
Required. Name of the node where the service will run.
-LicenseName
-ln
License Name
Required. Name of the license. The name is not case sensitive and must be unique within the domain. The name cannot exceed 79 characters, have leading or trailing spaces, or contain carriage returns, tabs, or the following characters:
/ * ? < > " |
-RepoName
-rn
Repository Name
Required. Name of the test data warehouse repository.
-RepoDBType
-rdt
Database Type
Required. Type of database for the test data warehouse repository. Values are Oracle, SQL Server, or DB2.
-RepoDBUsername
-rdu
Repository Database User
Required. Account for the repository database. Use the database client to set up this account.
-RepoDBPassword
-rdp
Repository Database Password
Required. Repository database password for the database user.
-RepoDBUrl
-rdl
Repository Database Url
Required. JDBC connect string to the database for the test data warehouse repository. Use one of the following syntaxes:
Oracle:
jdbc:informatica:oracle: //<machine name>:<port number>;ServiceName= <DBName>; MaxPooledStatements=20; CatalogOptions=0; EnableServerResultCache=true
DB2:
jdbc:informatica:db2: //<host name>:<port number>; DatabaseName=<dbname>; BatchPerformanceWorkaround=true;DynamicSections=1000
SQLServer:
jdbc:informatica:sqlserver: //<host name>:<port number>; DatabaseName=<database name>; SnapshotSerializable=true
-RepoDbSchema
-rds
Repository Database Schema
Optional. The schema name for a Microsoft SQL Server database.
-RepoDbTablespace
-rdts
Repository Database Tablespace
Required for a DB2 database only. When you configure a tablespace name, the Test Data Warehouse Service creates all repository tables in the same tablespace. You cannot use spaces in the tablespace name.
The tablespace must be defined 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 command creates the tables in the default tablespace.
-TDWName
-tdwn
Test Data Warehouse Name
Required. Name of the test data warehouse.
-TDWDescription
-tdwdesc
Test Data Warehouse Description
Description of the test data warehouse. The description cannot exceed 765 characters.
TDWConnType
-tdwct
Test Data Warehouse Connection Type (ORACLE/ODBC)
Required. Type of database connection for the test data warehouse.
TDWConnName
-tdwcn
Test Data Warehouse Connection Name
Required. The database connection to use as the test data warehouse.
TDWConnDBType
tdwcdbt
Test Data Warehouse Connection Database Type (POSTGRESQL)
Required if you choose ODBC connection type. The type of database to use as the test data warehouse connection.
TDWJDBCConnName
tdwjdbccn
Test Data Warehouse JDBC Connection Name
Required if you choose ODBC connection type. The connection that the ODBC test data warehouse uses for the JDBC connection string.
TDWStagingSchema
tdwstsc
Test Data Warehouse Staging Schema Name
The schema to use for creation of staging tables when required for jobs that you run from the self-service portal. The test data warehouse connection must have access to the schema.
-HttpPort
HttpPort
Required. Port number for the service.
-HttpsPort
HttpsPort
Optional. Port number to secure the connection to the Administrator tool. Set this port number if you want to configure HTTPS for a node.
-KeystoreFile
-kf
Keystore File Location
Optional. Keystore file that contains the keys and certificates required if you use the SSL security protocol with PowerCenter.
-KeystorePassword
-kp
Keystore Password
Optional. If TLS is enabled, you must specify a password.
-SSLProtocol
-sp
SSL Protocol
Optional. Secure Sockets Layer protocol to use. Editable if you enable Transport Layer Security (TLS).
-jvmParams
-jp
JVM Parameters
JVM parameters to set:
  • The heap size allocated for the test data warehouse.
  • The time after which database connections are renewed if the TDM UI remains idle. Required if you have modified the database configuration settings to values less than the TDM defaults. Edit the values in TDM such that the values are less than the database values.
Include the JVM parameters in single quotes and then in double quotes. For example, 'value' and then "'value'".
The -Xms option is case sensitive. For example:
"'-
X
ms256m -
X
mx512m -
XX
:MaxPermSize=256m'"
  • IDLE_TIME.
    -DIDLE_TIME=<seconds>
    . Default is 300 seconds.
  • CONNECT_TIME.
    -DCONNECT_TIME=<seconds>
    . Default is 5000 seconds.

CreateService Example

The following sample command creates a Test Data Warehouse Service with the name
tdw1
:
infacmd tdw createService -dn Domain -sn tdw1 -un Administrator -pd Administrator -nn node01 -ln TDM_ALL -rn repo1 -rdt SQLSERVER -rdu test -rdp test -rdl "jdbc:informatica:sqlserver://ExampleHost:1433;SelectMethod=cursor;databaseName=tdw_cmd_db" -tdwn TDW1 -tdwct ORACLE -tdwcn OrclCOnn -httpport 7705

0 COMMENTS

We’d like to hear from you!