Install and Configure Teradata Warehouse Miner

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

Install and Configure Teradata Warehouse Miner

It is easy to install the Teradata Warehouse Miner Evaluation software. First, download the software package. Then open the “TWM.msi” file and follow the instructions, including accepting the license agreement and, if necessary, installing the appropriate version of the .NET runtime package if prompted to do so.  After the installation, start the application via its desktop icon or start-program item and then select Contents & Index on the Help menu (or simply press F1).  Open the Configuration sub-chapter in the Installation and Configuration chapter of the Help system.  You can follow the instructions in this chapter to configure Teradata Warehouse Miner to work against the desired data in your Teradata data warehouse. 

Or, if desired, you can create tutorial databases and tables that match the tutorials in the Help system and the matching tutorial projects available from the Help menu via the Import Tutorial Projects menu item.  (Note that the installation sub-directory that contains the tutorial projects also contains a sub-folder with batch-execution XML files that can be used in this same environment.  Refer to the Batch Execution page in the sub-chapter Executing Teradata Warehouse Miner Analyses in the Using Teradata Warehouse Miner chapter of the help system for information about batch execution.)

To create the tutorial environment you will need to perform the following.

First, create a user called “twm” and two databases, “twm_source” and “twm_results”.  (These are the metadata, source and result databases described on the Teradata Warehouse Miner Databases page of the Configuration chapter. The Metadata Database, “twm”, will also be used for the Statistical Test Database and Publish Database. 100 megabytes of space should be sufficient for each of these databases.)

Second, create a datasource called “twmuser” by executing the ODBC Data Source Administrator from the TWM Tools menu. Add an entry as follows:

Category: System DSN

Driver: Teradata

Name: twmuser

Server: <your host name here>

Do not resolve alias…

Username: twm

Password: <twm password here>

Default Database: twm_source

Session Character Set: ASCII

Next, set the TWM configuration properties as follows:

  • Connect to the twmuser datasource by selecting Tools >> Change Connection from the main menu, by then clicking on the System Data Source tab in the Select Data Source window, and finally by selecting twmuser and by clicking on OK.
  • Select Tools >> Connection Properties on the main menu and change the Result Database to twm_results on the Databases tab and add twm_results to the Source Database.  (The Metadata, Statistical Test and Publish Database should be twm and the first Source Database should be twm_source.  See the picture below.)

     

 

Now install the TWM metadata tables as follows:

  1.  Select the TWM Tools menu item Metadata Creation (either With Fallback or Without Fallback) and answer the various prompts.
  2. Select the TWM Tools menu item Publish Tables (either With Fallback or Without Fallback) and answer the various prompts.

Install the Demonstration Data (tutorial tables) in the twm_source database by executing the program item Start >> Programs >> Teradata Warehouse Miner X.Y.Z >> Load Demonstration Data and by supplying the following information when prompted.  (Note that this operation requires that the Teradata FastLoad utility be installed on the same workstation as Teradata Warehouse Miner and that the “hosts” file on this same workstation contain an entry for the desired host.  For more details, refer to the page Installing Support Tables and Functions in the Configuration sub-chapter of the Installation and Configuration chapter of the Help system.)

Hostname: <your host name here>

Userid: twm

Password: <twm password here>

Account:

Database: twm_source

Char Set:

 

Install the Statistical Test tables in the twm database by executing the program item Start >> Programs >> Teradata Warehouse Miner X.Y.Z >> Load Statistical Test Metadata and by supplying the following information when prompted.  (Note that this operation requires that the Teradata Client FastLoad utility be installed on the same workstation as Teradata Warehouse Miner and that the “hosts” file on this same workstation contain an entry for the desired host.)

Hostname: <your host name here>

Userid: twm

Password: <twm password here>

Account:

Database: twm

Char Set:

 

Install the PMML User Defined Functions (UDF’s) in the twm database by executing the program item Start >> Programs >> Teradata Warehouse Miner X.Y.Z >> PMML UDF Creation and by supplying the following information.  (Note that this operation requires the Teradata Client Bteq utility and that Teradata requires a suitable C compiler as well in order to perform the operation.  It is also necessary that the “hosts” file on the workstation contain an entry for the desired host.)

Hostname: <your host name here>

Userid: twm

Password: <twm password here>

Account:

Database: twm

Char Set:

 

Getting to Know Teradata Warehouse Miner

Now that you've successfully installed and configured Teradata Warehouse Miner, take look at the article on Getting to Know Teradata Warehouse Miner which describes how to load and view a supplied tutorial project and how to build a project from scratch, with specific examples of a Histogram Analysis, Scatter Plot Diagram, Decision Tree Model and Decision Tree Score Table.