{"id":4273,"date":"2011-08-25T09:58:00","date_gmt":"2011-08-25T16:58:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/"},"modified":"2024-01-22T22:49:58","modified_gmt":"2024-01-23T06:49:58","slug":"microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/","title":{"rendered":"Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse"},"content":{"rendered":"<p>Two weeks ago, <a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans.aspx\">Microsoft announced its commitment to Hadoop<\/a> and promised to release new connectors to promote interoperability between Hadoop and SQL Server. Today we are announcing the availability of the Community Technology Preview (CTP) of two connectors for <a href=\"http:\/\/hadoop.apache.org\/\">Hadoop<\/a>: The first is a Hadoop connector for SQL Server Parallel Data Warehouse (PDW) that enables customers to move large volumes of data between Hadoop and SQL Server PDW. The second connector empowers customers to move data between Hadoop and SQL Server 2008 R2. Together these connectors will allow customers to derive business insights from both structured and unstructured data.<\/p>\n<p><strong>Hadoop Connector for SQL Server Parallel Data Warehouse<\/strong><br \/>SQL Server PDW is a fully integrated appliance for the most demanding Data Warehouses that offers customers massive scalability to over 600 TB, and breakthrough performance at low cost.\u00a0 PDW is an excellent solution for analyzing large volumes of structured data in an organization. The new Hadoop connector enables customers to move data seamlessly between Hadoop and PDW.\u00a0\u00a0 With this connector customers can analyze unstructured data in Hadoop and then integrate useful insights back into PDW.\u00a0\u00a0 As a two way connector, it also enables customers to move data from PDW to a Hadoop environment. The connector uses SQOOP (SQL to Hadoop) for efficient data transfer between the Hadoop File System (HDFS) and relational databases. In addition, it uses the high performance PDW Bulk Load\/Extract tool for fast import and export of data.<\/p>\n<p>Existing SQL Server PDW customers can obtain the Hadoop connector for PDW from <a href=\"http:\/\/blogs.technet.commailto:pdwsup@microsoft.com\">Microsoft\u2019s Customer Support Service<\/a>, as is also the case for the Microsoft Informatica Connector for SQL Server PDW, and Microsoft SAP Business Objects DI Connector for SQL Server PDW.<\/p>\n<p><strong>Hadoop Connector for SQL Server<\/strong> <br \/>This connector enables customers to move data between Hadoop and SQL Server.\u00a0 It is compatible with SQL Server 2008 R2 and SQL Server code named \u201cDenali\u201d.\u00a0 Like the PDW version, this is a two-way connector that allows the movement of data to and from a Hadoop environment.\u00a0 It also uses SQOOP for efficient data movement.\u00a0 The <a href=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=27194\">CTP version of this connector is now available for trial<\/a>.\u00a0 Together these two connectors reaffirm Microsoft\u2019s commitment to interoperability with Hadoop.\u00a0 Customers can use them to derive business insights from all their data \u2013 structured or unstructured.\u00a0\u00a0<\/p>\n<p>Building on the Business Intelligence Platform and Data Warehousing capabilities provided by SQL Server, the support for near real time insights and analytics into large volumes of complex unstructured data i.e. \u2018Big Data\u2019 will continue to be a focus area for us. The connectors are a first step in this journey and you can expect to hear more from us in the coming year.<\/p>\n<p>Test drive these connectors and send us your feedback. Thanks!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Two weeks ago, Microsoft announced its commitment to Hadoop and promised to release new connectors to promote interoperability between Hadoop and SQL Server.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-4273","post","type-post","status-publish","format-standard","hentry","content-type-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Two weeks ago, Microsoft announced its commitment to Hadoop and promised to release new connectors to promote interoperability between Hadoop and SQL Server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2011-08-25T16:58:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse\",\"datePublished\":\"2011-08-25T16:58:00+00:00\",\"dateModified\":\"2024-01-23T06:49:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/\"},\"wordCount\":466,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/\",\"name\":\"Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2011-08-25T16:58:00+00:00\",\"dateModified\":\"2024-01-23T06:49:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse - Microsoft SQL Server Blog","og_description":"Two weeks ago, Microsoft announced its commitment to Hadoop and promised to release new connectors to promote interoperability between Hadoop and SQL Server.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2011-08-25T16:58:00+00:00","article_modified_time":"2024-01-23T06:49:58+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse","datePublished":"2011-08-25T16:58:00+00:00","dateModified":"2024-01-23T06:49:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/"},"wordCount":466,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/","name":"Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2011-08-25T16:58:00+00:00","dateModified":"2024-01-23T06:49:58+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/25\/microsoft-ships-ctp-of-hadoop-connectors-for-sql-server-and-parallel-data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=4273"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4273\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=4273"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=4273"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=4273"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=4273"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=4273"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=4273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}