Configuration Guide

10.5.1
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0

Back Next

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

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

CreateService

CreateService

CreateService Example