Abstract

The data varieties are the important problem of the variety of the system in an organization. The difference in database design and implementation affects the data integration. More than 30 systems are explored in different times and technology. Although the system and data are distributed, the dashboard generation is unique. It is hard to access web applications via new devices and new behaviors. The middleware is the intermediate node that acts as a proxy to collect, combine, and re-format to be the general format. The paper presents the software architecture and workflow of middleware is to collect data from the various system in the organization. The middleware is evaluated with 7 performance metrics by 7 experts. The result shows that the average score of overall metrics is 2.47 of 3.00. This middleware is easy to program and implement with a microservice model to increase scalability, availability and extensibility.