Gordon,
You wouldn't want to use the "T" tables-you would use the associated views that are automatically created based on those tables. We're using SQL Server Reporting Services and we access the data directly most of the time using the SQL ODBC driver. Advantages are you have total control over what is accessed and you are not using the Remedy threads. Disadvantages are you will not inherit the Remedy permissions for those fields and forms (that you will get using the ARODBC driver) and you have to perform your own conversions for datetime fields, menu fields, etc. We've built stored procedures for all of the common conversions and we manage access to the reports within the reporting solution so the disadvantages I've stated are not a real problem. We are still using the ARODBC driver for some of our reports as well. Since I'm not a lawyer, I'll let some of the others respond. In my opinion, it's your database and your data-accessing it directly is your choice. CRAIG CARTER _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank, Gordon M Mr NISO/Lockheed Martin Sent: Thursday, April 19, 2007 6:31 AM To: arslist@ARSLIST.ORG Subject: Accessing a Remedy Database through SQL without Remedy ARS (UNCLA SSIFIED) Classification: UNCLASSIFIED Caveats: NONE The question is: Does it make sense to access Remedy database directly through SQL calls. This would be utilizing the "T" tables, etc. structure. Does anyone out there have white papers which say this is a good thing or a bad thing? Does it make sense to access a Remedy Database such as Oracle directly using a tool other than ODBC or one of the common Remedy Integration methods? Does BMC/Remedy legally allow this type of access? Thanks up front, Gordon Frank Lockheed Martin Classification: UNCLASSIFIED Caveats: NONE __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
