Shawn, That's probably the route we will take. I hope there are no performance impacts if multiple apps hit the same tables for data. The iDashboards looks rather intense and I don't know if it caches or constantly updates with select statement queries.
Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Pierson, Shawn Sent: Friday, August 07, 2009 9:50 AM To: [email protected] Subject: Re: ardbc connectivity with iDashboards If your concern is just that the ODBC connection needs to be read only, why not just create a new SQL Server account and give them select only access? Otherwise, there is always the Remedy ODBC driver, but I've never really had that much luck with it. Shawn Pierson -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Reiser, John J Sent: Friday, August 07, 2009 8:29 AM To: [email protected] Subject: ardbc connectivity with iDashboards Hello Listers, ARS 7.1 Patch4 MS SQL 2005 (Remote) MS Server 2003 Ent (VM) First, thanks for the WSDL help. We are able to retrieve data from a form. One part of the project is utilizing a product called iDashboards. The developer needs to make an ODBC connection to the DB. I do not care for the idea of a remote application connecting directly to the SQL Server table. I would rather the connection be through the API and ARDBC so that the link will be read only. Is this a good idea or should I just let the application query the backend DB directly? Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
