Maximo

Maximo

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

 View Only
  • 1.  Maximo interface to an Automated Storage Retrieval System (ASRS)

    Posted Tue February 21, 2023 09:11 AM

    I'm totally new to Maximo but not to databases, apps, software design, communications, & interfaces. That aside, hoping someone here has some Maximo info to help.

    I
    have an inquiry from a large corporation using Maximo to interface to an Automated Storage Retrieval System (ASRS). I'm the expert on the ASRS which has a RS232 serial communication interface from 30 years ago (yes this machine was built quite well & still working great).  I have access to the interface protocol documents for an old terminal hookup, so that path is a known quantity and can be exploited for such integration.  Though I suspect there might need to be a go-between software on a PC/etc to convert the Maximo messaging to/from the ASRS thru that channel.

    What I would need to know is the possibilities from the Maximo system to determine if and how such interface is achievable.  Like whether such options are add-on or included, configuration of that (I suspect there's some docs available), or if those things require a Maximo expert onsite and, if so, what that would entail.  These days I would expect an XML/JSON/etc data exchange via network.

    I think the bigger question is what to ask the customer to find out what if anything their Maximo setup has and what they're willing to do on their end should they wish to pursue this.  For me, I just need to ask the right questions. They do have other equipment (tons of automation there) so maybe they've done similar for other storage type systems onsite.

    In short, looking for some Maximo insight from anyone here who has worked out a similar solution... Thanx in advance.



    ------------------------------
    John Schleider
    ------------------------------

    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Maximo interface to an Automated Storage Retrieval System (ASRS)

    Posted Tue February 21, 2023 03:31 PM

    ...probably helps to add that the Maximo purpose here is from the customer's inventory control.  As in they have parts in the ASRS bin locations (& other areas) and they wish to have those parts picked and delivered the offload for parts within the ASRS storage area.  Not sure yet if their wish is to have a Maximo terminal/PC/etc at the ASRS (most sensible) or tie-in to other means of delivering the parts via automation/etc (which requires far more than Maximo if so).

    For now, just need guidance on what Maximo can do for interface to external systems (the ask here) and how much work required to achieve the customers goal (after review of help here & further inquiry to the customer).



    ------------------------------
    John Schleider
    ------------------------------



  • 3.  RE: Maximo interface to an Automated Storage Retrieval System (ASRS)

    Posted Wed February 22, 2023 09:12 AM

    John, 

    MadMax IoT has an off the shelf connector to share data between automation systems and Maximo. You mentioned RS232, I'm guessing the ASRS system is using the Modbus protocol then? 



    ------------------------------
    stephen lemaster
    ------------------------------



  • 4.  RE: Maximo interface to an Automated Storage Retrieval System (ASRS)

    Posted Wed February 22, 2023 12:33 PM

    Just looked at the MadMax IoT overview/demo video & seems more a middleware that would not necessarily provide any benefit here as it only aggregates I/O status from devices with Modbus or other standard interfaces.  And, then another thing to manage & potentially add difficulty should there ever be any connectivity problems between the ASRS & Maximo, not to mention additional hours or days of setup & testing.

    The ASRS has its own protocol from the 1980s where a dumb terminal would pass keystrokes via RS232 & the ASRS would manage the keystroke/chars until the pick/store/etc message was formed, then execute & reply whatever to show on the terminal screen.  Of course it does not matter if those ASCII characters came in at the speed of keyboard pecking char-by-char or as fast as the complete keyed message.

    Saying that, the interchange would simply need to be that of the ASRS interface protocol in a way the ASRS could not tell the difference of a terminal or something emulating it.  That will likely be a custom middleware to talk to the Maximo system via network connection on one side & the ASRS via serial on the other side.

    So it's either the custom middleware OR a customization, configuration, etc of Maximo to effect the ASRS interface.  Either way, I would need to know if Maximo can do that or anything else in the Maximo environment or app dealing with such interfaces.  Also, some detail of if/how actionable events can be triggered from something like an inventoried part screen where the user effects a request of parts from stock.

    So anything along those lines anyone in the Maximo group can shed light on, like links to document pages/etc or other via experience, is what I'm looking for.  Or better said trying to minimize the haystack to find the few needles of interest (right now it seems like I have a few barns & not sure if such needles exist).  Anyway, thanks for the info in case its part of the need here.



    ------------------------------
    John Schleider
    ------------------------------



  • 5.  RE: Maximo interface to an Automated Storage Retrieval System (ASRS)

    Posted Thu February 23, 2023 10:07 AM

    Hi John,

    If I understand correctly, you are looking for the solution to integrate Maximo with ASRS, it will involve in inbound and outbound (from Maximo perspective). There are pretty flexible solutions in Maximo to integrate external system through Maximo Integration Framework (MIF). If you would like to implement event trigger outbound Message integration in Maximo, Public Channel (PC) is the right option. Enterprise Service (ES) can be leveraged to be inbound entry point in MIF. And you can develop customized business logic in the user exist java class in PC and ES in Maximo.

    For your case, looks like the ASRS protocol are pretty unique, not sure if the customized user exist java class can handle it. I would recommend you to consider leveraging middleware between Maximo and ASRS. For the middleware option, you can consider mulesoft, oracle fusion , etc. Or if you consider your ASRS as IoT device, can connect to IoT cloud platform, such as Azure IoT, you can develop Azure Functions to play middleware role. Here is the blog I wrote recently, hope it can provide some hint to you. 

    https://jackyqiubao.medium.com/azure-iot-integration-with-maximo-part-1-b141c4210db0?source=friends_link&sk=5345c390bd704aff8349231bbef7ec7d

    https://jackyqiubao.medium.com/azure-iot-integration-with-maximo-part-2-1200d2e2ad5b?source=friends_link&sk=b79fe9dca04db0ce3d69e27f9471a571



    ------------------------------
    Jacky Qiu
    Technical EAM Director
    Stellar Services
    Atlanta, GA
    ------------------------------



  • 6.  RE: Maximo interface to an Automated Storage Retrieval System (ASRS)

    Posted Thu February 23, 2023 11:51 AM

    John,

    Wow! 1980's RS232 Awesome! I get to go back to my youth!!  For you serial protocol keystroke emulation, I understand you need to have a properly formatted message to go from Maximo to ASRS and then a reposes generated by ASRS to come back to Maximo.  As @Jacky Qiu mentioned the MIF tool will likely provide you the correct inbound and outbound formatting.  I would start with publish channel and send you outbound json or xml message that way to start.  If you need to manipulate the message prior to publishing it you can likely call an automaton script first (rather than a custom Java class), thus making the entire communication eligible for promotion from a Dev or Test system into production through Maximo's native Migration Manager.

    OK so now that we have solved that problem..... (hahahaha!) no onto the formatting and sending back the confirmation message.  That will take some more work.  The response message will need to be converted into some king of object in Maximo. have you mapped this out in a process flow yet? Has your team engaged with a technical professional with deep integration skills in Maximo?

    Are you aware that IBM has a Client Engineering team that likely could assist you with a Minimum Viable Product in a short term engagement?  Are you aware of who your Brand Technical Specialist is from IBM, who can help you engage with the right business partner team and IBM team to help you solve this problem?  If not DM me and I will look into this and connect you with the right team.

    "How can I help?"



    ------------------------------
    Bradley K. Downing , MBA
    Senior Brand Technical Specialist
    IBM
    Bakersfield CA
    ------------------------------



  • 7.  RE: Maximo interface to an Automated Storage Retrieval System (ASRS)

    Posted Thu February 23, 2023 08:21 PM

    Appreciate the insight, though it seems this Maximo portion might be as much a major task of the integration as what seems to be a middleware design translating the interchange between Maximo and the ASRS. I'd be really interested in seeing an example of a similar integration, like a protocol document showing a sample Maximo JSON/etc message interchange of a task request, as well as maybe a Maximo screen where an inventory action like "quantity of parts" requested would be derived from.

    Without taking a deep-dive into Maximo to get a summary idea of this, its looking like a major undertaking. And maybe it is, but for now I'm just trying to get an idea of if such a task is days or weeks or months to make the integrations effort. If too many details and personnel are required to manage this, it would be a definite no-go given how its hard to find people with a work ethic to embrace and properly manage the customer side of this. I just need to get enough understanding to at least tell the customer what's needed on their end to work with that on my end (the ASRS and whatever middleware).

    From the responses so far, it seems the project needs a Maximo expert on the customer end to determine what their Maximo setup has and can do towards this integration. But I'll also need to be able to ask rational questions about their Maximo setup, hopefully without the deep-dive or poring through all the great things Maximo can do just to find the tidbit of my interest. As mentioned, I have expertise in software and have coded many communication interfaces, serial and network, but just don't have the time to spend what appears to be days to understand all that Maximo can do & determine how it can here. Saying that, I appreciate any links to examples to get that "aha" overview.



    ------------------------------
    John Schleider
    ------------------------------



  • 8.  RE: Maximo interface to an Automated Storage Retrieval System (ASRS)

    Posted Sun March 19, 2023 12:38 PM

    I'm guessing the best summary request on this thread is if anyone with Maximo & external systems expertise can provide an example block diagram or anything that shows Maximo system on one side, with typical apps or features needed there, and external system on the other.  I expect there would be a messaging, in network packet(s) or various other methods, between the Maximo side and the external system.  Perhaps a sample message structure or interchange along with an outline of the Maximo interface parts performing this would be the easier ask here.  If anyone has examples they can share or links to such diagrams, that would be of most help here.

    I know what can be done on the ASR-side of things and have an idea of what to expect (converting a networked message via middleware to do the back/forth messaging).  I'm just not sure what to ask from the customer, per not having Maximo experience or expertise, on assumption they don't have onsite staff to explain what they can or are willing to do regarding their ask of the integration possibilities.



    ------------------------------
    John Schleider
    ------------------------------