Maximo Spatial Database Federation

Originally posted on the developerWorks blog.

Maximo Spatial Database Federation

Author: Rodrigo Dombrowski, Maximo Product Designer & Architect
This article describes the Maximo Spatial architecture that integrates the IBM Maximo Asset Management database with a GIS geodatabase.

All information below is valid for Maximo Spatial 7.5 version.

Maximo Spatial integrates with the GIS database using a concept called database federation, often also called database links.

Database Federation provides the following benefits:

  • No data replication needed as GIS data can be exposed and displayed on Maximo forms
  • Distributed database transactions to ensure consistency
  • Higher performance for batch read and creation of GIS records and Maximo records
  • All Maximo framework functionality and security available when displaying and editing GIS data
  • Multiple geo databases support

Documentation about how to configure Maximo Spatial to integrate with feature class tables is available in:

http://publib.boulder.ibm.com/infocenter/tivihelp/v49r1/index.jsp?topic=%2Fcom.ibm.spl.doc%2Ft_ctr_configuring.html

Documentation about how to expose GIS data to Maximo forms is available in:

http://publib.boulder.ibm.com/infocenter/tivihelp/v49r1/index.jsp?topic=%2Fcom.ibm.spl.doc%2Fconfigure%2Ft_ctr_customize_spatial_apps.html

The Maximo Spatial database configuration is done independently for each feature class that the client want to integrate with Maximo. This allows supporting multiple geodatabases and feature classes in any database schema. For GIS data insert and updates Maximo Spatial requires that both databases be from the same vendor. Oracle+Oracle, or DB2+DB2, or SQLServer+SQLServer.

Configuration Overview

Configuration Overview

In some cases it is not possible to have both Maximo and GIS database from the same vendor or it is not possible to configure database links.
For these cases currently there are the following options:

Option 1 – Read only mode – No database federation (database link)

  • Same configuration process, including Database Configuration steps, but without database link
  • It makes Maximo Spatial only read-only mode for GIS data
  • Map toolbar tools like selection, query by attributes and update GIS list stays working
  • No GIS record link or cron task will be available
  • No GIS geometry creation and editing from Maximo

Option 1

Option 1

Option 2 – No federation, read/write GIS data moved to local Maximo database

Example: Maximo running on DB2 and GIS data on Oracle database

  • Full Maximo Spatial functionality for the GIS data that is moved to Maximo database
  • No federation required when GIS is on the same Maximo database instance
  • GIS data that can be read only to Spatial can stay on Oracle
  • May require additional ArcSDE license
Option 2

Option 2

Don’t Go Mobile unless….

pulse14

What’s great about PULSE is it gets you re-energized, gives you a shot of adrenaline, and a kick in the butt to get back out there and fight the good fight. The use case presentations for those of us that have been around Maximo for many years help re-affirm what elements lead to successful and not so successful implementations and for those new to the game provide valuable advice on what rabbit holes to avoid.  Having recently been put in charge of a new Maximo implementation I had to test my temptation of avoiding just that.  One of those rabbit holes is Mobile.  Mobile is the hot topic but be aware that the consumer experience is very different from the enterprise business experience and mobile isn’t the answer when you haven’t clearly identified where you are and where you want to go with your business processes.  You need to pay close attention to what elements lead to a successful implementation before you ever say the word mobile.  I may be preaching to the choir but it bears repeating that the following elements always seem to be at the core of successful implementation experiences:

Partnership between IT and Users – These two groups must work together towards a common goal, but the measurement of success if very different between the two.  IT’s success can be measured in a more objective way in terms of getting the software installed and configured, debugged according to the technical and software performance specifications.  But it is a completely different situation with the users.  They measure success in a very subjective manner and their definition is based more on how they perceive the user experience regardless of how well the software is running and doing what it is supposed to do.    ently been put in charge of a new Maximo implementation I had to test my temptation of avoiding just that.  One of those rabbit holes is Mobile.  Mobile is the hot topic but be aware that the consumer experience is very different from the enterprise business experience and mobile isn’t the answer when you haven’t clearly identified where you are and where you want to go with your business processes.  You need to pay close attention to what elements lead to a successful implementation before you ever say the word mobile.  I may be preaching to the choir but it bears repeating that the following elements always seem to be at the core of successful implementation experiences:

