Re: Installing Atrium Integrator on 7.6.04 system
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 < p.romain.arsl...@parsolutions.co.uk> 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: > 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> 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] *On Behalf Of *Rick Cook > *Sent:* 30 July 2014 15:34 > > > *To:* 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> 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:
Re: Installing Atrium Integrator on 7.6.04 system
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 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 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
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> 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] *On Behalf Of *Rick Cook > *Sent:* 30 July 2014 15:34 > > *To:* 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> 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] *On Behalf Of *Rick Cook > *Sent:* 28 July 2014 16:49 > > > *To:* 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 > 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 an
Re: Installing Atrium Integrator on 7.6.04 system
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] On Behalf Of Rick Cook Sent: 30 July 2014 15:34 To: 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 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 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" 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 mailto:remedyr...@gmail.com> > To: arslist 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 leve
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> 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] *On Behalf Of *Rick Cook > *Sent:* 28 July 2014 16:49 > > *To:* 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 > 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] *On Behalf Of *Rick Cook > *Sent:* 26 July 2014 01:24 > *To:* 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" 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 > To: arslist > 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_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Installing Atrium Integrator on 7.6.04 system
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] On Behalf Of Rick Cook Sent: 28 July 2014 16:49 To: 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 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" 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 mailto:remedyr...@gmail.com> > To: arslist 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
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 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] *On Behalf Of *Rick Cook > *Sent:* 26 July 2014 01:24 > *To:* 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" 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 > To: arslist > 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_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Installing Atrium Integrator on 7.6.04 system
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] On Behalf Of Rick Cook Sent: 26 July 2014 01:24 To: 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" 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 To: arslist 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
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" 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 > To: arslist > 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Installing Atrium Integrator on 7.6.04 system
Hi Rick, AI was introduced in 7.6.04 (base) but only does CMDB forms in this version so it was still in it's infancy in this version. Both AIE and AI are provided up to the current versions (8.1.xx), but AIE is pretty much depreciated in the 8.x versions as AI now has more capability that AIE as an ETL engine (lots more connectors, more flexible, etc). I would very much question that SP2 is required for installation as it has been available since the release of 7.6.04 and was part of the base CMDB install. The AI guru's (very active and knowledgeable) hang out on the BMC Communities, so you can ask this over there to get a precise answer to your question on compatibility. _ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: 25 July 2014 17:39 To: arslist@ARSLIST.ORG 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Installing Atrium Integrator on 7.6.04 system
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 To: arslist 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"