ESRI Integration with Maximo and SAP through ArcGIS Web Adaptor

Most of the ESRI integrations are through ArcGIS REST services. In order to publish REST services, there is an important need to review the architecture how REST services are published using ArcGIS Server technology.  Based on simple Single Machine strategy,  we need Windows Server, IIS Server (to serve web services)ArcGIS Server Standard or Advanced, ArcGIS Web Adaptor,  ArcGIS Desktop or ArcGIS Pro. 

Why to use ArcGIS Web Adaptor?

  • Allows to integrate Portal for ArcGIS with your organization's existing Web Servers such as IIS, Weblogic.

  • Allows to utilize your existing organization's identity store and security policies at the web-tier. For example you can tie-in active directory users authenticated using integrated Windows Login and ArcGIS portal .

  • Allows to expose ArcGIS Portal through port 80 and 443

Installation steps of ArcGIS Web Adaptor :

  • Verify minimum system requirements
  • Enable HTTPS on web server
  • Install ArcGIS Web Adaptor 
  • Configure ArcGIS Web Adaptor for use with Portal for ArcGIS
ArcGIS Web Adaptor.png
Naren RanganathanComment
ESRI Architecture for Maximo Integration

Here is the hardware list  for ESRI : 

  1. Load Balancer
  2. ArcGIS Web Adaptor
  3. ArcGIS Server
  4. Database  Server

Here is the hardware list for Maximo 

  1. Maximo UI , Maximo App Server, Database Server

ArcGIS Enterprise Implementation - Single Machine and Multiple Machines Architecture

ArcGIS Enterprise Implementation for Single Machine- High Availability - Active

ArcGIS Enterprise Implementation for Single Machine- High Availability - Active

ArcGIS Enterprise Implementation -Multiple Machines - High Availability with Third- Party Load Balancer

ArcGIS Enterprise Implementation -Multiple Machines - High Availability with Third- Party Load Balancer

Naren RanganathanComment
Sync GIS and Maximo

Starting Maximo 7.6, it is easy to configure seamless sync between ESRI and Maximo. 

Steps : 

  1. Configure  and Publish ArcGIS REST services (feature services if you are editing), (map services if you are just viewing)
  2. Log into Maximo 
  3. Go to Map Manager 
  4. Add feature service url
  5. Add individual layer
  6. Configure individual layers by creating GIS objects and also linking them with parent object as Workorder, or Location or Asset
  7. Save 
  8. Save map manager 

Internally for each GIS object, Maximo creates a multiversioned view and manages the updates through Java code behind the scenes. ( Technical tip) . For example if you create a GIS Object with name Valve then internally it creates a Valve_EVW database object. Also you can run SQL queries against this new object. For example you can run "Select count(*) from Valve_EVW;". 

 

 

 

ESRI, GE SmallWorld & Maximo Integration

For the utilities using GE Small World as core GIS software, we can automate extracting data into ESRI format for publishing ArcGIS REST services for Maximo spatial integration or for webmaps for ArcGIS Collector.
 

The geospatial data is extracted from GE Smallworld GIS to ESRI Geodatabase.

The geospatial data is extracted from GE Smallworld GIS to ESRI Geodatabase.

  • GE Small World GIS --> Custom Sync Process --> ESRI --> ESRI REST Services --> Maximo
  • GE Small World GIS --> Custom Sync Process --> ESRI --> ESRI REST Services --> ArcGIS Collector

Please contact us or schedule a call how we can help extracting data from GE Small World GIS.

Maximo Spatial 7.6 Upgrade

Maximo Spatial 7.6 is the latest version from IBM.  With the Maximo Spatial 7.6 release we can install/configure Maximo spatial to use published ESRI REST services to consume, view, edit and analyze using ESRI feature services.  Feature Services allow integration to the ArcGIS Server by only using the ArcGIS Server’s published URLs and will not require a dblink between Maximo and GIS. We can also configure seamless 2-WAY syncing between GIS and Maximo using Out Of the Box Maximo Tool Framework (Cron Task, Escalations, JSON Mapping) for LOCATIONS, ASSETS, WORKORDER, SERVICEADDRESS and SERVICEREQUEST applications in Maximo.

The new spatial release allows to consume published ArcGIS Online, Google and Bing maps as base maps for routing purposes. 

With our in-house benchmark testing we have observed the configuration time to set up Spatial 7.6 has been reduced significantly with the new feature service approach and the initial tests indicate faster load/syncing times compared to DBLINK approach. 

This new release supports Versioned Feature Datasets, Multiversion Views. The sync and edits can be target to a specific workflow version such as "QAQC" Version or "FieldWork" Version.

We also have the capability to upgrade automation scripts into seamless ArcGIS Data sync tasks to sync Assets, Locations, Workorders.

