[root@db msodbcsql-11.0.2270.0]# odbcinst -q -d -n \"ODBC Driver 11 for SQL Server\"\n[ODBC Driver 11 for SQL Server]\nDescription=Microsoft ODBC Driver 11 for SQL Server\nDriver=\/opt\/microsoft\/msodbcsql\/lib64\/libmsodbcsql-11.0.so.2270.0\nThreading=1\nUsageCount=1<\/pre>\nAfter these checks, we can now use the relevant packages to connect from Oracle to MSSQL.<\/p>\n
Configure Heterogeneous Connection From Oracle to SQL Server<\/h1>\n We need to write the information of the MSSQL database to be connected to \/etc\/odbc.ini.<\/p>\n
The point to note here is to specify the type of database we have added under [ODBC Data Sources]. If more than one is used, it must be written to the new line.<\/p>\n
The information you see under [MSSQL_DB_NAME] is the information used to access the MSSQL database.<\/p>\n
[root@mhrstestdb2 ~]# cat \/etc\/odbc.ini \n[ODBC Data Sources]\nMSSQL_DB_NAME=MS SQL Server\n\n[MSSQL_DB_NAME]\nDriver=\/opt\/microsoft\/msodbcsql\/lib64\/libmsodbcsql-11.0.so.2270.0\nDescription=Microsoft ODBC Driver 11 for SQL Server\nServer=tcp:<IP_ADRESI>,<PORT>\nDatabase=<DB_NAME>\nUser=username\nPassword=password\nQuotedId=YES\nAnsiNPW=YES\nThreading=1\nUsageCount=1\nAutoTranslate=No<\/pre>\nYou see an example odbc.ini file above.<\/p>\n
We will do the following to make [MSSQL_DB_NAME] meaningful by ORACLE.<\/p>\n
[root@db ~]# su - oracle\n[oracle@db ~]$ cd \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/hs\/admin\/\n[oracle@db admin]$ ls -ltr\ntotal 12\n-rw-r--r-- 1 oracle oinstall 489 Aug 24 2013 initdg4odbc.ora\n-rw-r--r-- 1 oracle oinstall 1109 Aug 24 2013 extproc.ora<\/pre>\nIn order for MSSQL_DB_NAME to be recognized by ORACLE, the critical point here is that the name of the .ora file must match the definition you make in the .ini file and begin with init\u2026.<\/p>\n
[oracle@mhrstestdb2 admin]$ vi init<MSSQL_DB_NAME>.ora \nHS_FDS_CONNECT_INFO = MSSQL_DB_NAME\nHS_FDS_SHAREABLE_NAME = \/usr\/lib64\/libodbc.so\nHS_FDS_TRACE_LEVEL = 0\nHS_LANGUAGE = AMERICAN_AMERICA.WE8MSWIN1252\nHS_KEEP_REMOTE_COLUMN_SIZE = LOCAL\nHS_NLS_LENGTH_SEMANTICS = CHAR\nHS_NLS_NCHAR = UCS2<\/pre>\nTo access this odbc.ini file by the Environment<\/p>\n
set ODBCINI=\/etc\/odbc.ini<\/pre>\nConnect to MSSQL from Oracle<\/h2>\n If all steps are correct, we will be able to connect to the MSSQL database with the isql tool.<\/p>\n
NOTE:<\/strong> Password must be written in single quotes (\u2018). If there is a single quotation mark inside the password, it is a problem.<\/p>\n[oracle@db ~]$ isql -v <MSSQL_DB_NAME> <USERNAME> <PASSWORD>\n+---------------------------------------+\n| Connected! |\n| |\n| sql-statement |\n| help [tablename] |\n| quit |\n| |\n+---------------------------------------+<\/pre>\nIf there is no problem up to this point, let Oracle Access this service via DBLINK.<\/p>\n
[oracle@db admin]$ cd \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/network\/admin\n\n<MSSQL_DB_NAME> =\n (DESCRIPTION =\n (ADDRESS =\n (PROTOCOL = tcp)\n (HOST = <oracle veri taban\u0131n\u0131n host bilgisi> )\n (PORT = 1521))\n (CONNECT_DATA =\n (SID = <MSSQL_DB_NAME> ))\n (HS = OK)\n )<\/pre>\nWe make the configuration for MSSQL look like it’s a service offered by ORACLE.<\/p>\n
[oracle@db admin]$ cd \/u01\/app\/11.2.0.4\/grid\/network\/admin\n\nMSSQL_DB_NAME =\n (DESCRIPTION =\n (ADDRESS =\n (PROTOCOL = tcp)\n (HOST = <oracle veri taban\u0131n\u0131n host bilgisi>)\n (PORT = 1521))\n (CONNECT_DATA =\n (SID = <MSSQL_DB_NAME>))\n (HS = OK)\n )<\/pre>\nNOTE:<\/strong> If you are using an Oracle database in the RAC architecture, the corresponding operation must be performed on each NODE.<\/p>\nThen, the LISTENER must be defined.<\/p>\n
SID_LIST_LISTENER =\n (SID_LIST =\n (SID_DESC =\n (SID_NAME = <MSSQL_DB_NAME>)\n (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0.4\/db_1)\n (PROGRAM = \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/bin\/dg4odbc)\n (ENVS=LD_LIBRARY_PATH=\/opt\/microsoft\/msodbcsql\/lib64\/libmsodbcsql-11.0.so.2270.0:\/usr\/lib64:\/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/lib)\n )\n )<\/pre>\nWe previously learned LD_LIBRARY_PATH during package installation.<\/p>\n
Create DBLINK on Oracle database<\/h2>\nCREATE PUBLIC DATABASE LINK <MSSQL_DB_NAME>\n CONNECT TO <USERNAME>\n IDENTIFIED BY <PASSWORD>\n USING '<MSSQL_DB_NAME';<\/pre>\nIn the USING section we will use the service name we defined in odbc.ini.<\/p>\n
SELECT SYSDATE FROM DUAL@<MSSQL_DB_NAME;<\/pre>\nThus, a heteregeneous connection was established from Oracle to SQL Server.<\/p>\n
Note:<\/strong> Please note that service names and access names are the most important part.<\/p>\n\n<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"excerpt":{"rendered":"
You can read this document to access the tables in the MSSQL database using the DBLINK architecture from the Oracle database. Please test in the TEST database first. If you want to connect to other databases or connect to Oracle from other databases, you should read the below articles. Connect To Oracle From SQL Server …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"author":486,"featured_media":14014,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[6302,8064,6301,6320,6319,6321,6308,6307,6310,6305,6311,6303,6304,6318,6296,6297,6295,8063,6300,6299,6309,6298,6306,6314,6316,6317,6315,6312,6313],"class_list":["post-14012","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-accessing-sql-server-from-oracle","tag-accessing-sql-server-from-oracle-with-database-gateway","tag-configuring-oracle-database-gateway-for-sql-server","tag-connect-to-oracle-from-postgresql","tag-connect-to-oracle-from-sql-server","tag-connect-to-sql-server-from-postgresql","tag-create-a-database-link-from-linux-oracle-to-sql-server-heterogeneous-connectivity","tag-create-a-database-link-from-oracle-to-sql-server-heterogeneous-connectivity","tag-create-database-link-between-oracle-and-sql-server","tag-create-database-link-from-oracle-to-sql-server","tag-create-database-link-oracle-11g-to-sql-server","tag-creating-a-database-link-from-oracle-to-sql-server","tag-creating-a-dblink-from-oracle-to-sql-server","tag-database-link-from-oracle-to-sql-server","tag-from-oracle-to-sql-server","tag-heterogeneous-connection","tag-heterogeneous-connection-from-oracle-to-sql-server","tag-heterogeneous-connectivity","tag-heterogeneous-database-connections","tag-how-do-i-create-a-database-link-between-oracle-and-sql-server","tag-how-do-i-create-a-database-link-from-oracle-to-sql-server","tag-making-a-connection-from-oracle-to-sql-server","tag-oracle-mssql-dblink","tag-oracle-to-mssql","tag-oracle-to-mssql-connection","tag-oracle-to-mssql-database-link","tag-oracle-to-mssql-dblink","tag-oracle-to-sql-server","tag-oracle-to-sql-server-dblink"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":868,"today_views":0},"yoast_head":"\n
Heterogeneous Connection From Oracle to SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Heterogeneous Connection From Oracle to SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Heterogeneous Connection From Oracle to SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Heterogeneous Connection From Oracle to SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-27T06:58:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-27T11:05:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-82.png\" \/>\n\t<meta property=\"og:image:width\" content=\"593\" \/>\n\t<meta property=\"og:image:height\" content=\"355\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Mehmet \u00c7A\u011eDA\u015e SAYGILI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mehmet \u00c7A\u011eDA\u015e SAYGILI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/\"},\"author\":{\"name\":\"Mehmet \u00c7A\u011eDA\u015e SAYGILI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/513cd28d8dd4b54669335ae91d8937b1\"},\"headline\":\"Heterogeneous Connection From Oracle to SQL Server\",\"datePublished\":\"2020-01-27T06:58:26+00:00\",\"dateModified\":\"2020-01-27T11:05:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/\"},\"wordCount\":549,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-82.png\",\"keywords\":[\"Accessing SQL Server from Oracle\",\"Accessing SQL Server from Oracle with Database Gateway\",\"Configuring Oracle Database Gateway for SQL Server\",\"Connect to Oracle From PostgreSQL\",\"Connect To Oracle From SQL Server\",\"Connect to SQL Server From PostgreSQL\",\"create a database link from linux oracle to sql server heterogeneous connectivity\",\"create a database link from oracle to sql server heterogeneous connectivity\",\"create database link between oracle and sql server\",\"create database link from oracle to sql server\",\"create database link oracle 11g to sql server\",\"Creating a \\\"database link\\\" from Oracle to SQL Server\",\"Creating a DBLINK from Oracle to SQL Server\",\"Database link from Oracle to SQL Server\",\"From Oracle to SQL Server\",\"Heterogeneous Connection\",\"Heterogeneous Connection From Oracle to SQL Server\",\"Heterogeneous Connectivity\",\"Heterogeneous Database connections\",\"How do I create a database link between Oracle and SQL Server?\",\"how do i create a database link from oracle to sql server\",\"Making a Connection from Oracle to SQL Server\",\"oracle mssql dblink\",\"oracle to mssql\",\"oracle to mssql connection\",\"oracle to mssql database link\",\"oracle to mssql dblink\",\"oracle to sql server\",\"oracle to sql server dblink\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/\",\"name\":\"Heterogeneous Connection From Oracle to SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-82.png\",\"datePublished\":\"2020-01-27T06:58:26+00:00\",\"dateModified\":\"2020-01-27T11:05:23+00:00\",\"description\":\"Heterogeneous Connection From Oracle to SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-82.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-82.png\",\"width\":593,\"height\":355},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Heterogeneous Connection From Oracle to SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/513cd28d8dd4b54669335ae91d8937b1\",\"name\":\"Mehmet \u00c7A\u011eDA\u015e SAYGILI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/20819fc2b411edc22c026303f048558d9e60a52db16b0632d9871e2450ffce4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/20819fc2b411edc22c026303f048558d9e60a52db16b0632d9871e2450ffce4c?s=96&d=mm&r=g\",\"caption\":\"Mehmet \u00c7A\u011eDA\u015e SAYGILI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/cagdassaygili\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Heterogeneous Connection From Oracle to SQL Server - Database Tutorials","description":"Heterogeneous Connection From Oracle to SQL Server","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Heterogeneous Connection From Oracle to SQL Server - Database Tutorials","og_description":"Heterogeneous Connection From Oracle to SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-27T06:58:26+00:00","article_modified_time":"2020-01-27T11:05:23+00:00","og_image":[{"width":593,"height":355,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-82.png","type":"image\/png"}],"author":"Mehmet \u00c7A\u011eDA\u015e SAYGILI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mehmet \u00c7A\u011eDA\u015e SAYGILI","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/"},"author":{"name":"Mehmet \u00c7A\u011eDA\u015e SAYGILI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/513cd28d8dd4b54669335ae91d8937b1"},"headline":"Heterogeneous Connection From Oracle to SQL Server","datePublished":"2020-01-27T06:58:26+00:00","dateModified":"2020-01-27T11:05:23+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/"},"wordCount":549,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-82.png","keywords":["Accessing SQL Server from Oracle","Accessing SQL Server from Oracle with Database Gateway","Configuring Oracle Database Gateway for SQL Server","Connect to Oracle From PostgreSQL","Connect To Oracle From SQL Server","Connect to SQL Server From PostgreSQL","create a database link from linux oracle to sql server heterogeneous connectivity","create a database link from oracle to sql server heterogeneous connectivity","create database link between oracle and sql server","create database link from oracle to sql server","create database link oracle 11g to sql server","Creating a \"database link\" from Oracle to SQL Server","Creating a DBLINK from Oracle to SQL Server","Database link from Oracle to SQL Server","From Oracle to SQL Server","Heterogeneous Connection","Heterogeneous Connection From Oracle to SQL Server","Heterogeneous Connectivity","Heterogeneous Database connections","How do I create a database link between Oracle and SQL Server?","how do i create a database link from oracle to sql server","Making a Connection from Oracle to SQL Server","oracle mssql dblink","oracle to mssql","oracle to mssql connection","oracle to mssql database link","oracle to mssql dblink","oracle to sql server","oracle to sql server dblink"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/","name":"Heterogeneous Connection From Oracle to SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-82.png","datePublished":"2020-01-27T06:58:26+00:00","dateModified":"2020-01-27T11:05:23+00:00","description":"Heterogeneous Connection From Oracle to SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-82.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-82.png","width":593,"height":355},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/heterogeneous-connection-from-oracle-to-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Heterogeneous Connection From Oracle to SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/513cd28d8dd4b54669335ae91d8937b1","name":"Mehmet \u00c7A\u011eDA\u015e SAYGILI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/20819fc2b411edc22c026303f048558d9e60a52db16b0632d9871e2450ffce4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/20819fc2b411edc22c026303f048558d9e60a52db16b0632d9871e2450ffce4c?s=96&d=mm&r=g","caption":"Mehmet \u00c7A\u011eDA\u015e SAYGILI"},"url":"https:\/\/dbtut.com\/index.php\/author\/cagdassaygili\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14012","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/486"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14012"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14012\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14014"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14012"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14012"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14012"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}