Thanks, Peter. I just tested creating a new transformation on the 7.6 box, and was able to connect to, and preview rows from, a non-CMDB form on that server. So I am not sure what or where the limitation is there. The error only happens when I try to save the transformation. I suspect that error is something in the configuration of the plug-in or AI itself that got missed on installation. Will let you all know how it comes out.
Rick On Wed, Jul 30, 2014 at 10:51 AM, Peter Romain < [email protected]> wrote: > ** > > 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: > [email protected]] *On Behalf Of *Rick Cook > *Sent:* 30 July 2014 17:02 > > *To:* [email protected] > *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 < > [email protected]> 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: > [email protected]] *On Behalf Of *Rick Cook > *Sent:* 30 July 2014 15:34 > > > *To:* [email protected] > *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 < > [email protected]> 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: > [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]> > 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]] *On Behalf Of *Rick Cook > *Sent:* 26 July 2014 01:24 > *To:* [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]> 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]> > To: arslist <[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_ > > _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"
