Connection - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software

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" />