All, Thanks Craig and Carl for your input. I do have two more questions that have came up.
1. Has anyone seen any issues of query conflict between SQL Reporting Services and the AR Server? 2. Also, has anyone ran into issues with views and tables being regenerated on changes made to Remedy that causes SRS to have any issues? Thanks, Frank Wall Administrator -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carter, Craig J Civ ARPC/DPD Sent: Thursday, May 04, 2006 8:16 AM To: [email protected] Subject: Re: Questrion on Microsoft SQL Reporting Services and Remedy I agree wholeheartedly with Carl's comments below. We have been using SQL SRS for months now accessing the database directly using the SQL driver versus ARODBC. We did develop SQL functions to convert the integer date values stored in Remedy to regular datetime values. It works great and is fast. When accessing the data directly, Remedy will not check permissions for you so you need to ensure only authorized people have access to the reports. This is easy if you call them from Remedy since you can control access to the forms and workflow. Additionally, you can set up permissions within SQL SRS Manager. It's a great alternative to Crystal Reports and we have it loaded on our midtier server for web reporting. The user clicks a button and their report is delivered in PDF format ready to print or save. CRAIG CARTER -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Carl Sent: Thursday, May 04, 2006 6:59 AM To: [email protected] Subject: Re: Questrion on Microsoft SQL Reporting Services and Remedy Frank: The ARODBC driver tends to be sort of flaky under the best of circumstances. I gave up trying to use it with Reporting Services. I have been using Reporting Services against my ARSystem database quite successfully. Use the MS-SQL driver and query against the views rather than directly against the tables. This gets you nice names to deal with. The only problem is with timestamps in ARSystem which are stored as integers rather than SQL date/time values, but a couple of short functions takes care of that. Risk-wise there is none since you are doing only select queries to pull out data, and you're not doing anything that the database system is not designed to do. Carl A. Jones ThyssenKrupp Elevator Desk - (901) 365-5656 x5250 Mobile - (901) 210-1369 ------------------------------ > Date: Wed, 3 May 2006 11:32:01 -0400 > From: Frank Wall <[EMAIL PROTECTED]> > Subject: Questrion on Microsoft SQL Reporting Services and Remedy. > > All, > > I have a couple of questions for any one that has used MS SRS with Remedy. > > 1. Is there a way to have SRS to use a ARODBC connection? > > 2. If a ARODBC connection can not be used, what would be the risk if > any > in using a SQL connection directly? > > Thanks in advance for any input on questions I have. > > Thanks, > Frank Wall > Administrator ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
