Maximo

 View Only

  • 1.  Excel or MsAccess for MAS SaaS

    Posted Mon August 05, 2024 04:49 AM

    We are in the progress of migrating the on-prem Maximo 7.6 to Maximo Application Suite (MAS) on the cloud with IBM SaaS subscription. For the on-prem which is using MS SQL database, you could connect excel to Maximo 7.6 and query easily. However, MAS SaaS is a DB2 database and on IBM Cloud. Have anyone able to connect excel or MsAccess to MAS SaaS and how?

    Thanks.



    ------------------------------
    Tee Yeow Hum
    ------------------------------


  • 2.  RE: Excel or MsAccess for MAS SaaS

    Posted Mon August 05, 2024 05:41 AM

    Hi Tee Yeow Hum

    Based on my knowledge it's not possible to connect directly to MAS Manage database in IBM Cloud. Probably it could be possible if you order replica database from IBM (read only).

    Please consider to use MXLoader solution developed by Bruno Portaluri https://bportaluri.com/mxloader that is using Maximo Integration Framework for CRUD actions.

    "MxLoader is a Microsoft® Excel® spreadsheet that allows to quickly and easily query and load data into IBM Manage/Maximo."



    ------------------------------
    Bartosz Marchewka
    IBM Maximo Consultant
    AFRY
    ------------------------------

    Original Message


  • 3.  RE: Excel or MsAccess for MAS SaaS

    Posted Mon August 05, 2024 08:40 PM

    Hi Bartosz,

    Thanks for the reply. Yes, we already ordered the replica database from IBM. So, we are looking at extracting data with excel or MsAccess and wondering whether there are solutions out there.

    thanks.



    ------------------------------
    Tee Yeow Hum
    ------------------------------

    Original Message


  • 4.  RE: Excel or MsAccess for MAS SaaS

    Posted Wed August 07, 2024 03:14 PM

    Hi Tee,

    MXLoader would do what you are looking for, try it out.



    ------------------------------
    Chandan Singh
    ------------------------------

    Original Message


  • 5.  RE: Excel or MsAccess for MAS SaaS

    IBM Champion
    Posted Thu August 08, 2024 10:08 AM
    Edited by Jan-Willem Steur Thu August 08, 2024 10:11 AM

    Tee Yeow,

    We use MXloader to upload any kind of data sets to MAS (regardless whether it's SaaS, On Prem or in any cloud solution (Azure, AWS, Google).

    The only thing you need to have is the URL of you Maximo Manage instance and an API token (create one in Maximo Manage in the API Keys application. So you don't need to have a specific db connection string (jdbc).  Take also into account that loading data via data loader sheets like MXLoader is only possible via REST API, but that is covered if you download the latest version of MXLoader (the Bruno Portulari version 8.x.x). Another possibility is to install the IBM version of MXLoader (in OpenShift as a separate project / container. It works almost as equal as the MXLoader. The benefit of using MXLoader is that you can use it locally on a windows pc / laptop, or outside the OpenShift cluster in a separate windows VM. 

    The benefit of using either MXLoader or IBM's MaxLoader is that every data uploaded is validated against the Maximo business logic, and that avoids that missing data or wrong data (in terms of functional or  technical wrong, so not from a content quality PoV) is loaded, as well as avoiding to load data directly into the database without any validation (which is strongly advised not to do so).

    See here the link how to install the IBM MXLoader version in OpenShift and a screenshot how to connect to your MAS(x) SaaS environment using MXLoader:

    https://www.ibm.com/docs/en/mci/8.1.0?topic=ldimci-deploying-maximo-data-loader-in-red-hat-openshift



    Regards,

    JW



    ------------------------------
    Jan-Willem Steur
    Manager Business Development
    ZNAPZ b.v.
    Breda
    +31 6 25639950
    Jan-Willem
    ------------------------------

    Original Message


  • 6.  RE: Excel or MsAccess for MAS SaaS

    IBM Champion
    Posted Sun August 11, 2024 09:49 AM
    Connecting Excel or MS Access to Maximo Application Suite (MAS) SaaS: A Challenge
    Unfortunately, directly connecting Excel or MS Access to Maximo Application Suite (MAS) SaaS, which uses a DB2 database on IBM Cloud, is not straightforward.
    Reasons for the Difficulty:
    • Database Type: The fundamental difference between MS SQL and DB2 databases presents compatibility challenges.
    • Cloud-Based Environment: MAS SaaS is hosted on IBM Cloud, imposing restrictions on direct database access.
    • Security Concerns: Direct database connections can pose security risks.
    Alternative Approaches:
    While direct connections are not recommended, several alternatives can be considered:
    1. Maximo Integration Framework (MIF):
      • Utilize MIF to create custom integrations between Excel or MS Access and MAS SaaS.
      • Develop custom applications or scripts to extract, transform, and load (ETL) data.
      • This approach offers greater control and flexibility but requires development expertise.
    2. IBM Cloud Data Integration:
      • Explore IBM Cloud data integration services to connect MAS SaaS data with external systems.
      • These services often provide pre-built connectors and ETL capabilities.
      • Evaluate options like IBM Cloud Data Integration or other relevant services.
    3. Maximo Data Warehouse:
      • If available, consider using a Maximo Data Warehouse to extract data into a more accessible format.
      • This approach can simplify data analysis and reporting.

     

    Best Regards,

     

    Rakesh Ghoshal


     




    Original Message