Home » Developer & Programmer » Reports & Discoverer » How to add fields from another database to EUL (Discoverer 10G)
How to add fields from another database to EUL [message #474857] Thu, 09 September 2010 06:09 Go to next message
Claes
Messages: 1
Registered: September 2010
Location: Norway
Junior Member
I am trying to add fields from an SQL server database to the EUL. We have a lot of Oracle tables and fields in the existinging EUL, and we have created a database link from the Oracle database to the SQL database. But how can I find til SQL database tables and fields in Discoverer admin?
Claes

Report message to a moderator

Re: How to add fields from another database to EUL [message #475138 is a reply to message #474857] Mon, 13 September 2010 04:56 Go to previous message
cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester
Senior Member
Try creating views in your local DB that query the tables in the remote DB, then use those in the EUL.
I very much doubt discoverer will be able to work with the remote tables directly, especially since they're not in an oracle DB.

Report message to a moderator

Previous Topic: Hyperlink Problem in Reports
Next Topic: Current Date Field
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 03:52:59 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.