Dear Carol,
There are multiple ways to do this. You can either use EIE
(RLO) which can help you to pull data from the external Oracle table to the
Remedy Database, or you can create a database link between ARSystem Database
and the external table in Oracle using ODBC drivers. Once the DB link is
created with appropriate permissions (Read, Write, Execute) you can create a
view form from within Remedy, however the Oracle table would require a
unique key which you should be designated as the request id and AR System
uses five different Oracle data types for columns: number (15, 0),
float, varchar, blob, and clob.
Hope this helps
Regards,
Roney Samuel Varghese
On 6/1/07, Carnevali, Carol x23849 <[EMAIL PROTECTED]> wrote:
**
Is it possible to create a View Form from a SQL (ARS) database to an
Oracle (non-ARS) database? If so, are there any tips or tricks that I
need to know?
Thanks!
This message and any attachments are intended only for the use of the addressee
and
may contain information that is privileged and confidential. If the reader of
the
message is not the intended recipient or an authorized representative of the
intended recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail and delete the message and any
attachments from your system.
__20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
