Re: Accessing a Remedy Database through SQL without Remedy ARS (UNCLA SSIFIED)
Hello, Our XML Gateway product will perform all the T table/C column translations for you and allow you to access data many times faster than you'll ever acheive through Remedy. In fact, I hear the guys at eBay are doing precisely so. While I think the writing of data is a little more tricky (only because it requires more thought), it's still entirely possible. Of course, any ODBC/JDBC driver can access Remedy data but the T table/C column prefixes make life far more complex. Writing: SELECT a.C1, b.C2, c.C341 FROM T141 a, T581 b, T185 c WHERE b.C2=c.C341 is far more effort than: SELECT Change ID+, Type, Item, FROM CHG:Change etc. For selecting data rapidly when you've got a lot of data, using Remedy isn't entirely sensible. Something like an AJAX 'search as I type' feature on a website just isn't going to happen if you can't query the database directly. Which is why one of our customers is busy performing AJAX based searches against an XML Gateway that's querying a Remedy database directly (albeit a copy). John Baker Java System Solutions : http://www.javasystemsolutions.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Accessing a Remedy Database through SQL without Remedy ARS (UNCLA SSIFIED)
Hi, Please refer to knowledge base article which is on similar topic - KM-5591 Some of the relevant section from this article I am copying below: The short answer is that, though it is true that Remedy applications store data in the ARSystem database, the database is intended to be updated only by the Remedy application server and going around it is a more complex task than it might seem, goes around application features that enforce data integrity and data restrictions, is not visible to Remedy diagnostics to troubleshoot problems, and can be broken by modification is Remedy tools, upgraded or migrating to another server. For all these reasons, pushing data directly to the ARSystem database is not a supported or recommended action. Thanks, Neha -- [EMAIL PROTECTED] www.vyomlabs.com Consulting | Oursourcing | Training || BMC Remedy BSM | ITIL | IT Governance Nall, Roger wrote: ** 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___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Accessing a Remedy Database through SQL without Remedy ARS (UNCLA SSIFIED)
It makes perfect sense. There are a lot of limitations when using the Remedy ODBC driver; and the only way to work around it is to use another means of access. Remedy will allow it, but you have to be careful in what you do, as there can be consequences to your actions: - if you run a report that takes 4 hours to complete against the db; chances are your app server is going to come to a halt or close to it - if you run a report that creates locks on a bunch of rows, you could hang your app ... Axton Grams On 4/19/07, Frank, Gordon M Mr NISO/Lockheed Martin [EMAIL PROTECTED] wrote: ** 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
Re: Accessing a Remedy Database through SQL without Remedy ARS (UNCLA SSIFIED)
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