Connecting Oracle to SQL Server

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 ach-systems@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.

Comments are closed.