Teradata Tools

Welcome to Teradata Tools @ Forrit.dk. Feel free to download the tools listed below. Contact Frodi Fjallstein if you are interested in the source code or have any comments. All tools are developed in Visual Basic 6.0 and come with an installer. None of the tools are have any kind of support and using them is at your own risk.

Enjoy

Table Extractor 1.2 The Table Extractor is a utility for copying single tables or multiple tables from one database to another. This utility creates INSERTS statements for every row in a selected table. It can also export the DDL for selected tables and views. Since some table can be bigger than what can fit into memory, the utility breaks large tables into clusters (user defined size) to avoid memory overflow. The utility creates an output file for every extract (and not per table). The output file can be executed through BTEQ or Teradata SQL Assistant (former QueryMan).

Teradata Quick Search 2.1 The Teradata Quick Search is a utility for searching and updating text based content of a Teradata RDBMS. This utility consists of four different modules:
Text Search - Search for text of fragments of text in any CHAR or VARCHAR field in a Teradata database. Filters can be applied to limit the list of tables and fields to search in.
Column Search - Search for fields by name in any Teradata database
Browse - Listing the tables, views and macros in a given Teradata database. Features like Show DDL, Browse, Count, etc. are available.
Free Search - Executes any valid SQL and lets the user edit the results. Changes can be automatically be written back to the database.

CRM Explorer 1.9 The CRM Explorer is a utility for monitoring of job and tasks in the CRM application. It replaces more or less the Inbox, Scheduled Tasks and the Task Broker GUI. Further more it enables the user to lookup communications and segments - and monitor the spool usage per AMP per user. This utility is useful remote supporting of the CRM application. For those installations that are running the CRM middle tier applications as background processes this utility is one of the few way to monitor middle tier. The result pane is HTML and can easily be printed out or saved for tracking using the right-click option.

CRM Campaign Browser 1.4 The CRM Campaign Browser is a utility to browse Multi-Step communications from Teradata CRM. The utility displays the communications in a hierarcial structure which enables the user to drill all the way down to the individual responses in a given step in a given communication plan. For each level in the hierarchy, the utility show the current number of leads and totals for various informations, such as invalid responses, limiting, best lead and history of the level. Where ever there are current leads, these can be listed by using right-click menu's.

CRM Channel Responses 1.6 The CRM Channel Responses is a utility that can emulate those channels used in a Multi-Step communication from Teradata CRM. The utility enables the user to select a given step in a communication plan and assign responses to the leads in that step. It can also be used to assign successes to those leads in the monitor state.

Table Extractor 1.2	The Table Extractor is a utility for copying single tables or multiple tables from one database to another. This utility creates INSERTS statements for every row in a selected table. It can also export the DDL for selected tables and views. Since some table can be bigger than what can fit into memory, the utility breaks large tables into clusters (user defined size) to avoid memory overflow. The utility creates an output file for every extract (and not per table). The output file can be executed through BTEQ or Teradata SQL Assistant (former QueryMan).
Teradata Quick Search 2.1	The Teradata Quick Search is a utility for searching and updating text based content of a Teradata RDBMS. This utility consists of four different modules: Text Search - Search for text of fragments of text in any CHAR or VARCHAR field in a Teradata database. Filters can be applied to limit the list of tables and fields to search in. Column Search - Search for fields by name in any Teradata database Browse - Listing the tables, views and macros in a given Teradata database. Features like Show DDL, Browse, Count, etc. are available. Free Search - Executes any valid SQL and lets the user edit the results. Changes can be automatically be written back to the database.
CRM Explorer 1.9	The CRM Explorer is a utility for monitoring of job and tasks in the CRM application. It replaces more or less the Inbox, Scheduled Tasks and the Task Broker GUI. Further more it enables the user to lookup communications and segments - and monitor the spool usage per AMP per user. This utility is useful remote supporting of the CRM application. For those installations that are running the CRM middle tier applications as background processes this utility is one of the few way to monitor middle tier. The result pane is HTML and can easily be printed out or saved for tracking using the right-click option.
CRM Campaign Browser 1.4	The CRM Campaign Browser is a utility to browse Multi-Step communications from Teradata CRM. The utility displays the communications in a hierarcial structure which enables the user to drill all the way down to the individual responses in a given step in a given communication plan. For each level in the hierarchy, the utility show the current number of leads and totals for various informations, such as invalid responses, limiting, best lead and history of the level. Where ever there are current leads, these can be listed by using right-click menu's.
CRM Channel Responses 1.6	The CRM Channel Responses is a utility that can emulate those channels used in a Multi-Step communication from Teradata CRM. The utility enables the user to select a given step in a communication plan and assign responses to the leads in that step. It can also be used to assign successes to those leads in the monitor state.