Maximo Integration

Expand all | Collapse all

Showing data cached in an automation script on the UI in a table

  • 1.  Showing data cached in an automation script on the UI in a table

    Posted Thu September 16, 2021 10:19 AM
    Hello,

    I am trying to create an interface on my UI where having a table and a button.
    When the user presses the button, my script will call an external API, process it and get the desired data from it.
    In the end, I want to show the user the return of this API in a table.
    Is there a way I can do that BUT without having to insert the data into the database.
    We are trying to do this without having to store any of the data returned from the API into our database.

    Is this out come possible?

    Your support is always highly appreciated.

    ------------------------------
    Mahmoud Hossam
    ------------------------------


  • 2.  RE: Showing data cached in an automation script on the UI in a table

    Posted Thu September 16, 2021 03:46 PM
    Mahmoud,

    Yes, Maximo allows you to do that using non-persistent objects.

    To show the data on the screen, you'll need to use the Database Configuration application to create Maximo objects and attributes to hold the data just as if you were going to create them as tables/columns in the database.  When you create the object(s), though, make sure to unselect the "Persistent" checkbox on the Object tab.  This tells Maximo that the data will only be stored in memory for the application and never in the database.

    Once that configuration has been applied, your code can load the non-persistent objects in the same way you would load data that was going to get stored in the database.  You can use the Application Designer to add those records to the screen just as if they were regular records stored in the database.

    ------------------------------
    Adam Davis
    Maximo Consultant
    Asset Partners
    Chicago IL
    312-224-8300
    ------------------------------



  • 3.  RE: Showing data cached in an automation script on the UI in a table

    Posted Sun September 19, 2021 04:04 AM
    Your use case perfectly matches federated Mbo feature of Maximo.

    Federated MBO feature was added IBM help customer call external rest api and display data from it.

    https://www.ibm.com/docs/kk/mam/7.6.0.9?topic=applications-federated-mbo-integration

    You do not need to write a script using federated mbo as Maximo handles the request and processes the response into a table.

    Have a look at the federated mbo feature. It is pretty cool

    ------------------------------
    Biplab Choudhury
    Maximo Consultant
    Tata Consultancy Services
    Melbourne
    ------------------------------



  • 4.  RE: Showing data cached in an automation script on the UI in a table

    Posted Mon September 20, 2021 08:57 AM
    Hi, Recently we implemented Federated MBO (REST API Call) feature in Maximo for one of the user story.
    User story: When user selects Item in Inventory/BOQ application and navigates to view Item availability tab in select action menu then display the Item details(Item quantity, store lock Id...etc) which is fetched from SAP S4 HANA. The data should not be stored in Maximo database.

    Implementation: We have created a JSON Resources application in Maximo. while creating It will ask End point URL and JSON data based on given end point URL it will creates a End point in endpoint application(we have to provide username&pwd) and based on JSON data it will creates a Non - persistent objects and corresponding fields in Maximo database configuration then we created a relationship. Then created a new Tab in view Item availability dialog name with "SAP PROJECT STOCK" and created a table in this tab to display the Item details and mapped the fields in Application Designer application. To pass dynamic parameters(ITEMNUM) for each request API call we have used attr:relationshipName.FieldName(ITEMNUM). It is working as expected.

    This may helpful !

    ------------------------------
    Venkatrao Yenuganti
    ------------------------------



  • 5.  RE: Showing data cached in an automation script on the UI in a table

    Posted Wed September 22, 2021 10:39 AM
    @Venkatrao Yenuganti This is interesting..... Question:  does your integration extend all the way across Maximo?  I ask specifcially about reservations on Work Orders.  Historically this is done against Maximo objects.  If your integration does not populate the Maximo objects (for which it was designed to operate,) how do you manage the work management demand side of the Supply chain equation? ​  Since you mention "it will creates a Non - persistent objects and corresponding fields in Maximo database configuration " I am curious, how does that affect other functionality in Maximo? 

    Does this integration only provide real time look into item availability?  It occurs to me that if you are doing that, then you are NOT doing any kind of material management in Maximo, correct?  This approach is fine to a certain extent but makes it very hard to perform demand management and work scheduling in Maximo with all part information NOT stored there.  Which is why historically integrations have brought the relevant data down to Maximo, so the rest of Maximo will work as intended.  How are you doing this?

    ------------------------------
    Bradley K. Downing , MBA
    Solutions Engineer
    IBM
    Bakersfield CA
    ------------------------------



  • 6.  RE: Showing data cached in an automation script on the UI in a table

    Posted Fri September 24, 2021 01:43 PM
    Hi Sir @Bradley Downing
    Yes, you are correct this integration only provide real time look into item availability. we are NOT doing any kind of material management & work management demand side of the Supply chain equation by using this API call. Yes I am with you This approach is fine to a certain extent but makes it very hard to perform demand management and work scheduling in Maximo because response NOT stored in Maximo. We have implemented this only for user prospective(Maximo user wants to know Items Availability in SAP) , it does not affect any other functionality in Maximo.
    This is just real time request and response, we can implement this all the way across Maximo.


    ------------------------------
    Venkatrao Yenuganti
    ------------------------------



  • 7.  RE: Showing data cached in an automation script on the UI in a table

    Posted Fri September 24, 2021 02:13 PM
    So then I guess the next question is : is this in addition to integration that DOES provide Maximo with a mirror of what is in SAP?  Because if it is it occurs to me that this REST approach could / should replace perhaps an older style / slower / batch cron job of integration.  Is that what your approach is doing/ going to do?

    ------------------------------
    Bradley K. Downing , MBA
    Solutions Engineer
    IBM
    Bakersfield CA
    ------------------------------



  • 8.  RE: Showing data cached in an automation script on the UI in a table

    Posted Fri September 24, 2021 03:32 PM
    Yes Sir @Bradley Downing It is a one of the Integration feature provides a real time data from external systems for visibility.

    Below URL's has more info..
    https://community.ibm.com/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=4fa7e9e0-5dd7-af59-3287-7f527cf125b8
    http://vietmaximo.blogspot.com/2018/03/federated-mbo-filling-gap-between.html

    Our Implementation:
    Received Item Details from SAP S4 HANA


    ------------------------------
    Venkatrao Yenuganti
    ------------------------------