Re: ARS Remedy to MySQL
We also have a few instances where we cache the remote data and sync it a few times a day. A specific example that comes to mind is HR department/cost center data. We have a form where people can choose from a menu of cost centers or HR departments. The menus use to pull data across the db link via View Form. It was too slow to use in a customer facing UI though. We found we could truncate and recache a few complete remote tables in the same time it took for the user to open the menu once. If they selected an option and then changed their mind they would wait again (although it would be a bit faster). The othere benefit is our Remedy process still works if the HR db is down. Jason On Nov 4, 2014 7:44 AM, "Grooms, Frederick W" wrote: > ** > > Question … do you need the data with real-time updates? > > > > We have a couple of tables used for querying against that are refreshed > once a day (using a Perl Script to pull the remote database and insert into > a table in our Oracle). We then have a View Form in ARS to use the data > in our system. > > > > Fred > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Wesley Reyes > *Sent:* Monday, November 03, 2014 8:24 PM > *To:* arslist@ARSLIST.ORG > *Subject:* ARS Remedy to MySQL > > > > ** > > Hi would anyone have an idea how can I connect my Remedy ARS to mysql db? > As of current we need a record from the mysql db but our ARS Remedy DB is > in Oracle. > > > > Thanks :) > > > > > _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: ARS Remedy to MySQL
If you are on AR System 8.x, you can use Atrium Integrator to build jobs to move data to/from MySQL. Rick Cook On Tue, Nov 4, 2014 at 7:44 AM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > ** > > Question … do you need the data with real-time updates? > > > > We have a couple of tables used for querying against that are refreshed > once a day (using a Perl Script to pull the remote database and insert into > a table in our Oracle). We then have a View Form in ARS to use the data > in our system. > > > > Fred > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Wesley Reyes > *Sent:* Monday, November 03, 2014 8:24 PM > *To:* arslist@ARSLIST.ORG > *Subject:* ARS Remedy to MySQL > > > > ** > > Hi would anyone have an idea how can I connect my Remedy ARS to mysql db? > As of current we need a record from the mysql db but our ARS Remedy DB is > in Oracle. > > > > Thanks :) > > > > > _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: ARS Remedy to MySQL
Question … do you need the data with real-time updates? We have a couple of tables used for querying against that are refreshed once a day (using a Perl Script to pull the remote database and insert into a table in our Oracle). We then have a View Form in ARS to use the data in our system. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes Sent: Monday, November 03, 2014 8:24 PM To: arslist@ARSLIST.ORG Subject: ARS Remedy to MySQL ** Hi would anyone have an idea how can I connect my Remedy ARS to mysql db? As of current we need a record from the mysql db but our ARS Remedy DB is in Oracle. Thanks :) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ARS Remedy to MySQL
Create a dblink from oracle to mysql, you can Google this, it is possible using oracle heterogeneous services. Then once you have that link created, you can create as many view forms as needed in Dev studio using the linked table names, see your vmc remedy docs for info on view forms. On Nov 3, 2014 6:24 PM, "Wesley Reyes" wrote: > ** > Hi would anyone have an idea how can I connect my Remedy ARS to mysql db? > As of current we need a record from the mysql db but our ARS Remedy DB is > in Oracle. > > Thanks :) > _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: ARS Remedy to MySQL
There is one that comes with the server in the api folder, it's not complete by any means, but is a good starting point. On Nov 3, 2014 7:43 PM, "Wesley Reyes" wrote: > ** > Hi LJ, > > Do you have any sample ARDBC plugin? > > Thanks > > > On Tuesday, 4 November 2014, 15:26, LJ LongWing > wrote: > > > ** > You could try writing an ardbc plugin to get the data > On Nov 3, 2014 7:24 PM, "Wesley Reyes" wrote: > > ** > Hi would anyone have an idea how can I connect my Remedy ARS to mysql db? > As of current we need a record from the mysql db but our ARS Remedy DB is > in Oracle. > > Thanks :) > _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: ARS Remedy to MySQL
Hi Omega, Yup..but I read that in order to set-up a view form you need to have ARDBC plugin setup on Remedy's end. On Tuesday, 4 November 2014, 15:49, Omega LiPO wrote: ** How about a view form or something, like a view of the mySQL , I forgot the term. It is good as the read-only info. Cheers, Omega From: LJ LongWing Sent: 4/11/14 10:27 AM To: arslist@ARSLIST.ORG Subject: Re: ARS Remedy to MySQL ** You could try writing an ardbc plugin to get the data On Nov 3, 2014 7:24 PM, "Wesley Reyes" wrote: ** >Hi would anyone have an idea how can I connect my Remedy ARS to mysql db? As >of current we need a record from the mysql db but our ARS Remedy DB is in >Oracle. > > >Thanks :) _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: ARS Remedy to MySQL
How about a view form or something, like a view of the mySQL , I forgot the term. It is good as the read-only info. Cheers, Omega -Original Message- From: "LJ LongWing" Sent: 4/11/14 10:27 AM To: "arslist@ARSLIST.ORG" Subject: Re: ARS Remedy to MySQL ** You could try writing an ardbc plugin to get the data On Nov 3, 2014 7:24 PM, "Wesley Reyes" wrote: ** Hi would anyone have an idea how can I connect my Remedy ARS to mysql db? As of current we need a record from the mysql db but our ARS Remedy DB is in Oracle. Thanks :) _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: ARS Remedy to MySQL
Hi LJ, Do you have any sample ARDBC plugin? Thanks On Tuesday, 4 November 2014, 15:26, LJ LongWing wrote: ** You could try writing an ardbc plugin to get the data On Nov 3, 2014 7:24 PM, "Wesley Reyes" wrote: ** >Hi would anyone have an idea how can I connect my Remedy ARS to mysql db? As >of current we need a record from the mysql db but our ARS Remedy DB is in >Oracle. > > >Thanks :) _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: ARS Remedy to MySQL
You could try writing an ardbc plugin to get the data On Nov 3, 2014 7:24 PM, "Wesley Reyes" wrote: > ** > Hi would anyone have an idea how can I connect my Remedy ARS to mysql db? > As of current we need a record from the mysql db but our ARS Remedy DB is > in Oracle. > > Thanks :) > _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"
ARS Remedy to MySQL
Hi would anyone have an idea how can I connect my Remedy ARS to mysql db? As of current we need a record from the mysql db but our ARS Remedy DB is in Oracle. Thanks :) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"