Thanks for the feedback. My performance concerns come from reading the AIE user guide, page 22:
"While it is easy to add field mappings or extra rules for each field, remember that each item you add is compared against every record in your database." So, for example, if during a people record update, I want to compare two fields, say Phone Number and Address, from a source and target, the AIE will search the DB for a matching userid, then check the phone number for a difference. Then it will do another search for the same userid to check for Address. And so on for every field I have mapped? That sounds like a cartesian search. Or am I way off base, and can that be controlled in some other way? It looked like there was a high learning curve for AIE, so I wanted to make sure it was worth even messing with before spending too much time on it. Sounds like it is. Thanks everyone, Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Shyam Attavar" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 12/05/2007 06:50 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Atrium Integration Engine ** We are using AIE to bring in data from an external Inventory Database (not one that has a predefined mapping). The good thing is the mapping is simple to create, since the CMDB CDM classes are readily available. However, the bigger challenge for us was to get the external data (which is in a flat data structure) organized in such a fashion as to map to the CDM. We have been doing incremental get from the source data and building relationships. I have not really seen any performance issues. However, the UI is clunky and counter intuitive (in many places). But once I figured out the ones that I cared about, it was easy to get used to... BTW, we also have BMC Topology Discovery and that has an automatic feed into the CMDB via the CMDB API. However, there is no control over what data goes into the CMDB -- and this has been a drag for us, since anything that was discovered was dumped into CMDB, so drawing meaningful conclusions from the CMDB has been a royal pain, especially when trying to provide a simple way for the Service Desk to use this data in a simple manner. So, building another set of AIE jobs to bring data from TD, instead of using the OOB integration is an option we are considering instead of writing another set of API programs to do what TD is already doing. Cheers, -- Shyam ----- Original Message ----- From: Thad K Esser Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, December 05, 2007 11:56 AM Subject: Re: Atrium Integration Engine ** And I'd be one of those that have used Croom's product successfully (in a previous life). Its a great product. I think one of the pieces I was missing was that AIE offers adapters to link different types of databases (I see that in the manuals now - it just didn't register with me the first time through). But other than providing those links, I'm not getting how it simplifies an integration or offers performance improvements over building my own? Does it come with predefined mappings for CMDB? It seems I'd still have to create all those anyway. Apparently, I'm being dense this week - I appreciate the patience. Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Gidd" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 12/05/2007 11:07 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Atrium Integration Engine Drew, The other alternative is of course to use Croom Consulting's Link to External Databases which is an ARDBC-Plug-in and it comes in many popular flavors DB2, Oracle, Sybase, MS SQL, MySQL and etc. http://www.buoyantsolutions.net/External_DB.html There are many on this list that have used this solution successfully. Regards...Gidd -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Wednesday, December 05, 2007 9:23 AM To: arslist@ARSLIST.ORG Subject: Re: Atrium Integration Engine Thad, AIE provides a decent integraion point between Remedy and other databases. The interface is a little clunky, but it does what it's supposed to do. The alternative is to write your own interfaces. Drew On Tue, 4 Dec 2007, Thad K Esser wrote: > Hello, > > I'm looking for some input on the value of the Atrium Integration > Engine - trying to decide if I want to use it or not. In reading > through the manuals, it seems overly complicated and not all that > efficient, but if someone can tell me its the next best thing since > sliced bread (and mean it), I would appreciate your thoughts. > > ARS 7.1 > CMDB 2.1 > ITSM 7.0.2 (minus AM) > > Thank you, > Thad Esser > Remedy Developer > "Argue for your limitations, and sure enough, they're yours."-- > Richard Bach ***IMPORTANT NOTICE: This communication, including any > attachment, contains information that may be confidential or > privileged, and is intended solely for the entity or individual to > whom it is addressed. If you are not the intended recipient, you > should delete this message and are hereby notified that any > disclosure, copying, or distribution of this message is strictly > prohibited. Nothing in this email, including any attachment, is > intended to be a legally binding signature.*** > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"