Maximo to Datastage

mmahes · Post by **mmahes** » Tue Dec 02, 2014 6:54 am

Hi All,

We have a requirement to read the data from IBM's Maximo Software using Datastage as an ETL tool. please could you help what would be the easy and cost effective way in fetching the Maximo data in to the Datastage and process it.

To my mind I have following options but sure which one works or best suits my requirement:

Option 1: Web service
Option 2: Extract an XML file from Maximo and use that as source
Option 3: Find if any ODBC connector will establish a connect to Maximo and fetch the require data.
Option 4: Create a csv file from Maximo and read from Datastage

Please suggest which option is practically possible and can be used as good solution.

Regards,
Mmahes

chulett · Post by **chulett** » Tue Dec 02, 2014 8:29 am

So... Maximo as in IBM's Maximo Asset Management? Or the one that is "the basis of Tivoli Process Automation Engine, which is the central part of Tivoli Service Automation Manager." Seeing as how IBM owns those tools they might be the best one to ask unless someone here has actually done this already.

mmahes · Post by **mmahes** » Tue Dec 02, 2014 10:15 pm

I am want to know for IBM's Maximo Asset Management in this question, please guide.

qt_ky · Post by **qt_ky** » Wed Dec 03, 2014 6:59 am

Check Maximo documentation and support to see which options they support and recommend.

chulett · Post by **chulett** » Wed Dec 03, 2014 8:46 am

chulett wrote:Seeing as how IBM owns those tools they might be the best one to ask

ray.wurlod · Post by **ray.wurlod** » Wed Dec 03, 2014 3:36 pm

I think the CSV extract processed by DataStage would offer the best performance, and invoking Maximo via its web service the worst.