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).