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

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

9 Recommendations For A Successful SAP & IBM Maximo EAM Interface

9 Recommendations For A Successful SAP & IBM Maximo EAM Interface

Integration is often a key component for getting the most out of your critical IT applications. Modern Enterprise Asset Management systems such as IBM Maximo are designed for integration which can expand their capabilities and allow the flexibility that the industry...

How to call a Report directly from the Action Menu in IBM Maximo

How to call a Report directly from the Action Menu in IBM Maximo

In IBM Maximo, it’s possible to add a direct print option to a report. This adds a printer icon to the toolbar and allows you to run the report with just one click. But for reports where there are parameters required before running, this is not possible… Usually, a user will have to click the “Run Reports” action, then find their report in the list of all reports available for that application. They then click on the one they want before being taken to the IBM Maximo Reports Request page. In this blog I’ll show you how to get around that problem. in our example we use an Action launch point for an Automation Script and link it to a menu item in IBM Maximo Application Designer…

Helpful tips to remember when starting a Maximo Implementation

Helpful tips to remember when starting a Maximo Implementation

After nearly 20 years of implementing Maximo for various organisations across a myriad of industries, there are some basic design principles that I like to follow on a new (greenfield) Maximo installation. Please note that these are some of my personal preferences but...

Implementing Drill-through in a BIRT report

Implementing Drill-through in a BIRT report

More often than not, we may be working with a report which lacks all the necessary details about a particular Work Order or asset. In this instance, we need to access Maximo and retrieve the relevant record to obtain the information we are after. Wouldn’t it be so...

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.