I have had the opportunity of loading data from HP (Novadigm) Radia using AIE into our CMDB and reconciled that with the data from Topology Discovery. Although this is not necessarily AC, We had to do something similar to what Rick has recommended below. We got the data dictionary for Radia (which has a fairly normalized data model) and using the primary keys created a few Oracle DB views to pull all the data needed to map what is in the CDM. Again, performance is something we always kept an eye on from a reconciliation perspective.
HTH, -- Shyam ________________________________ From: Rick Cook <[email protected]> To: [email protected] Sent: Wednesday, June 24, 2009 1:04:52 PM Subject: Re: AIE and HP's Asset Center ** Marty, I have a bit of experience with what you are trying to do. One thing you should be very careful about is that the data types used by AC are not necessarily compatible with those used by Remedy. Ask the AC admin to get you a data dictionary - it should be in the HP docs. Once you are past that, and the vastly different (i.e. extremely normalized) data model, the rest should be pretty standard. However, I suspect that the normalization in HPAC will cause updates to any core data to cause significant performance issues, so be careful what you send it. Rick On Wed, Jun 24, 2009 at 12:50 PM, Marty.Thorin <[email protected]> wrote: ** I realize this question is a bit more generic than my normal questions. I have co-worker trying to connect Asset Center to Remedy 7.5. This is the product HP got then they purchased Peregrine. (No jokes please. I rode out the Peregrine debacle.) She is trying to follow a manual for connecting EIE to Asset Center that was supplied by our first level support. Additional information: Remedy: 1. Version 7.5 Patch 1 on everything: ARS, CMDB, ITSM, SLM. (Okay, SLM is just 7.5 because it does not have a patch 1.) 2. Oracle 10g database 3. Redhat Linux. Asset Center 1. Asset Center version 4.4.1. 2. Windows 2003 server. 3. Oracle 10g database. Using AIE we can reach the Oracle database for Asset Center. The table on the left is full. We can click on the >> and additional items show on the right. But I do not know how to view the contents nor update the data. The objective is to exchange data between the two. Scheduled bulk updates would be fine. I am probably missing something incredibly simple. Thorin _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
