Connection

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K

The Connection element takes multiple attributes: name, type, userid, password, account, metadatadatabase, resultdatabase, statisticaltestdatabase, publishdatabase, advertisedatabase and alwaysadvertise (=true/false).

The name and type attributes are required.
  • The name attribute is the name of the connection for the particular type of connection being requested. The name attribute is the name of the connection for the particular type of connection being requested.
  • The type attribute corresponds to the four different types of connection that TWM supports: System, User, File, and Simple.
UserId and password attributes are needed only if the information can not be obtained from the connection. The four database attributes are optional as well. They only need to be set if the user wishes to override the ones specified in the Connection Properties. The account attribute is completely optional.

If the connection type is System or User, the connection name must match a defined ODBC datasource of the appropriate type (System or User). If the specified connection name is not found in the TWM connections saved from interactive sessions, a warning is given and default values are used for metadatadatabase, resultdatabase, statisticaltestdatabase, publishdatabase and advertisedatabase, unless overridden through the connection elements listed above.

An example of specifying a user connection using the existing data source name “MyConnection” which defines the userid and password in the data source and overriding the result database to “MyResultDatabase” follows:

<Connection name="MyConnection" type="user" resultDatabase="MyResultDatabase" />