Join / Log in
Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.
Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.
Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.
Hi Tom,Not sure if you got an answer to this question but one idea that I have seen working is a separate SQL data warehouse which sucks in the data from all the Maximo databases using SSIS.Using SSIS you can the transform the data so that all the different data structures from each database can all fit into the same data warehouse database. Then using SSRS to create all the reports you need from that.If you want to take if further, you could then add products such as Power BI to allow the users to create their own reports/cubes that don't have any detrimental effect to Maximo or Data Warehouse performance.Then create a custom app in the Maximo systems that directly links to each SSRS report if needed. That way the users don't have to leave Maximo to run the SSRS reports.Thanks,Matt