Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.


When do I need to run install/initial/refresh?

Here's when you will need to run install DataWarehouse!

Running WH_install

WH_install is ran for one of the following options: 

  1. New custom fields that have been created or existing system fields have been configured to be refreshed within the data warehouse.
  2. New objects have been created within TeamConnect.
  3. A new data warehouse is being constructed also known as a fresh install of data warehouse
  4. The system locale file is updated in TeamConnect with the Locale Manager tool.

Note: Data Warehouse works by flattening the TeamConnect schema into larger tables with extra columns to store TeamConnect metadata in a format that supports simpler queries. The flattening includes language locales as well. Whenever a locale value is updated in the system, all objects referencing that value need to be updated in Data Warehouse. Each time a new locale value is added to the system, all objects referencing that locale value need to add an additional row to store the new locale information.

Important: When new custom fields are handled by running one of these files, it is possible that column names in some Data Warehouse views may change, and existing column names could now refer to different data than they did previously. This is caused by the way duplicate column names (in the source database) are handled by table WH_CF_MAPPING (see Helper Table Definitions). Check for this situation and, if necessary, revise your reports to use the changed column names.

Running TeamConnect_Warehouse_initial

TeamConnect_Warehouse_initial is invoked manually using the .bat or .sh file and is used only for the initial load. 

Note about Initial Loading: When this job runs, it may require a long time to complete, because it will be loading a large volume of data from the source database to the target database.

Running TeamConnect_Warehouse_initial_cf

When there is a design change or a new custom field is added, this job is invoked to refresh the custom fields data.

Running TeamConnect_Warehouse_Refresh_no_install

This job is invoked for periodic data refresh. Windows scheduler or UNIX cron is used to run this job at regular intervals.