In order to install the metadata tables, you must execute the Metadata Creation… wizard from the Tools menu. The Metadata Creation wizard will either create the new metadata in the specified metadata database or overwrite the current metadata.
- Create the new metadata in the specified Metadata Database.
- Overwrite current TWM 4 or higher metadata with new metadata in the specified Metadata Database.
-
Select Metadata Creation from the Tools menu.
The Metadata tables can be created either With Fallback or Without Fallback as shown below.
Metadata Creation
If there is currently no connection established to Teradata, the Metadata Creation wizard prompts you with the Select Data Source dialog as previously described.
It is highly advisable to first establish a connection and verify the Metadata Database name on the Connection Properties dialog. This is the database where the creation and/or migration will take place.
If no metadata exists in the current metadata database, a confirmation dialog is displayed as shown below. The database is displayed along with the choice of with or without fallback protection.
Metadata Creation Confirmation DialogMetadata Creation Complete Dialog
-
Click Yes.
The process takes from seconds to minutes, depending upon the contention with the Teradata dictionary. A message is displayed indicating the destination database, followed eventually by the final confirmation shown below.
-
Click OK to return to the Teradata Warehouse Miner user interface. Now projects can be saved in the metadata database.
If TWM 4 or higher metadata exists in the current metadata database, the Metadata Creation wizard prompts you as follows:
Metadata Creation: Overwrite Current
-
Click Yes to overwrite the metadata tables or No to return to the Teradata Warehouse Miner user interface.
If Yes is selected, a confirmation dialog is displayed indicating the database, the number of analyses about to be destroyed, and the requested fallback option (with or without).
Metadata Creation: Overwrite Confirmation Dialog
If this confirmation dialog is answered Yes, the same completion dialog is eventually displayed as shown above. Click OK to return to the Teradata Warehouse Miner user interface.
If Yes is answered, a confirmation dialog is displayed indicating the database and fallback protection option (with or without), just as it would be if an older version of metadata was not present. Answering this confirmation dialog Yes causes the existing metadata tables to be removed and replaced by new tables that contain no projects.