Gordon,
See below. Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ________________________________ 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 8: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.[Nall, Roger] What type of access? If you are talking about Read access there is really not much danger. If you are talking about Updating that is a different story. There are many things to consider such as "H tables" Does anyone out there have white papers which say this is a good thing or a bad thing? [Nall, Roger] We do not allow ready access to the ARSystem database. We replicate data to reporting servers. This way those users who don't really know what they are doing will not affect the production environment with bad queries. 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"
