Re: joining table from oracle db to a table in ms sql db

You can consider using Oracle Business Intelligence Enterprise Edition (OBIEE) for this purpose.

OBIEE was designed for querying data from different data sources in a hetergenious environment. You first defined the ODBC connectivity and load the physical data definitions into the OBIEE repository file. You can define the join criteria amoung loaded "table" in the repository. Defining the logical to phytical mapping can be simply done using drag and drop interface. The BI will then allow you to access the logical model (presentation layer) via the standard ODBC interface. You can also query the data using the point and click web interface.

Dylan

--
My BI Blog: http://dylanwan.wordpress.com