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

How to make data accessible to external apps? (OpenInsight 32-bit Specific)

At 19 APR 2010 06:59:04PM true north wrote:

Is there a way to make OpenInsight data available to apps like Excel where we could do a few "queries"?

Thanks in advance.

At 19 APR 2010 07:38PM dsigafoos wrote:

The best way is through the warehouse manager. It allows you to create connections to SQL systems and port data to them. The you can use any tool you want to query.

It does take good knowledge of your data but is pretty simple to use.

At 20 APR 2010 07:44AM Bob Carten wrote:

Excel web queries are a useful way but Excel specific way to feed data from Openinsight to excel. There is a lot of information on the web, for example

http://articles.techrepublic.com.com/5100-10878_11-6115870.html?part=rss&tag=feed&subj=tr

Recent versions of Openinsoight have aa 'SELECT_INTO' command that will return the result of a query as html. Yuo would need to set up OECGI2 on an intranet and write your version of INET_SELECT_INTO.

At 10 MAY 2010 09:16PM true north wrote:

Many thanks!

View this thread on the forum...