• Through an ODBC Connection.

    Sql Server -2008

    Using SQL SERVER Native client 10.0 driver version 2009.100.1600.01

    Then created a dblink in oracle to use the ODBC connection to get the data.

    We have Oracle 10g.