Re: View Forms SQL (ARS) to ORACLE (non-ARS)
It used to be a separate license that you had to purchase, and I assume
is still available that way. If you have ITSM 7 or anything else that
includes the CMDB, it is now "included" at no extra licensing fee so
that you actually have a tool with which to populate the CMDB. Or so it
was explained to me. You would need to have licensing upgrade your
licensing file to add the EIE and the SQL Server or Oracle Adapter
(Remedy Link for SQL Server or Oracle). Your sales rep has to be
involved, I believe, to authorize your account for the products.
Christopher Strauss, Ph.D.
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/helpdesk/
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carnevali, Carol x23849
Sent: Monday, June 04, 2007 7:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms SQL (ARS) to ORACLE (non-ARS)
**
Roney,
Yes, it helps somewhat. I have, in the past, created link
servers and a view form between two SQL Server databases. Was just
wondering if it's possible to do it from SQL ARS to an external Oracle
database. Not very familiar with EIE. Is that something that needs to
be purchased?
Thanks again,
Carol
_
From: Roney Samuel Varghese [mailto:[EMAIL PROTECTED]
Sent: Friday, June 01, 2007 11:40 PM
Subject: Re: View Forms SQL (ARS) to ORACLE (non-ARS)
** 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] <mailto:[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___
__20060125___This posting was submitted with
HTML in it___
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"
Re: View Forms SQL (ARS) to ORACLE (non-ARS)
Link to External Databases (ARDBC Plug-In) http://www.buoyantsolutions.net/External_DB.html From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carnevali, Carol x23849 Sent: Monday, June 04, 2007 3:43 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms SQL (ARS) to ORACLE (non-ARS) ** Roney, Yes, it helps somewhat. I have, in the past, created link servers and a view form between two SQL Server databases. Was just wondering if it's possible to do it from SQL ARS to an external Oracle database. Not very familiar with EIE. Is that something that needs to be purchased? Thanks again, Carol From: Roney Samuel Varghese [mailto:[EMAIL PROTECTED] Sent: Friday, June 01, 2007 11:40 PM Subject: Re: View Forms SQL (ARS) to ORACLE (non-ARS) ** 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] <mailto:[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___ __20060125___This posting was submitted with HTML in it___ 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" -- *DISCLAIMER* The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *END OF DISCLAIMER* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: View Forms SQL (ARS) to ORACLE (non-ARS)
Roney, Yes, it helps somewhat. I have, in the past, created link servers and a view form between two SQL Server databases. Was just wondering if it's possible to do it from SQL ARS to an external Oracle database. Not very familiar with EIE. Is that something that needs to be purchased? Thanks again, Carol _ From: Roney Samuel Varghese [mailto:[EMAIL PROTECTED] Sent: Friday, June 01, 2007 11:40 PM Subject: Re: View Forms SQL (ARS) to ORACLE (non-ARS) ** 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 < <mailto:[EMAIL PROTECTED]> [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___ __20060125___This posting was submitted with HTML in it___ 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: View Forms SQL (ARS) to ORACLE (non-ARS)
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"
View Forms SQL (ARS) to ORACLE (non-ARS)
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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
