Re: how to use external data with discoverer

From: Mark Rittman <mrittman_at_plusconsultancy.co.uk>
Date: 7 Jan 2004 15:23:34 -0800
Message-ID: <a51ec6d5.0401071523.20fd352a@posting.google.com>

Hi there,

As mentioned in my reply to your post on comp.databases.olap, you can use the Heterogenious Services / Generic Connectivity feature to create database links to ODBC data sources. This document ( http://otn.oracle.com/products/discoverer/htdocs/hints/htm/gen_heterogenous_ds.htm ) explains it in more detail.

Alternatively, you can register the spreadsheet (in CSV format) as an External table, and join that to your regular Oracle tables. Don Burleson's article (
http://www.dba-oracle.com/art_ext_tabs_spreadsheet.htm ) explains this further.

hope this helps

Mark Rittman

hopehope_123_at_yahoo.com (utkanbir) wrote in message news:<f6c90ebe.0401070511.16d00a0e_at_posting.google.com>...
> Hi gurus ,
>
> Is it possible to use an external data source (such as an excel file)
> with oracle discoverer and combine that data source with an oracle
> table without putting the external data inside the db server? Mu
> customer wants to use its pre-prepared excel or txt files as inputs to
> the discoverer queries. The customer says she can do this thing by
> using business objects, it allows to query an excel file and database
> table together.
>
> Kind Regards,
> hope
Received on Wed Jan 07 2004 - 17:23:34 CST