Skip to main content
Mitratech Success Center

List of Data Warehouse Jobs

Data Warehouse Jobs

Data Warehouse Job What it does When to run
WH_install

Installs the Data Warehouse. It builds the schema objects (tables, views, indexes..etc.) 

If the Data Warehouse is already installed, this will synchronize the Data Warehouse schema with TeamConnect design, including adding/deleting custom fields, categories, etc.

If you don't have Data Warehouse installed for TeamConnect instance. You can run this job to install the Data Warehouse.

You also need to run this job when there is a change in TeamConnect design, such as adding a new custom field or object, delete or edit existing custom field or object.

WH_remove Uninstall the Data Warehouse for the TeamConnect instance. Uninstall the Data Warehouse for TeamConnect instance.
WH_upgrade Upgrades to the higher version of Data Warehouse. Execute this job to upgrade the Data Warehouse to the higher version.
TeamConnect_Warehouse_initial All the tables will be loaded with data. Usually we run this job after the install to load the data.
TeamConnect_Warehouse_initial_cf

Running this will add custom fields to Data Warehouse.

Running this will reload all the custom fields tables (WHCC_* and WHCF_* tables).

Running this will add custom fields to Data Warehouse.

Run this when there is a change from non-reportable to reportable in an existing custom field.
For example, a custom field called “MatterDescription” exists in the system and there is data in it but it is not reportable. When we change the field from non-reportable to reportable, we need to do WH_install and then TeamConnect_Warehouse_initial_cf

TeamConnect_Warehouse_Refresh

To perform install (bring new design changes from TC to DW) then load the incremental data from TeamConnect into the Data Warehouse.

 

Execute this job to load the incremental data on demand to the Data Warehouse when any design changes are made in TeamConnect. 

For example, if you add/remove custom objects/custom fields in TeamConnect instance then execute this job.

Note: Alternatively, you can do WH_install and then TeamConnect_Warehouse_Refresh_no_install

TeamConnect_Warehouse_Refresh_no_install

To load the incremental data from TeamConnect into the Data Warehouse.

Execute this job to load the incremental data on demand to the Data Warehouse if no design changes are made in TeamConnect.

TeamConnect_Warehouse_Refresh_resume

If the load incremental data load is failed or paused, execute this job to resume from the point where it failed or stopped.

To resume the incremental data load from the point where it failed or stopped.

  • Was this article helpful?