I see no reason why you can’t do what you trying to do.
AI on 7.6.4 saves transformations in its own database and is therefore not dependant on any AR system databases. If you don’t choose a CMDB connector then there’s no interaction with Remedy at all. I did a transformation that imported a csv file directly to a Remedy database table and that saved OK. I don’t know why your transformation won’t save. I guess you’ve tried removing the steps one by one to see if one of the steps is causing the issue? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: 30 July 2014 17:02 To: arslist@ARSLIST.ORG Subject: Re: Installing Atrium Integrator on 7.6.04 system ** OK, let me try to ask the question better. I do understand that the CMDB limitation is for files on the local (AI) server. BUT: If the data that AI 7.6 is processing is read from one remote server and written to another, and NO data is read from or written to the local 7.6 AI server, could that 7.6 AI server run the jobs, even if the data was not from or to CMDB forms? To be even more clear, I am looking for AI 7.6 to simply be a platform to run jobs between other sets of servers. Would the CMDB limitation prevent me from creating Transformations against non-CMDB forms on other servers? I'm trying to understand exactly where the limitation is enforced. >From a practical perspective, I CAN access the forms/fields on both ends of >the remote data chain I described. What I cannot currently do is SAVE that >Transformation. I get an "Error 288: The requested operation is not supported >on the server". Trying to figure out whether that's AI's limitation becoming >evident, or a mis-configured AI server. Rick On Wed, Jul 30, 2014 at 8:44 AM, Peter Romain <p.romain.arsl...@parsolutions.co.uk <mailto:p.romain.arsl...@parsolutions.co.uk> > wrote: ** Rick, I don’t fully understand what you are asking! AI on 7.6.04 only has connectors to the CMDB allowing it to read and write the CMDB forms and trigger workflow as it does. AI on 8 has additional connectors to allow it to interact directly with Remedy forms as well. AI in all versions can connect to the Remedy databases using the database connectors and then read and write data directly to the database tables. This obviously doesn’t trigger any workflow. Cheers Peter From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> ] On Behalf Of Rick Cook Sent: 30 July 2014 15:34 To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: Re: Installing Atrium Integrator on 7.6.04 system ** Peter, I want to be sure we understand one another clearly. What I hear you (and BMC) saying is that on a 7.6.04 server, an AI install cannot interact with Remedy tables on THAT server unless they are CMDB forms. With that, I agree. Are you also saying that it cannot interact with pre-8.x Remedy forms on remote servers as Database Connections, even if the data is not read from or written to any Remedy forms on the 7.6.04 AI server? Rick On Mon, Jul 28, 2014 at 9:12 AM, Peter Romain <p.romain.arsl...@parsolutions.co.uk <mailto:p.romain.arsl...@parsolutions.co.uk> > wrote: ** 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:arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> ] On Behalf Of Rick Cook Sent: 28 July 2014 16:49 To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> 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 <carlbwil...@gmail.com <mailto:carlbwil...@gmail.com> > 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:arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> ] On Behalf Of Rick Cook Sent: 26 July 2014 01:24 To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> 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" <rjust2...@aol.com <mailto:rjust2...@aol.com> > 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 <remedyr...@gmail.com <mailto:remedyr...@gmail.com> > To: arslist <arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> > 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_ _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"