This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I've had a request to have a dynamic list of information, that is generated in an application separate from Maximo, and have that information saved in Maximo when an SR is submitted. So when the SR is processed/reviewed, that field can be used to reference back to the other application for more details if needed.
Has anyone needed to use/populate data from another database back into Maximo? If so, can you give a high level summary of how you did it and what drawbacks you've had using that method - triggers to create/populate Maximo table/date, cron task to run update scripts, etc.
Hi,
It should be quite straight forward. Something like this:
1) Create view in Maximo that points to external DB (I use a table to build View from it)
2) Link SR to the view
3) Create cross reference link on SR (you would probably need a new field, cross over domain on this field pointing to the view and insert into MAXLOOKUPMAP table)
Cheers,
Alexey
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> I've had a request to have a dynamic list of information, that is generated in an application separate from Maximo, and have that information saved in Maximo when an SR is submitted. So when the SR is processed/reviewed, that field can be used to reference back to the other application for more details if needed.
>
> Has anyone needed to use/populate data from another database back into Maximo? If so, can you give a high level summary of how you did it and what drawbacks you've had using that method - triggers to create/populate Maximo table/date, cron task to run update scripts, etc.
>