Administrator Guide > tdwcmd > CreateTDWREPO
  

CreateTDWREPO

Create a test data repository to store the metadata for the data in the test data warehouse.
With the CreateTDWREPO command, you can perform the following tasks:
The CreateTDWREPO command uses the following syntax:
tdwcmd
<--CreateTDWREPO | -CreateTDWREPO>
<--db_type | -dt> db_type
[--customDriver | -cd] customDriver
<--DBUsername | -du> DBUsername
<--DBPassword | -dp> DBPassword
<--DBUrl | -dl> DBUrl
<--DBConnString | -dc> DBConnString
[--DbSchema | -ds] DbSchema
[--DbTablespace | -dts] DbTablespace
[--idleTimeout | -it] idleTimeout
[--connPoolSize | -cp] connPoolSize
<--ServiceName | -sn> ServiceName
[--Help | -?,-h]
[--Verbose | -v]
<--HostName | -host_name> HostName
<--HTTPPort | -http_port> HTTPPort
<--HTTPSPort | -https_port> HTTPSPort
<--UserName | -un> UserName
<--Password | -pd> Password
<--SecurityDomain | -sdn> SecurityDomain
<--DomainName | -dn> DomainName
<--TDMServiceName | -tsn> TDMServiceName
The following table describes the CreateTDWREPO command options and arguments:
Option
Argument
Description
--db_type
-dt
db_type
Required. The type of database. You can use the following types of databases: Oracle, DB2, and SQL server.
--customDriver
-cd
customDriver
The class name of the Custom JDBC driver that connects to the database. Required if you want to use a custom database driver.
--DBUsername
-du
DBUsername
Required. Account for the repository database. Use the database client to set up this account.
--DBPassword
-dp
DBPassword
Required. Repository database password for the database user.
--DBUrl
-dl
DBUrl
Required. JDBC connect string to the database for the test data repository.
--DBConnString
-dc
DBConnString
Required. The connection string to connect to the database.
--DbSchema
-ds
DbSchema
Optional. The schema name for a Microsoft SQL Server database.
--DbTablespace
-dts
DbTablespace
Required for a DB2 database. The name of the table space to create the tables.
--connPoolSize
-cp
connPoolSize
Optional. Maximum number of idle connection instances that the Test Data Manager Service maintains for a database connection.
--idleTimeout
-it
idleTimeout
Optional. The idle connection timeout for the database.
--ServiceName
-sn
ServiceName
Required. The name of the test data repository.
--Help
-?,-h
n/a
Optional. Displays or prints the help options.
--Verbose
-v
n/a
Optional. Verbose output. Displays more than the minimum information about the object.
--HostName
-host_name
HostName
Required. The TDM host name.
--HTTPPort
-http_port
HTTPPort
Required if you do not specify an HTTPS port. Port number to connect to the Test Data Manager Service.
--HTTPSPort
-https_port
HTTPSPort
Required if you do not specify an HTTP port. Port number to secure the connection to the Test Data Manager Service.
--UserName
-un
UserName
Required. The Informatica domain user name.
--Password
-pd
Password
Required. The password for Informatica domain user.
--SecurityDomain
-sdn
SecurityDomain
Required. The Informatica security domain.
--DomainName
-dn
DomainName
Required. The name of the TDM domain.
--TDMServiceName
-tsn
TDMServiceName
Required. The name of the Test Data Manager Service.

CreateTDWREPO Examples

The following sample command creates the test data repository TDWREPO with Oracle database type:
tdwcmd --CreateTDWREPO --db_type oracle --DBUsername orauser --DBPassword orapass --DBUrl jdbc:informatica:oracle://localhost:1521;SID=orcl --DBConnString orcl --connPoolSize 5 --idleTimeout 320 --ServiceName TDWREPO -host_name localhost -http_port 6605 --UserName Administrator --Password Administrator --SecurityDomain Native -dn Domain_SandboxVMLin_TDM961HF14 -tsn TDMS
The following sample command creates the test data repository TDWREPO with Microsoft SQL Server database type:
tdwcmd --CreateTDWREPO --db_type sqlserver --DBUsername <sqluser> --DBPassword <sqlpassword> --DBUrl jdbc:informatica:sqlserver://<serverName>:1433;SelectMethod=cursor;databaseName=<dbname> --DBConnString <serverName>@<dbName> --connPoolSize 5 --ServiceName TDWREPO -host_name localhost -http_port 6605 --UserName Administrator --Password Administrator --SecurityDomain Native -dn Domain_SandboxVMLin_TDM961HF14 -tsn TDMS