OraFAQ Forum: Reports & Discoverer » Report that shows data from two different database

Home » Developer & Programmer » Reports & Discoverer » Report that shows data from two different database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report that shows data from two different database [message #234111]

Mon, 30 April 2007 01:18

SpeakurMind
Messages: 14
Registered: June 2006

Junior Member

Hi,

Please let me know of a solution in Oracle reports 10g wherein I can access tables that are across heterogenous databases like Oracle 9i and SQL Server without using dblink or materialized view.

Report message to a moderator

Re: Report that shows data from two different database [message #234115 is a reply to message #234111]

Mon, 30 April 2007 01:33

Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There is a way, but you'd need David Copperfield's assistance. Harry Houdini could also help, but he's dead.

What I mean to say: if I understood what you are saying, you'd like to fetch data from another database which is not, in any way, connected to the database Reports Builder works on. It is just as if you'd want to watch a TV, but it is switched off.

Well, perhaps there is a way to do that (or I completely misunderstood you), but I don't know how to do that.

Report message to a moderator

Re: Report that shows data from two different database [message #234118 is a reply to message #234115]

Mon, 30 April 2007 01:40

SpeakurMind
Messages: 14
Registered: June 2006

Junior Member

Well Thanks neways Cool

...

Let me know if come across something similar this like... Wink

)))

Report message to a moderator

Re: Report that shows data from two different database [message #234155 is a reply to message #234118]

Mon, 30 April 2007 04:10

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Actually, I think this question is a bit like "I want to watch television but I refuse to use the on/off switch, please let me know about any other features I can use".

So, why don't you want to use a database link?

Report message to a moderator

Re: Report that shows data from two different database [message #234179 is a reply to message #234155]

Mon, 30 April 2007 05:37

SpeakurMind
Messages: 14
Registered: June 2006

Junior Member

We are just looking out for possibilities without db link or materialized view.

As mentioned, "I want to watch television but I refuse to use the on/off switch, please let me know about any other features I can use".

Report message to a moderator

Re: Report that shows data from two different database [message #234237 is a reply to message #234179]

Mon, 30 April 2007 09:57

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Oh well, if you insist, you could take a look at
- ODBC connections
- create flat files and load these into Oracle using SQL*Loader
- gateways

Only second one applies to getting data from another database, all apply for other databases.

Report message to a moderator

Previous Topic:	Report inside a frame or tooltip in 10g report
Next Topic:	Discoverer Plus: Unable to view list of values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 08 05:47:35 CST 2024