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
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: 10571
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.
Previous Topic: Hyperlink Problem in Reports
Next Topic: Current Date Field
Goto Forum:
  


Current Time: Wed Apr 16 14:59:30 CDT 2014

Total time taken to generate the page: 0.14549 seconds