Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  Data - Application Import vs Enterprise Service

    Posted 16 hours ago

    Hey guys,

    Are there any guidelines on when to use data import via  'Application Import' vs data import via an enterprise service (on an external system)?



    ------------------------------
    Tom M
    ------------------------------


  • 2.  RE: Data - Application Import vs Enterprise Service

    Posted 11 hours ago

    Hi Tom,

    Some quick thoughts...

    • Enterprise Services typically run on MIF JVMs/PODs - these often have more memory than the equivalent UI processe - they may even be running on separate nodes
    • MIF JVMs/PODs should not be UI sessions so any JVM level load generated by the transaction wouldn't affect UI sessions - note if the transactions are generating significant DB load then UI sessions can still be affected
    • Importing data can cause lots of memory to be used during the import process so that increases the risk of affecting UI sessions when the data is imported via the UI JVMs - in the wost case it could lead to a crash. The MIF processes will execute the same MIF code behind the scenes but there is likely to be fewer operations competing for resources
    • Using a MIF JVM is likely to mean that there are fewer transactions occurring simultaneously so the logs will be clearer if you need to investigate problems - this is particularly true if you have to analyse the HTTP related log entries e.g. to see which requests were regularly failing / taking a long time / returning a lot of data


    ------------------------------
    Mark Robbins
    Technical Design Authority / IBM Champion 2017 - 2025
    Cohesive (previously Vetasi Limited)
    https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
    ------------------------------



  • 3.  RE: Data - Application Import vs Enterprise Service

    Posted 5 hours ago

    Expanding on Mark's response, application import was intended for small data update scenarios. For example, a user exporting 50 records from the list tab, updating something on them, and then importing the changes. It is processed sequentially and as a single transaction. Meaning one bad record will fail the entire import. This information is only displayed to the user and there is no ability for an admin to see/correct any issues with the import.

    Enterprise services use the JMS queues which can be setup to be sequential or continuous depending on the import. When continuous, message driven beans execute multiple threads in parallel. The amount is configured when you setup your EJB files and is based on the number of JVMs. Phrased differently, you could potentially be processing 50 messages on a single JVM system and 200 messages on a MIF cluster with 4 JVMs. This will obviously perform significantly faster than a sequential thread processing messages. 

    When something in the JMS queue fails, it will be in the message reprocessing application. In the case of a sequential queue, no other messages will be processed until the error is corrected or deleted. In the case of a continuous queue, Maximo will continue to process other messages in the queue. 

    Enterprise services are typically used in ongoing integrations (not one-time imports) where the data is populated automatically via some mechanism (web service, flat file, IFACE table, etc.). Application import is a user-initiated activity, though there are some capabilities in the REST API for file imports that blur the lines a bit. 

    Less significant but something else to be aware of, application import can only work with object structures that have a main object that matches the main object of the application. For example, if you wanted to use application import in WOTRACK, the main object must be WORKORDER. There are some scenarios (things like measure units for example) where it would be logical to have an import in an application like INVENTOR but would not be possible. You could, however, import them as enterprise service



    ------------------------------
    Steven Shull
    Principal Maximo Solutions Engineer
    Naviam
    Cincinnati OH
    ------------------------------



  • 4.  RE: Data - Application Import vs Enterprise Service

    Posted 4 hours ago

    Both seems to be almost same usage but Application Import can be used when there are comparatively less number of records whereas Enterprise system can be used where there are unlimited number of records or bulk data from business.



    ------------------------------
    Arya RV
    ------------------------------