[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Oracle access  from  OpenInsight (AREV Specific) ====
=== At 18 JUL 2002 02:41:23AM Adil Yalcin wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>


Dear  all,



We  have  studied  on  Open-Insight  and  we  noticed  that,  it  has  some  stored  procedure  facilities   and  ODBC  connections  to  the  other  databases.  



Starting  from  this  point,  we  would  like  to  know,   whether  an  Open-Insight  program  could  be  triggered  and  update  the  Oracle  database   when  an  ARev LH  table is  updated  by  the  Arev  program. 



If  this  is  possible,  then  we  could  retain  the  data    behind  our  web  site  real-time and  updated.



Thanks,
</QUOTE>
----

=== At 18 JUL 2002 04:52AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>There are several OI to SQL connectivity solutions possible. We have performed such links to SQL from OI for several of our clients. It might be possible to tweak AREV to make use of routines.



There are also presentations regarding the techniques in use by other developers at the 2002 Revelation Conference



For details about the conference venue and dates see here:

http://www.revelation.com/WebSite/vipweb.nsf/e4a32622500660198525631900091149/c02631c78025fd0988256b730006e7fc?OpenDocument



The speaker schedule and topics are published here:

http://www.revelation.com/WebSite/vipweb.nsf/e4a32622500660198525631900091149/22572f761609d40088256ba10000e59d?OpenDocument



We recommend that developers attend if they are interested in improving their knowledge of Revelation Products and new and emerging development techniques.



[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 18 JUL 2002 06:02AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>Or you could web enable your AREV database and just make calls from the website to include realtime data - this is what several of our clients do - including one who we believe uses the same software as yourself.



[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 19 JUL 2002 01:20AM Keng Chen wrote:  ===

<QUOTE>I have done this sucessfully using MFS.



In AREV, an MFS is installed in the write process of the table so that an AREV update will generate a log (record key) in a shared OI/ AREV table. On the OI side, a Stored Procedure is running continuously to poll this log table for entries. When it picks up a log entry, the SP gets the row info and executes an ORACLE SQL update (or insert) using QryMethod to replicate the data to ORACLE then deletes the log entry and return to poll the log table for new entries. Note that the MFS must also be installed on the OI side but without the update to this log table.



Hope this helps.





</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=A4F02AC40716760485256BFA0024BFAC|View this thread on the  forum...]]