Administrator Guide > tdwcmd > CreateTDWMART
  

CreateTDWMART

Create a test data mart to store the test data warehouse data.
With the CreateTDWMART command, you can perform the following tasks:
The CreateTDWMART command uses the following syntax:
tdwcmd
<--CreateTDWMART | -CreateTDWMART>
<--MartName | -mn> MartName
<--DBUsername | -du> DBUsername
[--PasswordAsParam | -pp] PasswordAsParam
<--DBPassword | -dp> DBPassword
<--DBUrl | -dl> DBUrl
<--DBConnString | -dc> DBConnString
[--PassThroughSecurity | -pts] PassThroughSecurity
[--connection_environment_SQL | -ces] connection_environment_SQL
[--transaction_environment_SQL | -tes] transaction_environment_SQL
<--CodePage | -cp> CodePage
<--Kerberos | -kerberos> Kerberos
[--ConnectionRetryPeriod | -crp] ConnectionRetryPeriod
[--EnableParallelMode | -epm] EnableParallelMode
[--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 CreateTDWMART command options and arguments:
Option
Argument
Description
--MartName
-dt
MartName
Required. The name of the test data mart.
--DBUsername
-du
DBUsername
Required. Account for the test data mart. Use the database client to set up this account.
--PasswordAsParam
-pp
PasswordAsParam
Optional. You can use a parameter for the password. Set the PasswordASParam option to True or False.
--DBPassword
-dp
DBPassword
Required. The password for the database user.
--DBUrl
-dl
DBUrl
Required. JDBC connect string to the database for the test data mart.
--DBConnString
-dc
DBConnString
Required. The connection string to connect to the database.
--PassThroughSecurity
-pts
PassThroughSecurity
Optional. Enable or disable pass-through security for the connection. When you enable pass-through security for a connection, the domain uses the client user name and password to log in to the corresponding database, instead of the credentials defined in the connection object.
--connection_environment_SQL
-ces
connection_environment_SQL
Optional. SQL commands to set the database environment when you connect to the database. The Data Integration Service runs the connection environment SQL each time it connects to the database.
--transaction_environment_SQL
-tes
transaction_environment_SQL
Optional. SQL commands to set the database environment when you connect to the database. The Data Integration Service runs the transaction environment SQL at the beginning of each transaction.
--CodePage
-cp
CodePage
Required. The code page to read from or write to the database. To enter a code page description that contains a space or other nonalphanumeric character, enclose the name in quotation marks.
--Kerberos
-kerberos
Kerberos
Required if you want to use Kerberos authentication. Set the Kerberos authentication to True or False.
--ConnectionRetryPeriod
-crp
ConnectionRetryPeriod
Optional. The number of seconds that the service tries to reconnect to the database if the connection fails. If the service cannot connect to the database in the retry period, the operation fails.
--EnableParallelMode
-epm
EnableParallelMode
Optional. Enables parallel processing when loading data into a table in bulk mode. Used for Oracle. Select True or False.
--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 the 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.

CreateTDWMART Example

The following sample command creates the test data mart TDWMART with Oracle database type:
tdwcmd --CreateTDWMART --MartName TDWMART --PasswordAsParam false --DBUsername orauser --DBPassword orapass --DBUrl jdbc:informatica:oracle://localhost:1521;SID=orcl --DBConnString orcl --PassThroughSecurity=false --CodePage "7-bit ASCII" --Kerberos false --ConnectionRetryPeriod 180 --EnableParallelMode false -host_name localhost -http_port 6605 --UserName Administrator --Password Administrator --SecurityDomain Native -dn Domain_SandboxVMLin_TDM961HF14 --TDMServiceName TDMS