[[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]]


==== Accessing 4.1.3 data (OpenInsight 32-bit Specific) ====
=== At 21 FEB 2010 09:53:17AM Brett Adams wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
I have an older application based on OI 4.1.3 and I would like to access the data for post processing and reporting.  An ODBC driver would be perfect but from what I can tell the current ODBC driver only works with OI ] 7.1.  What is the best way to access the data for a OI 4.1.3 based application?



Thanks,

Brett
</QUOTE>
----

=== At 23 FEB 2010 01:13PM Jared Bratu wrote:  ===

<QUOTE>Have you looked at the data warehousing features to export the data to SQL tables? It should allow you to reference the data from your regular data source.

</QUOTE>

----

=== At 03 MAR 2010 02:44PM Brett Adams wrote:  ===

<QUOTE>I don't know much about the data warehousing features but from the little I've read my application would need to be deployed with some sort of data warehousing feature enabled.  I only have an application which doesn't seem to provide any sort of full table dump so I was wondering if I could bypass the application and access the database tables directly.



If I could export the data to SQL tables then that would be just as good.

</QUOTE>


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