Hi,
Please refer to knowledge base article which is on similar topic -
KM-000000005591
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"