Good Data – The foundation of success is rooted in clean, reliable, accurate, fact based data.  The credibility of your system depends entirely upon the accuracy of your data.  Spend the time it takes to really find out what information you need, why you need it, and who needs it.   Don’t collect data that doesn’t matter.  Remember the more you want the more it cost to get it.  Make sure is serves a useful purpose.

Business Process Analysis – Just as important as good data is the processes of getting that data into and out of the system. This requires really understanding how your operation performs the work, obtains the required information, and how it gets that in front of those that need it.  Assessing these workflows and streamlining these processes is critical in establishing configuration requirements in support of your business.

Managing Expectations – Someone needs to be in charge of defining the dance floor.  Typically this tends to be someone from IT.  This is just the opposite of what should be.  Operations/Users are the ones that have to use it, live with it, work with it, and have to own it. Truly successful implementations are driven by users with realistic expectations and a good technical support team.

To get the most from Maximo there is nothing more important than getting processes defined and streamlined in support of what management has set as the vision and direction for the organization.  Mobile smart devices become the tool of choice when you look to eliminating paper processes and making Maximo “work like we do” to get and deliver the data to those that need it, the way they need it.  High expectations base on our personal “There’s an App for That” experience sets the standard and becomes a challenge when trying to deliver a similar experience with an enterprise business mobile application.  The solution that is “right” can be a bewildering and a hotly contested debate between users and IT.  That is why it is so important that use cases are firmly rooted in well-defined business process requirements established by users.

A few obvious and not so obvious considerations when assessing your mobile solution include:

  • Platform for devices (IOS, Android, Windows Mobile)
  • Device Compatibility – what types of devices can be used on the platform
  • License Structure (named vs concurrent)
  • Online – Offline connectivity
  • Support services
  • User interface – ease of use
  • System Architecture
  • Configurability of applications
  • Skills required to develop applications
  • Administration and deployment of applications
  • Integration needs with other systems besides Maximo
  • Security and BYOD policies
  • Device management and hardware support

Mobile is hot, so be careful that you don’t get burned. Success depends on meeting user expectations.  Get your requirements act together, set realistic user expectations, and —–partner with IT to architect a solution that simplifies the user experience.

—————————————————

About Randy McDaniel:
Randy has a B.S. degree in Mechanical Engineering from the California State University at Fullerton and has spent over 35 years in the field of maintenance engineering, maintenance planning, capital projects construction, and facilities maintenance. His industry experience includes oil refineries, petrochemical plants, universities, steel mills, assembly plants, lumber mills, and utility plants.

He has spent time as a Maximo senior consultant providing business process re-engineering assessments and managing Maximo implementations. A vocal advocate of Maximo, Randy has been the Chairman of the Southern California Maximo Users Group since 1998 where he often presents best practices, tips and other real life Maximo experiences.

Currently Randy is the Maximo System Administrator and Facilities Management Information Systems Integration Manager at the University of California Los Angeles. He manages the implementation of Maximo and provides IT integration direction and vision for the General Services business unit.

This post originally appeared on the Tivoli User Community boards on March 3, 2014, and is reprinted with permission of the author

 

Maximo Spacial: Customizing Highlight Styles

Customizing Maximo Spatial Highlight Styles

This article describes how to customize the symbology (icons and colors) used on map to highlight features inside Maximo Spatial map. This customization is available in Maximo Spatial releases 7.1.1.0 and 7.1.1.1.

Spatial map highlight overview

When any feature is added to the Maximo Spatial Results widget it is highlighted on the map. This highlight is based on its associated Maximo type and feature shape. For example a point feature that is not linked to any Maximo record is represented on the map by a gray push pin, for a line feature linked to a Maximo Asset object it is a green line highlight (see all colors/mapping in the in the following sections). Continue reading

Adding spatial maps to Maximo applications

Author: Rodrigo Dombrowski, Maximo Product Designer & Architect

Beginning with Maximo Spatial 7.5.0.1, it is possible to customize any Maximo entity and Maximo application to include a map tab and to associate records with GIS records.

Some customization is required to implement this function, but no Java coding is required for the basic functionality. Database configuration and applications changes are required. These changes can be made using the Database Configuration application and Application Designer application. Continue reading