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" <[email protected]> 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: > [email protected]] *On Behalf Of *Wesley Reyes > *Sent:* Monday, November 03, 2014 8:24 PM > *To:* [email protected] > *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"
