Hello Everyone,

I'm working on a project that involves integrating IBM Maximo with an external application, and I'd like to open a discussion on the best approaches for querying data from Maximo - especially in cases where the data retrieval requires complex logic or SQL queries.

Use Case

In my scenario, I want to run a query in Maximo based on parameters provided by an external application. I've implemented a solution using Automation Scripts. Here's what I've done:

• I created an Automation Script in Maximo.

• This script is triggered via a REST API endpoint, and I pass input parameters to it.

• The script then runs a custom SQL query on the Maximo database using those parameters.

• It returns the output of the query as a response to the calling external system.

This approach works well for me because I can execute more complex queries than I could using a standard Object Structure–based integration.

Why Not Object Structures?

While Object Structures and REST APIs are great for standard integrations, they are sometimes limited when:

• The query requires complex joins or filtering.

• You need to aggregate or transform data dynamically.

• The data structure doesn't align well with a single MBO (Maximo Business Object).

My Question to the Community

I know there are several other ways to retrieve data from Maximo in an integration scenario, such as:

• Using OSLC or REST APIs with complex filters.

• Building custom Java code and deploying it as a web service.

• Leveraging Database Views exposed via object structures.

So I'm curious:

What is the best and most efficient way you've used to run dynamic or complex queries from Maximo and return the data to an external system?

Have you used Automation Scripts like I have? Or have you found a better solution for similar requirements?

Looking forward to hearing your thoughts, experiences, and any best practices you can share!

Thanks in advance,
Mohamed Ghareeb
Maixmo Technical

------------------------------
Mohamed Ghareeb
------------------------------

Hello!

If You don't like standard object structures - making relationships and where clause on object it self, which may be harder than writing SQL, then really, only good solution in place of script would be making DB view, and then making simple object structure on it. Then You don't need to run script etc, You just make REST request when needed. 

Take in to notice, that also DB view SQL clause lenght is limited on interface. So not everything is possible. At least I one run it to that issue, that I can't create view, as my SQL clause was too long. 

------------------------------
Juris Flugins
Technical expert
AS Sadales tikls
Rīga
------------------------------

Original Message:
Sent: Sun May 11, 2025 08:42 AM
From: Mohamed Ghareeb
Subject: Best Approach for Querying Data from Maximo via External Integration

Hello Everyone,

I'm working on a project that involves integrating IBM Maximo with an external application, and I'd like to open a discussion on the best approaches for querying data from Maximo - especially in cases where the data retrieval requires complex logic or SQL queries.

Use Case

In my scenario, I want to run a query in Maximo based on parameters provided by an external application. I've implemented a solution using Automation Scripts. Here's what I've done:

• I created an Automation Script in Maximo.

• This script is triggered via a REST API endpoint, and I pass input parameters to it.

• The script then runs a custom SQL query on the Maximo database using those parameters.

• It returns the output of the query as a response to the calling external system.

This approach works well for me because I can execute more complex queries than I could using a standard Object Structure–based integration.

Why Not Object Structures?

While Object Structures and REST APIs are great for standard integrations, they are sometimes limited when:

• The query requires complex joins or filtering.

• You need to aggregate or transform data dynamically.

• The data structure doesn't align well with a single MBO (Maximo Business Object).

My Question to the Community

I know there are several other ways to retrieve data from Maximo in an integration scenario, such as:

• Using OSLC or REST APIs with complex filters.

• Building custom Java code and deploying it as a web service.

• Leveraging Database Views exposed via object structures.

So I'm curious:

What is the best and most efficient way you've used to run dynamic or complex queries from Maximo and return the data to an external system?

Have you used Automation Scripts like I have? Or have you found a better solution for similar requirements?

Looking forward to hearing your thoughts, experiences, and any best practices you can share!

Thanks in advance,
Mohamed Ghareeb
Maixmo Technical

------------------------------
Mohamed Ghareeb
------------------------------

Hi,

All the options you mentioned can be used if the data volume is manageable. If it grows in size in future, that where the challenges can come. In such cases, you can see options such as pulling the data using pagination/rownum so that you fetch certain volume of records at a time if possible. If the records needs to be fetched only twice, thrice or may be once a day and not every minute/hr, you can probably create a view/MV which can be refreshed as per the needs and fetch the data from there.

------------------------------
Suhas Joshi
------------------------------

Original Message:
Sent: Sun May 11, 2025 08:42 AM
From: Mohamed Ghareeb
Subject: Best Approach for Querying Data from Maximo via External Integration

Hello Everyone,

I'm working on a project that involves integrating IBM Maximo with an external application, and I'd like to open a discussion on the best approaches for querying data from Maximo - especially in cases where the data retrieval requires complex logic or SQL queries.

Use Case

In my scenario, I want to run a query in Maximo based on parameters provided by an external application. I've implemented a solution using Automation Scripts. Here's what I've done:

• I created an Automation Script in Maximo.

• This script is triggered via a REST API endpoint, and I pass input parameters to it.

• The script then runs a custom SQL query on the Maximo database using those parameters.

• It returns the output of the query as a response to the calling external system.

This approach works well for me because I can execute more complex queries than I could using a standard Object Structure–based integration.

Why Not Object Structures?

While Object Structures and REST APIs are great for standard integrations, they are sometimes limited when:

• The query requires complex joins or filtering.

• You need to aggregate or transform data dynamically.

• The data structure doesn't align well with a single MBO (Maximo Business Object).

My Question to the Community

I know there are several other ways to retrieve data from Maximo in an integration scenario, such as:

• Using OSLC or REST APIs with complex filters.

• Building custom Java code and deploying it as a web service.

• Leveraging Database Views exposed via object structures.

So I'm curious:

What is the best and most efficient way you've used to run dynamic or complex queries from Maximo and return the data to an external system?

Have you used Automation Scripts like I have? Or have you found a better solution for similar requirements?

Looking forward to hearing your thoughts, experiences, and any best practices you can share!

Thanks in advance,
Mohamed Ghareeb
Maixmo Technical

------------------------------
Mohamed Ghareeb
------------------------------