Intuitive for MPS - Installation Steps

The Intuitive for MPS platform consists of a number of individual elements that need to be installed and integrated together.

Pre-requisites:

  • Commission a Physical Server or VM
  • Windows Server Running IIS
  • SQLServer Instance plus SSMS
  • ODBC Driver for SQL Server
  • SQL Server management Studio
  • ODBC Driver for SQLite
  • SQLite Studio (Recommended but optional)

Installation and integration steps:

  • Install the Intuitive Dashboard Platform (V6.1 or Later) under SQL Server.
  • Restore the default MPS dashboards from dashboard.bak provided.
  • Restore the MPS Data Warehouse (DWH) from the KM_DWH.bak file provided.
  • Create a 64 Bit ODBC Data Source (System DSN) to the SQLite Intermediate Import Database.
  • Set-up linked server from SQL Server DWH to the SQLite Intermediate Import Database.
  • Create a 64 Bit ODBC Data Source (System DSN) to the SQL Server DWH (For Dashboard datafeeds).