---
title: Intuitive for MPS - Data Warehouse Load Process
description: The main MPS SQL Server Data Warehouse is the main data repository the MPS Dashboards and is loaded from the intermediate SQLite Database. This article describes the load process.
---

[Skip to content](https://help.intuitivebusinessintelligence.com/intuitive-for-mps-data-warehouse-load-process#main-content)

English

Show submenu for translations

![Intuitive logo RGB-1.png\]](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20RGB-1.png?height=40&name=Intuitive%20logo%20RGB-1.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Go to weareintuitive.com](https://weareintuitive.com/)

[Go to weareintuitive.com](https://weareintuitive.com/)

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.intuitivebusinessintelligence.com/?hsLang=en)
2. [Intuitive For Managed Print Services (MPS)](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en)
3. [Intuitive For MPS - Loading the Data Warehouse](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-loading-the-data-warehouse)

# Intuitive for MPS - Data Warehouse Load Process

## The main MPS SQL Server Data Warehouse is the main data repository the MPS Dashboards and is loaded from the intermediate SQLite Database. This article describes the load process.

![MPS\_ETL\_Service\_Diagram\_SQLite\_To\_DWH-1](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/MPS_ETL_Service_Diagram_SQLite_To_DWH-1.png?width=534&name=MPS_ETL_Service_Diagram_SQLite_To_DWH-1.png)

The main SQL Server MPS Data Warehouse (DWH) contains a number of routines (SQL Server Stored Procedures) which perform the controlled load of the MPS Data into tables in the DWH.

Within the DWH there is a link (Linked Server) to the Intermediate SQLite database (3 Core Tables). Data is loaded from the SQLite database into the SQLServer Data Warehouse by executing (double clicking) the load batch process file which normally resides here:

***C:\\Intuitive\_WorkFiles\\MPS\\ETL\\ETL\_LoadData.bat***

This batch file in-turn executes the SQL script to execute the Stored Procedures to perform the DWH load:

***C:\\Intuitive\_WorkFiles\\MPS\\ETL\\Load\_DWH.sql***

The SQL script performs the following tasks as standard (but can be adjusted if required to meet local needs i.e. to force a re-load of existing data etc.).

- Checks to ensure that the Linked Server to the SQLite database is online
- Loads the LOOKUP data (always)
- Loads the VOLUMES data (where new data exists)
- Loads the SERVICE data (where new data exists)

Once the DWH load has completed, a log file is produced which should be reviewed to ensure no errors have been reported during the load:

***C:\\Intuitive\_WorkFiles\\MPS\\ETL\\ETL\_Log.txt***

The three **main tables** maintained in the DWH are as follows:

- ***dbo.OPS\_MIF*** (Volumes data)
- ***dbo.OPS\_SERVICE*** (Service Data)
- ***dbo.OPS\_LOOKUP*** (Call Type Lookup data)

The three **main SQL views** of the data which feed the Intuitive for MPS dashboard datafeeds are as follows:

- ***viw\_KM\_Printfleet\_Data\_SHNewv2*** (Volumes Data)
- ***viw\_KM\_Printfleet\_Data\_Summary\_Counts*** (Volumes Data Summary)
- ***viw\_KM\_Service\_Calls\_SHNewv4*** (Service Data)

- [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#main-content)

    - [Getting Started](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#getting-started)
    - [Viewing Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#viewing-dashboards)
    - [Interacting with dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#interacting-with-dashboards)
    - [Filters](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#filters)
    - [Connections](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#connections)
    - [Datafeeds](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datafeeds)
    - [Datasets](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datasets)
    - [Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#components)
    - [Creating Dashboards and Components - Overview](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-dashboards-and-components-overview)
    - [Creating Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-components)
    - [Creating a Dashboard](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-a-dashboard)
    - [Administering the System](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-the-system)
    - [Administering Users](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-users)
    - [Administering Groups](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-groups)
    - [Security Filters - V5.2 and earlier](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-2-and-earlier)
    - [Security Filters - V5.3 Onward](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-3-onward)
    - [Embedding Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#embedding-dashboards)
    - [Configuration File](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#configuration-file)
    - [Installation & Configuration Guide](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#installation-configuration-guide)
    - [Version History](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#version-history)
- [Intuitive for PaperCut V2](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#main-content)

    - [Installing Intuitive for PaperCut](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#installing-intuitive-for-papercut)
    - [Viewing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#viewing-papercut-dashboards)
    - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#editing-papercut-dashboards)
    - [Intuitive for PaperCut Demonstration Videos](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-demonstration-videos)
    - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-faqs)
- [Intuitive for PaperCut MF V3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#main-content)

    - [Installing Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#installing-intuitive-for-papercut-version-3)
    - [Viewing the dashboards - Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-version-3)
    - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#editing-papercut-dashboards)
    - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#intuitive-for-papercut-faqs)
- [Intuitive for SAFEQ](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#main-content)

    - [General Help](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#general-help)
    - [Software Installation](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#software-installation)
    - [Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#solution-expertise)
- [Intuitive For Managed Print Services (MPS)](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#main-content)

    - [Intuitive for MPS - Overview](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-overview)
    - [Intuitive for MPS - Installation Steps](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-installation-steps)
    - [Intuitive for MPS - Import File Layouts](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-import-file-layouts)
    - [Intuitive For MPS - Loading the Data Warehouse](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-loading-the-data-warehouse)
- [Intuitive Cloud Services](https://help.intuitivebusinessintelligence.com/intuitive-cloud-services?hsLang=en)
- [Intuitive for PaperCut Hive V1](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#main-content)

    - [Viewing the dashboards - Intuitive for PaperCut Hive](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-hive)
- [Intuitive for SAFEQ Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#main-content)

    - [Intuitive Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-solution-expertise)
    - [Intuitive Software Provisioning](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-software-provisioning)
- [Intuitive for Docuware](https://help.intuitivebusinessintelligence.com/intuitive-for-docuware?hsLang=en)
- [Intuitive for Print Management](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#main-content)

    - [Solution Knowledge](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#solution-knowledge)
    - [Technical Information](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#technical-information)
- [Intuitive for e-BRIDGE Global Print](https://help.intuitivebusinessintelligence.com/intuitive-for-e-bridge-global-print?hsLang=en)
- [Intuitive for e-FOLLOW Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-e-follow-cloud?hsLang=en)
- [FAQ](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#main-content)

    - [Connections](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#connections)
    - [General Enquiries](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#general-enquiries)
    - [Datafeeds](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datafeeds)
    - [Datasets](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datasets)
    - [System Compatability](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#system-compatability)
    - [Software Installation](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#software-installation)

[![Chill listening crop-3](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20BLACK.png?width=102&height=24&name=Intuitive%20logo%20BLACK.png "Chill listening crop-3")](https://help.intuitivebusinessintelligence.com?hsLang=en)

weareintuitive.com Help Center

Copyright © 2026, Intuitive Business Intelligence Limited