2/01/2015

Maximo Integration Framework (MIF). Which Components to Use?

How do I determine which integration components to use for my integration scenario?
This is a common question for those who are not familiar with the I-F.  Reasons for choosing the use of certain I-F components is often decided based on one or more of the following:
  1. The integration capabilities of the application being integrated to Maximo
  2. The integration skills of the developers who will implement the integration
  3. The need to have the integration processing occur in a synchronous or asynchronous manner
  4. What level of error management is required and what level is supported by the external application
  5. Do integration messages need to process based on events (ie. approval of a Work Order)
  6. Does the integration need to operate in a batch or real-time (near) mode.
  7. Is the I-F being used to support implementation data loading
  8. Will the integration be deployed using a common ESB layer within your enterprise
The above list is not intended to be all-inclusive, but it should give you an idea of the types of things to consider when planning integration with Maximo.  Keep in mind, large integration deployments could involve many systems and require different integration components to be used for different external applications.

1/27/2015

CI Classification - Export to XLS

CI classification with attributes names: Link to XLS file

SQL Query script:
select
main.classificationid CIROOT, main.classstructureid CI_ID,
chold1.classificationid CH1, chold1.classstructureid CH1_ID,
chold2.classificationid CH2, chold2.classstructureid CH2_ID,
chold3.classificationid CH3, chold3.classstructureid CH3_ID,
chold4.classificationid CH4, chold4.classstructureid CH4_ID,
CASE WHEN chold4.classstructureid is not NULL THEN chold4.classstructureid
ELSE CASE WHEN chold3.classstructureid is not NULL THEN chold3.classstructureid
ELSE CASE WHEN chold2.classstructureid is not NULL THEN chold2.classstructureid
ELSE CASE WHEN chold1.classstructureid is not NULL THEN chold1.classstructureid END END END
END CHECK_ID,
specification.assetattrid SPEC_ATTR
from classstructure main
left join classstructure chold1 on chold1.parent = main.classstructureid
left join classstructure chold2 on chold2.parent = chold1.classstructureid
left join classstructure chold3 on chold3.parent = chold2.classstructureid
left join classstructure chold4 on chold4.parent = chold3.classstructureid
left join classspec specification on specification.classstructureid = (CASE WHEN chold4.classstructureid is not NULL THEN chold4.classstructureid
ELSE CASE WHEN chold3.classstructureid is not NULL THEN chold3.classstructureid
ELSE CASE WHEN chold2.classstructureid is not NULL THEN chold2.classstructureid
ELSE CASE WHEN chold1.classstructureid is not NULL THEN chold1.classstructureid END END END
END)
where main.classificationid = 'CIROOT'
order by CIROOT, CH1, CH2, CH3, CH4, SPEC_ATTR

For update data from your database you need to update your connection settings:

1/20/2015

Good news for Report Developers who cannot execute reports using BIRT Report Viewer on Internet Explorer 11 (Win 8.1)

To resolve the issue of blank window when I try to execute report using BIRT Report Viewer on Internet Explorer 11, I do next steps:
  1. Run regedit.exe
  2. Open "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main\FeaturControl\FEATURE_BROWSER_EMULATION"
  3. Add "DWORD (32-bit) Value": "jawaw.exe=9000" (https://flic.kr/p/pVA62s)
  4. At the end of elipse.ini add following entry:
-Dorg.eclipse.swt.browser.DefaultType=ie
-Dorg.eclipse.swt.browser.IEVersion=9999
(https://flic.kr/p/pVP4zx)

Run eclipse.exe, execute report. I have following result: https://flic.kr/p/qA1Ztj