OpenInsight and AREV linking (OpenInsight Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[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]]


==== OpenInsight and AREV linking (OpenInsight Specific) ====
=== At 12 NOV 1997 03:15:50PM A. Howarda wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I am in the process of trying to link data from AREV 3.x to MS SQL 6.5



We want to put OpenInsight in the middle. Thus OpenInsight will pull information from AREV and intern MS SQL will get its data from OpenInsight.



I have down loaded the demo version of OpenInsight and was wondering if there is a basic procedure I can follow to link to OpenInsight from AREV.



Thanks

Alan Howard
</QUOTE>
----

=== At 12 NOV 1997 05:02PM Dave Pociu wrote:  ===

<QUOTE>Alan,



If I understand you correctly, you are trying to look at the AREV files from OpenInsight and then put that data in SQL format.



To attach the files, go to Database Manager (under Tools in the main menu) .



In there got to File,  Add. Select the directory with your AREV data tables and add the tables you want. 



When done, choose DataBase, Save at the main menu in Database Manager. This ensures that the tables you added will allways be attached when you open your application.



From here you can probably use the Data Warehousing to put your information in MS SQL format.



Hope this helps.



Dave Pociu

</QUOTE>

----

=== At 12 NOV 1997 06:01PM John Duquette wrote:  ===

<QUOTE>Alan,



[i]I have down loaded the demo version of OpenInsight and was wondering if there is a basic procedure I can follow to link to OpenInsight from AREV.[/i]



You should just attach the location.  You should also change any dots to underscores in file/field names.



John Revelation

</QUOTE>


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