Originally Posted by zakriyamhd
Follow the steps:
1. create an entry in tnsnames and listener to connect to the remote SQL server host, and the Kind of Heterogeneous services you choose - Transparent gateways or Generic connectivity initfile for TG4MSQL. Refer metalink docs 231458.1 & 252364.1
2. create an ODBC connection pointing to the remote SQL server with the user credentials in Oracle server.
3. create a DBlink with the user name and password to connect to the remote SQL server database from the schema you want to connect.
now you can connect to the remote server and view xyz.
I dont think you need separate license for this.
"What is past is PROLOGUE"