The 7.6.04 AI can’t access the Remedy forms directly – this is what Carl is referring to.
Only the CMDB can be accessed. However, you can use AI to access the database tables directly. If you can copy the complete database record (Request ID, submitted and modified dates, etc) from the source server to the destination server then this should be quite straightforward. It would be a little more complex if you have clobs. It’s also easier if you don’t have status history enabled as you don’t then have any H records. Cheers Peter From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: 28 July 2014 16:49 To: [email protected] Subject: Re: Installing Atrium Integrator on 7.6.04 system ** Follow-up question, Carl. We are wanting to use AI to move data between non-ITSM servers and a separate Data Warehouse. Our scenario would work like this: * On a custom form on a custom AR Server, a record is saved. * That action initiates a Filter that populates a local copy of the UDM:Execution form on the custom AR Server. * That Filter calls a Web Service on the AI server, pushing the data from the custom UDM:Execution form to the real one on the AI server. * The AI job called on the AI server gets data from the custom server and moves it into the DW DB using connection data already configured in the job/transformation. Given those circumstances, could we use the 7.6.04 version of AI (installed on a 7.6.04 AR/Atrium/ITSM server), since AI is only being used to process jobs from other servers, and no local data is being read or written? Rick On Fri, Jul 25, 2014 at 5:37 PM, Carl Wilson <[email protected] <mailto:[email protected]> > wrote: ** Hi Rick, The functionality in the version of Pentaho that was integrated for 7.6.04 didn't have the extended feature set of the later versions (adapters/connectors). The plugins were re-written and the functionality was extended to include the additional connectors/adapters in 8.x. AIE / AI on 7.6.04 was pretty much on par, once 8.x came along AI overtook AIE on functionality/versatility/scheduling/etc. _____ Kind Regards, Carl Wilson From: Action Request System discussion list(ARSList) [mailto:[email protected] <mailto:[email protected]> ] On Behalf Of Rick Cook Sent: 26 July 2014 01:24 To: [email protected] <mailto:[email protected]> Subject: Re: Installing Atrium Integrator on 7.6.04 system ** Wow, I forgot about that. That might be the deal breaker there. What was the reason that custom forms wouldn't work? Hard coding in the binaries? Rick On Jul 25, 2014 9:42 AM, "Roger Justice" <[email protected] <mailto:[email protected]> > wrote: ** AI was loosly integrated with 7.6.04 and it has limited functionality since it only worked with CMDB and none of the ITSM fors. AI for 8+ is fully integrated and works with all forms in ARS. -----Original Message----- From: Rick Cook <[email protected] <mailto:[email protected]> > To: arslist <[email protected] <mailto:[email protected]> > Sent: Fri, Jul 25, 2014 12:39 pm Subject: Installing Atrium Integrator on 7.6.04 system ** Has anyone out there installed Atrium Integrator on an existing 7.6.04 ARS/ITSM system? The 8.x install documentation specifies that AI must be installed between CMDB and ITSM. The 7.6 docs I've seen don't really seem to say much about AI until you start talking about upgrading it. Also, the BSM Interoperability Matrix indicates that 7.6.04 SP2 is required at all levels to have AI installed at all, the retrofit question aside. Can anyone confirm or refute that? We're on 7.6.04 SP1, and I fear that we're stuck with AIE until we upgrade. Thanks. Rick Cook _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
