Using Generic Connectivity To Access Microsoft SQL Server

"I am trying to link 2 databases through Business Objects to enable Bus Obs users to run their own reports (querying data from both databases 'simultaneously') and have reached a stumbling block because (as I'm sure you're aware) database links between Oracle and another database (SQL Server in this instance) is an 'elaborate' process which, I have not yet managed to figure out. I suppose that my question is; have you done something like this before (linking different databases)? Or do you know how this could be done."

The simple way to connect an Oracle database to an ODBC-compliant data source (for example, Microsoft SQL Server) is to use the database Generic Connectivity feature. For details of how to use Generic Connectivity for Oracle 9i, check out the Generic Connectivity section in the Heterogeneous Connectivity Administrator's Guide.