With this option, there will be some minimal maintenance on the DB side of things: the set up of the linked server, and setting any permissions to the aradmin user on the target table.
These things are managed/maintained/migrated outside of Remedy, since they are at the database level, so that's something to consider when testing or setting up a new environment (QA, stating, etc) or making sure your environments "match". Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Brian Gillock Sent: Wed 06/25/08 12:28 PM To: arslist@ARSLIST.ORG Subject: Re: Push to External DB Thank you Luisa. Not to be difficult, but I have a link setup for a separate view form integration, and that server/link does not show in the drop down for direct sql. I had the DBA use the instructions from the ARS Integrating w/ plugins and third-party document. Is there something else needed. I'm not a DBA, nor do I have admin access outside of what is needed by Remedy. Which is one reason I wanted to avoid additional maintenance points for the DBAs. But, if it's necessary, then so be it. Thanks! From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Luisa Carena Sent: Wednesday, June 25, 2008 9:02 AM To: arslist@ARSLIST.ORG Subject: Rif: Re: Push to External DB You have to define on SQL server Enterprise Manager a linked server - see SQL manual. ciao Luisa Carena Gestione Postazioni Periferiche e Asset SGS BP Gruppo Banco Popolare di Verona e Novara via Negroni 12 - 28100 Novara Tel: 0321-663995 Email: [EMAIL PROTECTED] Brian Gillock <[EMAIL PROTECTED]> - 25/06/2008 17.31 Inviato da: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> Per favore, rispondere a arslist@ARSLIST.ORG Per: arslist@ARSLIST.ORG CC: Oggetto: Re: Push to External DB ** Thank you Guillaume, but I looked at that and am not finding how to specify the external server. The docs made it sound like you could do that too, and I've been looking. I'm guessing there is some kind of configuration required to be able to specify the external DB. Can you point me in the right direction please? Thanks! Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 25, 2008 8:23 AM To: arslist@ARSLIST.ORG Subject: Re: Push to External DB ** A direct SQL statement from a filter should work, provided the aradmin account in the Remedy database has access/permissions to the other database Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Brian Gillock Sent: Wed 06/25/08 11:05 AM To: arslist@ARSLIST.ORG Subject: Push to External DB Hey Listers, I'm hoping this is an easy question that only I don't know the answer to. Is there a way to push data into an external database (SQL Server 2005) without using a view form or web service? I don't want to use a view form because of the maintenance associated with it. Thanks! Brian _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ---------------------------------------------------------------------------------------------------------------------------- La presente comunicazione e' destinata esclusivamente al soggetto indicato piu' sopra quale destinatario o ad eventuali altri soggetti autorizzati a riceverla. Essa contiene informazioni strettamente confidenziali e riservate, la cui comunicazione o diffusione a terzi e' proibita, salvo che non sia stata espressamente autorizzata.Se avete ricevuto questa comunicazione per errore, Vi preghiamo di darne immediata comunicazione al mittente e di cancellarne ogni evidenza dai Vostri supporti. ---------------------------------------------------------------------------------------------------------------------------------------- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
