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 Manager Service in a domain.
The infacmd tdm CreateService command uses the following syntax:
CreateService <-DomainName|-dn> domain_name <-ServiceName|-sn> service_name <-UserName|-un> user_name <-Password|-pd> password [<-SecurityDomain|-sdn> security_domain] [<-ResilienceTimeout|-re> timeout_period_in_seconds] <-NodeName|-nn> node_name <-LicenseName|-ln> license_name
<-PCRSServiceName|-pcrs> power_center_repo_service <-PCISServiceName|-pcis> power_center_int_service
<-MRSServiceName|-mrs> model_repo_service <-MRSUserName|-rsun> model_repo_service_username <-MRSPassword|-rspd> model_repo_service_password [<-MRSSecurityDomain|-rsdn> model_repo_security_domain]
<-AnalystService|-at> analyst_service
<-EnableProfiling|-ep> enable_profiling
<-TDWServiceName|-tdw> test_data_warehouse_service
<-DISServiceName|-dis> data_integration_service <-db_type|-dt> database_type (ORACLE, DB2, SQLSERVER or CUSTOM) <-DBUsername|-du> db_user <-DBPassword|-dp> db_password <-DBUrl|-dl> db_url <-DBConnString|-dc> db_conn_string [<-DbSchema|-ds> db_schema (used for SQL Server only)] [<-DbTablespace|-db> db_tablespace (used for DB2 only)] [<-HttpPort> http_port] [<-HttpsPort> https_port] [<-KeystoreFile|-kf> keystore_file_location] [<-KeystorePassword|-kp> keystore_password] [<-SSLProtocol|-sp> ssl_protocol] [<-jvmParams|-jp> jvmParameters] [<-connPoolSize|-cp> conn_pool_size] [<-jmxPort> jmx_port] [<-shutdownPort> shutdown_port] [<-hadoopDistDir> Hadoop Distribution Directory] [<-hadoopKerbSPN> Hadoop Kerberos Service Principal Name] [<-hadoopKerbKeytab> Hadoop Kerberos Keytab]
The following table describes infacmd tdm 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 Manager 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:
/ * ? < > " |
-UserName
-un
user_name
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:
/ * ? < > " |
-PCRSServicename
-pcrs
power_center_repo_service
Name of the PowerCenter Repository Service to which TDM connects.
-PCISServicename
-pcis
power_center_int_service
Name of the PowerCenter Integration Service to which TDM connects.
-MRSServiceName
-mrs
model_repo_service
Name of the Model Repository Service to which TDM connects.
-MRSUserName
-rsun
model_repo_service_username
Required. User name to connect to the Model repository.
-MRSPassword
-rspd
model_repo_service_password
Required. Password for the user name to connect to the Model repository. The password is case sensitive.
-AnalystService
-at
analyst_service
Optional. Name of the Analyst Service that TDM uses for asset linking. Required if you use the asset linking feature to link TDM global objects to the Business Glossary objects.
-MRSSecurityDomain
-rsdn
model_repo_security_domain
Required if you use LDAP authentication. Name of the security domain that the user belongs to. Security domain is case sensitive.
Default is Native.
-EnableProfiling
-ep
enable_profiling
Indicates data discovery settings. Set to true to enable data discovery. Set to false to disable data discovery.
-TDWServiceName
tdw
test_data_warehouse_service
Optional. Required if you create a test data warehouse. Name of the Test Data Warehouse Service that TDM uses to manage the test data warehouse.
-DISServiceName
-dis
data_integration_service
Name of the Data Integration Service to which TDM connects.
-db_type
-dt
database_type
Type of TDM repository database. Values are Oracle, SQL Server, DB2, or Custom.
-DBUsername
-du
db_user
Required. Account for the repository database. Use the database client to set up this account.
-DBPassword
-dp
db_password
Required. Repository database password for the database user.
-DBUrl
-dl
db_url
Required. JDBC connect string to the database for the TDM repository. Use one of the following syntaxes:
Oracle:
jdbc:informatica:oracle: //<machineName>:<PortNo>;ServiceName= <DBName>; MaxPooledStatements=20; CatalogOptions=0; EnableServerResultCache=true
DB2:
jdbc:informatica:db2: //<host>:<port>; DatabaseName=<dbname>; BatchPerformanceWorkaround=true;DynamicSections=1000
SQLServer:
jdbc:informatica:sqlserver: //<host>:<port>; DatabaseName=<dbname>; SnapshotSerializable=true
-DBConnString
-dc
db_conn_string
Native connect string to the TDM repository database. The service uses the connect string to create a connection object to the Test Data Manager repository and the PowerCenter repository or Model repository.
-DbSchema
-ds
db_schema
Optional. The schema name for a Microsoft SQL Server database.
-DbTablespace
-db
db_tablespace
Required for a DB2 database only. When you configure a tablespace name, the Test Data Manager 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 installer creates the tables in the default tablespace.
-HttpPort
http_port
Required. Port number for the service.
-HttpsPort
https_port
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
-pt
SSL Protocol
Optional. Secure Sockets Layer protocol to use. Editable if you enable Transport Layer Security (TLS).
-jvmParams
-jp
jvmParameters
JVM parameters to set:
  • The heap size allocated for Test Data Manager.
  • 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
ms512m -
X
mx1024m -
XX
:MaxPermSize=512m'"
  • IDLE_TIME.
    -DIDLE_TIME=<seconds>
    . Default is 300 seconds.
  • CONNECT_TIME.
    -DCONNECT_TIME=<seconds>
    . Default is 5000 seconds.
-connPoolSize
-cp
conn_pool_size
Optional. The maximum number of idle connection instances that a pool maintains for a database connection before the maximum idle time is met. Set this value to be more than the minimum number of idle connection instances. Default is 15.
-jmxPort
jmx_port
Port number for the JMX/RMI connections to TDM. Default is 6675.
-shutdownPort
shutdown_port
Port number that controls shutdown for TDM.
-hadoopDistDir
-hdd
Hadoop Distribution Directory
The Hadoop distribution directory on the Test Data Manager Service node.
-hadoopKerbSPN
-hks
Hadoop Kerberos Service Principal Name
Service Principal Name (SPN) of the Data Integration Service to connect to a Hadoop cluster that uses Kerberos authentication.
Not required when you run the MapR Hadoop distribution. Required for other Hadoop distributions.
-hadoopKerbKeytab
-hkt
Hadoop Kerberos Keytab
The file path to the Kerberos keytab file on the machine on which the Data Integration Service runs.
Not required when you run the MapR Hadoop distribution. Required for other Hadoop distributions.

0 COMMENTS

We’d like to hear from you!