Open

Introduction

This demonstrator focuses on the integration of IBM Maximo with the platform, for the exploitation of the data stored in Maximo from the Platform. For this demonstrator, the records of its assets and work orders have been taken.

How was the integration done?

To integrate with Maximo, there are two ways:

• Use the REST APIs provided by Maximo.

• Connect to the Maximo asset database.

For the demonstrator, we decided to connect with the Maximo database to bring us the information on the Platform. To do that, the DataFlow module was used to connect with the Maximo tables, extract the information, and store it in the platform entities.

Once we have the data on the platform, we created REST APIs and exploitation dashboards.

Where can I see the demonstrator?

This demonstrator is deployed as a Web project within the Onesait Platform CloudLab. It can be accessed at this URL.

Demonstrator components

Security

Platform security has been integrated into the demonstrator through a platform Realm. Certain platform users have been assigned a Realm role, and this role gives access to one or other dashboard.

DataFlow

To integrate with IBM Maximo, three dataflows have been created:

Open

The three pipelines are similar, and consist of thre components:

• The JDBC Query connection with the Maximo IBM,

• The Pipeline Finisher that detects when data is finished and stops the process, and

• The OnesaitPlatform destination, which is where it is indicated how the bulk insertion will be carried out in the platform’s entities.

Entities

Three platform entities have been created:

• One for the assets with all the information in the order of 358 parameters per record,

• Another one with the work orders,

• And a third one with the information of the work orders processed to show it in different KPIs.

Dashboards

Two dashboards have been created: one to display asset information and the other to display work order information.

DemoMaximoWorkorder

It is made up of different elements:

Organization selector:

This selector allows you to filter all dashboard items by organization. It is multi-selection, so more than one organization can be selected.

KPI Total closed work orders:

shows the value and the percentage with respect to the total.

Comparative Total work orders by type:

In the center, you can see the total number of elements and around it the percentage for each type with respect to the total. It has a paginated key and values can be hidden from the graph by clicking on their color in the upper key. After unchecking them, they appear in gray:

Total work orders by site

In the bar chart, the x-axis shows the sites and the y-axis is for the total accumulated orders per site.

Possible actions

You can show the total values or only counting the orders closed with the switcher:

You can use the zoom by activating it with these buttons, and download the graph in image format:

The bar graph also indicates the maximum, minimum and mean values for the displayed values:

Unclosed Work Orders Table

Unclosed work orders are shown. You can filter the results by typing next to the magnifying glass icon and pressing enter. The table also has ordering and pagination.

Se muestran las ordenes de trabajo no cerradas, se puede filtrar los resultados escribiendo junto al icono de la lupa y pulsando enter, la tabla también cuenta con ordenación y paginacion. 

DemoMaximoAssets 

Organization Selector

This selector allows you to filter all dashboard items by organization. It is multi-selection so more than one organization can be selected.

Comparative Assets By Status And Sites 

This radar-type graph shows the comparison of the number of assets that each site has, for the different statuses.

Asset Information Table

Shows a summary of the Asset information. You can filter the results by typing next to the magnifying glass icon and pressing enter. The table also has ordering and pagination.

REST APIs

Two REST APIs have been created: one for assets and the other for work orders.

API DemoMaximoAssets: 

https://lab.onesaitplatform.com/api-manager/server/api/v1/DemoMaximoAssets 

API DemoMaximoWorkOrder

https://lab.onesaitplatform.com/api-manager/server/api/v1/DemoMaximoWorkorder

Web applications

Two applications have been deployed on the platform:

ods-cdnn 

This web project contains common libraries and resources, that are necessary for the application.

DemoAyuntamiento 

It is the framework application developed with VUE JS. It allows for agile developments like this one, and it has integrated login with platform security. (Note: “Ayuntamiento” is Spanish for “town hall”).

It also has the platform’s dashboards wrapper integrated:

and accesses the centralized configuration files to manage the different menus. It can have submenus.

Besides, it shows the information of the user who has accessed:

From the platform, you can create an internationalization entry so that the application can be multilanguage.

Realm

A realm has been created to associate it to a project, and to be able to differentiate, through user roles, which roles have access to which resources in the application.

In this realm, the user demoayuntamiento has been given the admin role.

Project/Application

In order to give access to the different resources, a project has been created:

It has general information:

a list of associated users and a realm:

and finally a list of resources and the roles that have access and the type of access: