How to watch any events occurred in SQL Server and integrate it with Maximo

Question

I have a request to integrate Maximo with another system which use SQL Server DB, let's call it System 1 System 1, add or update person in database, i want to watch this change and create or update person record in Maximo accordingly, Any suggestions of how to implement this scenario? Also, i have heard about Integration Composer, can it help?

Thanks in advance,

Answer 1

You can create a CLR (trigger) appication in Visual Studios that listens to SQL Server database insert, update and delete

In VS Click start -> New Project -->Database --> SQL Server --> Visual c# CLR Database Project.

You can read some online tuturials to get started

link: http://blog.sqlauthority.com/2008/10/19/sql-server-introduction-to-clr-simple-example-of-clr-stored-procedure/

Answer 2

What version of Maximo are you using? In 7, the Maximo integration framework (mif) allows you to integrate via csv, XML, or interface table. You use the Maximo mbos (Maximo business objects) so validation is performed by the application. Inserting data via database is possible but that can cause issues.

For example, email address and phone is stored in a secondary table (non persistent field). You have to be careful if you are inserting data via the back end. Using mif, you would not have these data integrity concerns.