{"id":703,"date":"2019-10-02T15:11:05","date_gmt":"2019-10-02T14:11:05","guid":{"rendered":"https:\/\/blogs.gre.ac.uk\/cmssupport\/?page_id=703"},"modified":"2019-10-02T15:11:05","modified_gmt":"2019-10-02T14:11:05","slug":"connecting-oracle-to-sql-server","status":"publish","type":"page","link":"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/oracle\/connecting-oracle-to-sql-server\/","title":{"rendered":"Connecting Oracle to SQL Server"},"content":{"rendered":"\n<p>This tutorial shows how to access the tables you have on your SQL-Server instance from Oracle.<br><br>Make sure you can login to\u00a0<a href=\"http:\/\/cms-support.gre.ac.uk\/old\/db\/managementstudio.html\">SQL Server Management Studio<\/a>, if you cannot login, please email\u00a0<a href=\"mailto:cms-support@gre.ac.uk\">cms-support@gre.ac.uk<\/a> to request a SQL Server Authentication login before you proceed. You will have also needed to have completed\u00a0<a href=\"http:\/\/cms-support.gre.ac.uk\/old\/db\/userdsn.html\">creating your own user DSN<\/a><\/p>\n\n\n\n<p><strong>Part 1 \u2013 Creating the database link<\/strong><\/p>\n\n\n\n<p>Within SQL Plus, type the following:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">create database link sqlserver connect to USERID identified by \"YOURPASSWORD\" using 'SQL-SERVER';<\/pre>\n\n\n\n<p>Where USERID is your computer log in e.g. ab123<\/p>\n\n\n\n<p><strong>Part 2 \u2013 Selecting your data<\/strong><\/p>\n\n\n\n<p>Within SQL Plus, type the following:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE DATABASE LINK QUILINK CONNECT TO userid IDENTIFIED BY password USING 'quigon';<\/pre>\n\n\n\n<p>Where test is a table on your SQL-Server instance, and dbo is the schema.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial shows how to access the tables you have on your SQL-Server instance from Oracle. Make sure you can login to\u00a0SQL Server Management Studio, if you cannot login, please email\u00a0cms-support@gre.ac.uk to request a SQL &hellip;<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":128,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-703","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/comments?post=703"}],"version-history":[{"count":0,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/703\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/128"}],"wp:attachment":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/media?parent=703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}