This tutorial shows how to access the tables you have on your SQL-Server instance from Oracle.
Make sure you can login to SQL Server Management Studio, if you cannot login, please email cms-support@gre.ac.uk to request a SQL Server Authentication login before you proceed. You will have also needed to have completed creating your own user DSN
Part 1 – Creating the database link
Within SQL Plus, type the following:
create database link sqlserver connect to USERID identified by "YOURPASSWORD" using 'SQL-SERVER';
Where USERID is your computer log in e.g. ab123
Part 2 – Selecting your data
Within SQL Plus, type the following:
CREATE DATABASE LINK QUILINK CONNECT TO userid IDENTIFIED BY password USING 'quigon';
Where test is a table on your SQL-Server instance, and dbo is the schema.