Oracle Database Discussions

Well if you mean, can Discoverer look at tables / views on a SQL server then yes, I believe you can make a connection such as odbc or jdbc. However, not all SQL functions will be supported as Oracle has some of it's own whereas the protocol standards would only be supported.

If you mean can Discoverer run on the SQL server (ie: EUL tables, etc.), then no.

Russ

To add to what Russ stated.

You have to install the EUL on Oracle DB, then use Heterogenous Services (ODBC connectors) connectivity from Oracle DB to non-Oracle DB.

It is covered in the Adminstrator Guide in pretty good detail
http://download-west.oracle.com/docs/html/B13916_04/rdb_support.htm#CIHJEJBB
23 Discoverer support for non-Oracle databases and Oracle Rdb

Regards,

Steve.

And one thing I'm just passing by all, is the quote about non-Oracle database using / not using ODBC drivers.

This question came up a while ago and I quoted the manual saying that if you use ODBC drivers, then the EUL could be in the non-Oracle database.

After lotsa' posts, etc. it was decided that the documentation was wrong. Whether or not you use ODBC, you cannot have the EUL in a non-Oracle database.

Just passing this on as the manual differs.

Russ

=========================================================
quote from manual:

What is the difference between using generic connectivity and ODBC drivers to connect to non-Oracle databases?

In previous versions of Discoverer, users could connect to non-Oracle databases using ODBC drivers. The major difference between using ODBC drivers to connect to a non-Oracle database and using the Oracle database generic connectivity feature is the location of the EUL, as follows:

with ODBC drivers, the EUL is stored in the non-Oracle database

with generic connectivity, the EUL is stored in the Oracle database

===========================================================