We also can make an assessment of Maximo Spatial upgrades and integrations.

Maximo CU Library (T&D)

This application lists all Compatible units (CU) in Maximo, these are building blocks used to generate an estimate to perform design construction task. 

Possible uses of CU Library (T&D) application:

  • Associate a compatible unit with classification.
  • Search for compatible unit records in the system.
  • Create and modify compatible units, including adding labor, materials, tools and services.
  • Manage child compatible units to the current record and select filter criteria that is used while estimates are generated.
Naren RanganathanComment
Field Data Collection using ArcGIS Collector

As a ESRI partner we design and implement ArcGIS collector for enterprise GIS and integrate with SAP Workmanagement and IBM Maximo systems. 

  1.  Design a geodatabase 
  2.  Design working map by adding layers from ArcCatalog and save ArcMap Document
  3. Save and publish RESTservice -Feature Access Enabled with sync, Update options checked
  4. Login to ArcGIS Online Portal and configure Web Map
  5. In Windows 10 or IPAD or IPhone or any Android Device, search for collector -ESRI
  6. Download it 
  7. Log into Collector App 
  8. Click on the map to open the map
  9. Edits the map and submit. The edits are saved to ESRI Geodatabase through published REST services
  10. Open ArcMap document and review the edits
  11.  Rec and Post edits to default version
  12.  Log into Maximo , make sure ArcGIS Datasync job is started and running.
  13.  Maximo , new Asset/Location is created or existing Asset/Location is updated with new changes

We intend to write a series of ArcGIS collector articles, stay tuned. Please contact us to get more information on our services.

 

Maximo CUE Application

If you want to use Compatible Units and its features to integrate into Maximo Workorder Application, you will need to work with CUE Application in Transmission and Distribution (T&D) module of IBM Maximo. Generally CU estimates are associated with Workorder. A CU estimate without association of Workorder is used only for estimating purpose. 

The Design Tech can create and estimate new scenarios by using CU records in created in CUE application.  For each estimate, the Tech selects the compatible units and applies filters to specify the conditions for each scenario.

In Maximo , you can navigate it to CU Estimating (T&D) application to do the following actions:

  • Search for compatible unit estimates.
  • Create, modify, and view estimate versions.
  • Specify the work to be performed at each station in a request.
  • Search for compatible units within the CU Library by attributes.

We have developed CU library for utilities and automated syncing CU library between GIS and EAM systems. 

Naren RanganathanComment
Simplify bad Geometry

Importing data from external sources such as AutoCAD, Microstation may introduce geometry that ArcGIS does not support, such polylines or polygons with irregular vertices. The simplify command simplifies the geometries of the selected  features to ensure that the geometry is valid.

IGeometry5 cadGeometry = cadFeature.ShapeCopy as IGeometry5;
 ITopologicalOperator3 topoOp = cadGeometry as ITopologicalOperator3;
if (topoOp != null)
{
topoOp.IsKnownSimple_2 = false;
switch (cadGeometry.GeometryType)
{
case esriGeometryType.esriGeometryMultipoint:
topoOp.Simplify();
break;
case esriGeometryType.esriGeometryPolygon:
((IPolygon)cadGeometry).SimplifyPreserveFromTo();
break;
case esriGeometryType.esriGeometryPolyline:
if (cadGeometry is IPolyline5)
((IPolyline5)cadGeometry).SimplifyNetwork();
else
topoOp.Simplify();
break;
default:
break;
}
}
Top reasons to use ESRI File Geodatabase

A file geodatabase is a collection of files in a folder on disk that can store, query, and manage both spatial and nonspatial data. ESRI started this concept when Microsoft announced a 2GB limit for Access geodatabase.  Access databases were primarily used as personal geodatabases. 

ESRI came up with File Geodatabase format to store the data. It is a folder or directory where all the relavant files are put in  and ArcObjects API identifies it as featureclasses, featuredatasets, tables and geometric networks.

  1. Improved versatality and usability - The file geodatabase is stored and organized in folder.  Each featureclass or table is stored in one or more files.
  2. Optimized performance - Although the folder is scrambled with lot of files , the performance is optimized for faster response times.
  3. Storage Limitation - The FGDB is limited to 1TB per instance. With the use of configuration keywords, this can be expanded to 256TB.
  4. Easy data migration - The FGDB can be moved or copied from one place to another by simply copy/paste command.
  5. Improved editing model - FGDB do not lock down the entire geodatabase if the user is editing a featureclass. This model supports single data editor and many data viewers concurrently.
  6. Spatial Index - The FGDBs allow updates to spatial index settings for faster display , edit and query spatial data.
  7. Data Compression - The vector data can be stored in the file geodatabase in a compressed format that reduces storage requirements. Compression reduces the overall size on the disk. The performance of compressed data is similar to the uncompressed data.