THE BPD Blog

From blogs to case studies to news, we love sharing our tips and tricks for asset management, cloud, IoT and smarter operations.

by | Oct 8, 2018

Exchange Integration Solution (ExIS) for Maximo

I recently delivered a project where my role was to implement a solution for IBM Maximo which receives emails from a Microsoft Exchange Central Email Box over Active Directory authentication and imports email content and attached Excel templates into Maximo.
Maximo by standard only supports IMAP and POP3 so the first thing I checked was which protocol was enabled on the Exchange side. Standard MAPI over http and EWS were enabled. Either IMAP or POP3 were disabled. This is a typical configuration for larger enterprises and they don’t change it.
I quickly realised that no similar solution has been published so far, therefore I had to design and build a custom integration solution on the Maximo side to support standard Microsoft Exchange communication protocol and Excel template import.
High-level solution design for Exchange Central Email Box – Maximo Business Object integration:

Exchange Integration Solution (ExIS) was built by merging several technologies: a java exchange framework, Maximo standard email listener and MIF functionality, plus specific java libraries. These technologies are orchestrated in one main ExIS workflow which is triggered by every new incoming email.
The main steps of the workflow:

  1. A new email is received in a shared email box containing a Service Request (SR) or Incident template attachment. This event is recognized by ExIS.
  2. It creates an inbound communication record in Maximo, downloads attachments into DOCLINK, marks email as read and moves it into a processed subfolder on Exchange.
  3. ExIS converts the content of the email and template attachment to Maximo standard MIF messages.
  4. XML consumers pick up these messages and loads into the defined object structure. We have extended the standard record load with an option to be able to validate and load a record on field level. This means the load doesn’t stop at the first error, it loads all data and lists all errors.

The ExIS solution has a management application where the admin user can manage import loads and related errors. I will go deeper into technical details in a following blog but for now I am concluding this post with the solution capability and compatibility information:
ExIS supports two areas, operating with business objects and with user data:

  • Central Email Box – Maximo Business Object integration: this work and blog post covers this scenario.
  • Exchange User Account – Maximo User Account integration: users’ availability and tasks synchronization. This could be useful at planning and delegation process.

ExIS is compatible with Exchange server versions 2007, 2010, 2013 and 2016. On the Maximo side 7.1, 7.5 and 7.6 are supported.

Automating this functionality will help save you time! For more information, please contact me.

#MSEXCHANGE #MSAD #IBMMAXIMO #EXCELTEMPLATE #MAXIMOMIF #BPDZENITH #MAXIMO

Norbert Figura

Norbert Figura

Norbert is a customer-focused ERP, Business Intelligence and Integration professional at BPD Zenith (Canada). He has 15+ years of worldwide project experience in software development and consulting including successful implementations in Maximo, SAP and Oracle. Norbert has strong communication and organization skills, enjoying responsibility and ownership at all stages of the planning and execution lifecycle. He has gained solid analytical and problem solving skills and has the ability to implement innovative and profitable solutions on time and to budget. Industry focus: Utility, Oil and Gas, Facility Management.

0 Comments

What is Asset Performance Management?

What is Asset Performance Management?

What is Asset Performance Management? Introduction As a definition, Asset Performance Management (APM) encompasses the capabilities of data capture, integration, visualization, and analytics tied together for the explicit purpose of improving the reliability and...

Maximo Relationships

Maximo Relationships

In this blog I will be explaining what a Maximo Relationship is, how to create one, and, the benefits of having Maximo Relationships. What is a relationship? The way in which two or more things are connected, or the state of being connected.Why do we need Maximo...

Maximo Data Imports: A simplified guide

Maximo Data Imports: A simplified guide

All your Maximo data import needs simplified Being able to manage data loads and data extracts is a powerful ability. It can substantially improve processes and reduce delays. Maximo offers not one but multiple ways of handling data. Equipped with user-friendly error...

Custom servlet in Maximo

Custom servlet in Maximo

What is a servlet? Servlets are Java classes which service HTTP requests and implement the ‘javax. servlet. HttpServlet’, an abstract class that implements the servlet interface and is specially designed to handle HTTP requests. A  servlet accepts the request,...

Sign up to our free newsletter to explore emerging technologies, industry events and Maximo best practice.

Come with BPD Zenith to the future of Asset Management

Partner Ecosystem

BPD Zenith partners with a diverse array of the world’s top Technology, Business and Solution Integration leaders.