TWM Databases

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

Teradata Warehouse Miner has several database concepts including a Source Database, Result Database, Metadata Database, Statistical Test Database, Publish Database and Advertise Database. These can all refer to the same physical Teradata Database or five distinct databases. The following table defines each database, along with the necessary Teradata access rights.

Database Definitions
Database Definition Access Rights
Source Database This is the database where the tables to be analyzed exist. By default, this is equivalent to the Default Database defined in the Teradata ODBC data source, but it can be modified globally on the Connection Properties dialog, or changed for each analysis on the Output-storage panel. SELECT
Result Database This is the database where Teradata Warehouse Miner builds result tables/views. By default, this is equivalent to the “Userid” defined in the Teradata ODBC data source, but it can be modified globally on the Add/Remove Programs dialog, or changed for each analysis on the Output-storage panel. CREATE and SELECT WITH GRANT if other analyses will be executed against Views created in Result Database.
Metadata Database This is the database where the Teradata Warehouse Miner metadata resides. By default, this is equivalent to the “Userid” defined in the Teradata ODBC data source, but it can be modified on the Add/Remove Programs dialog. CREATE TABLE, VIEW, MACRO, PROCEDURE, FUNCTION, as well as ALTER FUNCTION to use the Metadata Creation feature, UDF creation or initial Drill-Down saving; UPDATE otherwise.
Statistical Test Database This is the database where the metadata that supports the Statistical Test functions resides. The metadata is created using the program item "Load Statistical Test Metadata". CREATE to use the program item to create Statistical Test Tables; SELECT otherwise.
Publish Database This is the database where the metadata that supports the Publish function resides. It is created using the Publish Tables Creation item on the Tools menu. CREATE to use the program item to create Publish Tables or to publish for the first time after migrating to 5.2 or later; UPDATE otherwise.
Advertise Database This is the database where the Advertise Output metadata resides. It is created using the Advertise Tables Creation items on the Tools menu. CREATE to use the program item to create Advertise Tables; UPDATE otherwise.