{"id":2101,"date":"2020-10-15T07:00:00","date_gmt":"2020-10-15T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=2101"},"modified":"2025-06-12T18:11:10","modified_gmt":"2025-06-12T15:11:10","slug":"ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/","title":{"rendered":"Is query join performed between SQL Server and Oracle tables? (aka PolyBase)"},"content":{"rendered":"<p>In the article we will see a magical way so that we can use in select queries data from external sources (without Linked Server) and more specifically from <strong>Oracle Database<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u03c4\u03b9-\u03b5\u03af\u03bd\u03b1\u03b9-\u03b7-polybase\">What is PolyBase<\/h2>\n\n\n\n<p>From the edition<strong> SQL Server 2016<\/strong> the <strong>Microsoft <\/strong>she gave us her tool <strong>PolyBase <\/strong>so that we can with <strong>T-SQL<\/strong> to read data from external sources (other than SQL Server); In SQL Server 2016 this data could be <strong>Big Data<\/strong> which are stored in <strong>HADOOP <\/strong>the <strong>Azure Blob Storage<\/strong>.<\/p>\n\n\n\n<p>Now with him <strong>SQL Server 2019<\/strong> we can read data located in and <strong>Oracle<\/strong>, <strong>Teradata<\/strong>, <strong>MongoDB <\/strong>and other sources <strong>SQL Server<\/strong> with the help of <strong>external tables<\/strong>.<\/p>\n\n\n\n<p>It enables us to do <strong>pushdown <\/strong>data so that it is processed on the server where the data originates, increasing the performance of queries. <\/p>\n\n\n\n<p>The <strong>external tables<\/strong>  the only space they occupy in the <strong>instance of SQL Server<\/strong>, is the space of <strong>metadata<\/strong>. That is, the structure of the table we are creating.<\/p>\n\n\n\n<p>* <em>The differences between Linked Server and PolyBase can be read from <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/polybase\/polybase-faq?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u03c4\u03b9-\u03b1\u03c0\u03b1\u03b9\u03c4\u03b5\u03af\u03c4\u03b1\u03b9\">What is required<\/h2>\n\n\n\n<p>During the installation we should have chosen to install the feature as well <em>PolyBase Query Service For External Data<\/em>, if we had not done it, we should run the setup again and add it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"803\" height=\"606\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/xt-04.png\" alt=\"\" class=\"wp-image-2107\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/xt-04.png 803w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/xt-04-300x226.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/xt-04-768x580.png 768w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><figcaption class=\"wp-element-caption\">Image is from Microsoft (I forgot to save it when I activated it...)<\/figcaption><\/figure>\n\n\n\n<p>To make sure that the function has been activated in the instance, we also run the following query.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">exec sp_configure @configname = 'polybase enabled', @configvalue = 1;\nRECONFIGURE;<\/pre>\n\n\n\n<p>The user who will create the <strong>SQL Server<\/strong> the external tables should have the following permissions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CREATE TABLE<\/strong><\/li>\n\n\n\n<li><strong>ALTER ANY SCHEMA<\/strong><\/li>\n\n\n\n<li><strong>ALTER ANY EXTERNAL DATA SOURCE<\/strong><\/li>\n\n\n\n<li><strong>ALTER ANY EXTERNAL FILE FORMAT<\/strong><\/li>\n\n\n\n<li><strong>CONTROL DATABASE<\/strong><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>We&#039;ll need it too <strong>credentials <\/strong>her<strong> Oracle Database <\/strong>that have access to the tables we want.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u03c4\u03bf-\u03c0\u03b1\u03c1\u03ac\u03b4\u03b5\u03b9\u03b3\u03bc\u03b1\">The example<\/h2>\n\n\n\n<p>For starters we&#039;ll have to make one <em>master key encryption<\/em> if it doesn&#039;t already exist.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'pass123!';<\/pre>\n\n\n\n<p>We create a credential with its user information <strong>Oracle Database<\/strong> that we will use that will have access to these tables.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">CREATE DATABASE SCOPED CREDENTIAL OracleCredential\nWITH IDENTITY = 'username', Secret = 'password;<\/pre>\n\n\n\n<p>Then we create it <strong>data source <\/strong>in the location, before the :\/\/ characters, we must define what technology the data comes from in our Oracle case, then the hostname\/ip and the door of the instance. As credential we define the credential we created before.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">   CREATE EXTERNAL DATA SOURCE oracle_source\n   WITH (\n     LOCATION = 'oracle:\/\/oracle.dataplatform.gr:1521', --**\n     -- PUSHDOWN = ON | OFF,\n     CREDENTIAL = OracleCredential)<\/pre>\n\n\n\n<p>* PUSHDOWN: <em>specify whether computation should be pushed down to the source. ON by default.<\/em><br>** Don&#039;t spam the hostname is the real one \ud83d\ude42<\/p>\n\n\n\n<p>It&#039;s time to create the external table, it should be compatible <strong>data type<\/strong> for each field as in <strong>source<\/strong>. As a location, we first define it <strong>service_name \/ name of the Oracle database<\/strong> (if we set the default) continuing with the <strong>schema <\/strong>and <strong>table name <\/strong>(note it is case sensitive). As data_source the <strong>data source <\/strong>that we created before.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">   CREATE EXTERNAL TABLE orclDEPT(\n   [DEPTNO] DECIMAL(2) NOT NULL,\n   [DNAME] VARCHAR(14) COLLATE Latin1_General_100_BIN2_UTF8 NOT NULL,\n   [LOC] VARCHAR(13) COLLATE Latin1_General_100_BIN2_UTF8 NOT NULL\n   )\n   WITH (\n    LOCATION='[orcl].SCOTT.DEPT',\n    DATA_SOURCE= oracle_source\n   );\n<\/pre>\n\n\n\n<p>In case any <strong>data type<\/strong> we don&#039;t define it correctly, it will return an error but it will return us at the end the information what data type the fields have in <strong>source<\/strong>.<\/p>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>Msg 105083, Level 16, State 1, Line 34\n105083;The following columns in the user defined schema are incompatible\n.\n.\n.\nThe detected external table schema is: (&#91;DEPTNO] DECIMAL(2) NOT NULL, &#91;DNAME] VARCHAR(14) COLLATE Latin1_General_100_BIN2_UTF8, &#91;LOC] VARCHAR(13) COLLATE Latin1_General_100_BIN2_UTF8).\n<\/code><\/pre>\n\n\n\n<p>Now we are ready to read its data <strong>external table<\/strong> which we made:<\/p>\n\n\n\n<p><em>* Attention with external tables we can only read and not update\/write data <\/em>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select * from orclDEPT;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"270\" height=\"166\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/xt-02.png\" alt=\"\" class=\"wp-image-2104\"\/><\/figure>\n\n\n\n<p>To increase its performance we can get statistics on the table key:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">CREATE STATISTICS orclDEPTstats ON orclDEPT (DEPTNO) WITH     FULLSCAN;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7-\u03c4\u03bf\u03c5-external-table-\u03bc\u03b5-\u03ad\u03bd\u03b1-\u03c0\u03af\u03bd\u03b1\u03ba\u03b1-\u03c3\u03c4\u03bf\u03bd-sql-server\">Connection of the external table with a table in SQL Server<\/h2>\n\n\n\n<p>Now let&#039;s see how easily we connect the table from Oracle to one of SQL Server.<\/p>\n\n\n\n<p>We have created the following table in SQL Server:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">create table dept_address(\nDEPTNO decimal(2),\nADDRESS VARCHAR(15))\n\ninsert into  dept_address values\n(10,'NOWHERE 10'),\n(20,'TOTHATPLACE 53'),\n(30,'STREET 12'),\n(40,'LONGWAYHOME 41')\n\nselect * from dept_address<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"279\" height=\"165\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/xt-01.png\" alt=\"\" class=\"wp-image-2103\"\/><\/figure>\n\n\n\n<p>The connection of the two tables is very simply done with a join in the common field:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select od.DEPTNO,od.DNAME,od.LOC,da.ADDRESS\nfrom orclDEPT od\ninner join dept_address da on od.deptno = da.deptno<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"164\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/xt-03.png\" alt=\"\" class=\"wp-image-2105\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/xt-03.png 392w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/xt-03-300x126.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u03c0\u03b7\u03b3\u03ad\u03c2\">Sources:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-external-table-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CREATE EXTERNAL TABLE (Transact-SQL)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/polybase\/polybase-guide?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">What is PolyBase?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/polybase\/polybase-pushdown-computation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Pushdown computations in PolyBase<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>In the article we will see a magical way so that we can use in select queries data from external sources (without Linked Server) and more specifically from Oracle Database. What is PolyBase Since the SQL Server 2016 version, Microsoft has given us the PolyBase tool so that we can use T-SQL to read data from [...]<\/p>","protected":false},"author":1,"featured_media":702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,15,16],"tags":[29,68,62,23,5,113,6],"class_list":["post-2101","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-ms-sqlserver","category-oracle-db","tag-databases","tag-external-table","tag-joins","tag-microsoft","tag-oracle-database","tag-polybase","tag-sqlserver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u0393\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 query join \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 SQL Server \u03ba\u03b1\u03b9 Oracle? (a.k.a PolyBase) - DataPlatform.gr<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dataplatform.gr\/en\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0393\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 query join \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 SQL Server \u03ba\u03b1\u03b9 Oracle? (a.k.a PolyBase) - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u03a3\u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03ad\u03bd\u03b1\u03bd \u03bc\u03b1\u03b3\u03b9\u03ba\u03cc \u03c4\u03c1\u03cc\u03c0\u03bf \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c3\u03b5 select queries \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03b5\u03be\u03c9\u03c4\u03b5\u03c1\u03b9\u03ba\u03ad\u03c2 \u03c0\u03b7\u03b3\u03ad\u03c2 (\u03c7\u03c9\u03c1\u03af\u03c2 Linked Server) \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc Oracle Database. \u03a4\u03b9 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b7 PolyBase \u0391\u03c0\u03cc \u03c4\u03b7\u03bd \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7 SQL Server 2016 \u03b7 Microsoft \u03bc\u03b1\u03c2 \u03ad\u03b4\u03c9\u03c3\u03b5 \u03c4\u03bf \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf \u03c4\u03b7\u03c2 PolyBase \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bc\u03b5 T-SQL \u03bd\u03b1 \u03b4\u03b9\u03b1\u03b2\u03ac\u03b6\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-15T04:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-12T15:11:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u0393\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 query join \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 SQL Server \u03ba\u03b1\u03b9 Oracle? (a.k.a PolyBase)\",\"datePublished\":\"2020-10-15T04:00:00+00:00\",\"dateModified\":\"2025-06-12T15:11:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/\"},\"wordCount\":169,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"keywords\":[\"Databases\",\"External Table\",\"Joins\",\"Microsoft\",\"Oracle Database\",\"PolyBase\",\"SQL Server\"],\"articleSection\":[\"Databases\",\"Microsoft SQL Server\",\"Oracle Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/\",\"name\":\"\u0393\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 query join \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 SQL Server \u03ba\u03b1\u03b9 Oracle? (a.k.a PolyBase) - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"datePublished\":\"2020-10-15T04:00:00+00:00\",\"dateModified\":\"2025-06-12T15:11:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft SQL Server\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/ms-sqlserver\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u0393\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 query join \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 SQL Server \u03ba\u03b1\u03b9 Oracle? (a.k.a PolyBase)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u0393\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 query join \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 SQL Server \u03ba\u03b1\u03b9 Oracle? (a.k.a PolyBase) - DataPlatform.gr","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:\/\/www.dataplatform.gr\/en\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/","og_locale":"en_US","og_type":"article","og_title":"\u0393\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 query join \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 SQL Server \u03ba\u03b1\u03b9 Oracle? (a.k.a PolyBase) - DataPlatform.gr","og_description":"\u03a3\u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03ad\u03bd\u03b1\u03bd \u03bc\u03b1\u03b3\u03b9\u03ba\u03cc \u03c4\u03c1\u03cc\u03c0\u03bf \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c3\u03b5 select queries \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03b5\u03be\u03c9\u03c4\u03b5\u03c1\u03b9\u03ba\u03ad\u03c2 \u03c0\u03b7\u03b3\u03ad\u03c2 (\u03c7\u03c9\u03c1\u03af\u03c2 Linked Server) \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc Oracle Database. \u03a4\u03b9 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b7 PolyBase \u0391\u03c0\u03cc \u03c4\u03b7\u03bd \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7 SQL Server 2016 \u03b7 Microsoft \u03bc\u03b1\u03c2 \u03ad\u03b4\u03c9\u03c3\u03b5 \u03c4\u03bf \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf \u03c4\u03b7\u03c2 PolyBase \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bc\u03b5 T-SQL \u03bd\u03b1 \u03b4\u03b9\u03b1\u03b2\u03ac\u03b6\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2020-10-15T04:00:00+00:00","article_modified_time":"2025-06-12T15:11:10+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u0393\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 query join \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 SQL Server \u03ba\u03b1\u03b9 Oracle? (a.k.a PolyBase)","datePublished":"2020-10-15T04:00:00+00:00","dateModified":"2025-06-12T15:11:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/"},"wordCount":169,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","keywords":["Databases","External Table","Joins","Microsoft","Oracle Database","PolyBase","SQL Server"],"articleSection":["Databases","Microsoft SQL Server","Oracle Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/","url":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/","name":"\u0393\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 query join \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 SQL Server \u03ba\u03b1\u03b9 Oracle? (a.k.a PolyBase) - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","datePublished":"2020-10-15T04:00:00+00:00","dateModified":"2025-06-12T15:11:10+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/ginetai-query-join-anamesa-se-pinakes-sql-server-kai-oracle-wait-wha\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Server","item":"https:\/\/www.dataplatform.gr\/category\/databases\/ms-sqlserver\/"},{"@type":"ListItem","position":4,"name":"\u0393\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 query join \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 SQL Server \u03ba\u03b1\u03b9 Oracle? (a.k.a PolyBase)"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=2101"}],"version-history":[{"count":3,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2101\/revisions"}],"predecessor-version":[{"id":5921,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2101\/revisions\/5921"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/702"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=2101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=2101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=2101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}