{"id":4343,"date":"2011-08-08T09:29:00","date_gmt":"2011-08-08T16:29:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/"},"modified":"2024-01-22T22:50:02","modified_gmt":"2024-01-23T06:50:02","slug":"parallel-data-warehouse-news-and-hadoop-interoperability-plans","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/","title":{"rendered":"Parallel Data Warehouse News and Hadoop Interoperability Plans"},"content":{"rendered":"<p>Today, businesses are increasingly facing a \u201cdata deluge,\u201d as the complexity and volume of data grows steadily. Meanwhile, IT continues to grapple with how to manage, store that data, as well as unlock the valuable business insights that data holds.\u00a0 That\u2019s why last November Microsoft released SQL Server 2008 R2 Parallel Data Warehouse (PDW) \u2013 a complete, high-scale data warehousing solution that enterprises can use to manage and enable self-service business intelligence across the company with SQL Server.\u00a0 Today, we are excited to announce that PDW is taking several significant steps forward.<\/p>\n<p>The first step forward is the release of our second Appliance Update (AU2) to PDW that delivers richer programmability, plus four new connectors for heterogeneous BI &amp; ETL (Extract, Load and Transform) environments.\u00a0 Unlike Service Packs, an Appliance Update refreshes the full appliance seamlessly with both hardware and software updates.\u00a0 Released just four months after Appliance Update 1, Microsoft is rapidly responding to customer needs on the most demanding Data Warehouses, delivering features most requested by customers such as multi-statement batches, T-SQL variables, temporary tables, conditional logic and control flow statements.\u00a0 Thanks to deep integration with the Microsoft Business Intelligence stack, Parallel Data Warehouse already offers the most complete data warehouse solution. Appliance Update 2 extends this by introducing new connectors for SAP Business Objects and Informatica, enabling customers to use Parallel Data Warehouse seamlessly in heterogeneous BI and ETL environments.\u00a0 In addition, MicroStrategy also has certified high speed connectors for PDW.\u00a0 Customers can now leverage existing investments while scaling their data warehouses at unbeatable price-performance with PDW.<\/p>\n<p>Microsoft is also proud to announce the release of the Dell Parallel Data Warehouse appliance, offering customers more hardware choice thanks to a strategic alliance between Microsoft and Dell. With the new Dell appliance scaling beyond 600 TB with an affordable starting price under $12K per TB, customers can now enjoy massive scalability and performance at low cost on a platform they know and trust, while also receiving white glove service through Microsoft\u2019s Critical Advantage Program (MCAP), an enhanced support service for appliances.\u00a0 In addition, Microsoft Enterprise Services and Dell Services will provide consulting for architectural design and implementation of the PDW solution to meet customer-specific requirements.\u00a0 For more information on Dell\u2019s PDW appliance, visit <a href=\"http:\/\/www.microsoft.com\/pdw\">www.microsoft.com\/pdw<\/a>.<\/p>\n<p>In the data deluge faced by businesses, there is also an increasing need to store and analyze vast amounts of unstructured data including data from sensors, devices, bots and crawlers. By many accounts, almost 80% of what businesses store is unstructured data \u2013 and this volume is predicted to grow exponentially over the next decade.\u00a0 We have entered the age of Big Data. Our customers have been asking us to help store, manage, and analyze both structured and unstructured data \u2013 in particular, data stored in Hadoop environments.\u00a0 As a first step, we will soon release a Community Technology Preview (CTP) of two new Hadoop connectors \u2013 one for SQL Server and one for PDW.\u00a0 The connectors provide interoperability between SQL Server\/PDW and Hadoop environments, enabling customers to transfer data between Hadoop and SQL Server\/PDW.\u00a0 With these connectors, customers can more easily integrate Hadoop with their Microsoft Enterprise Data Warehouses and Business Intelligence solutions to gain deeper business insights from both structured and unstructured data.<\/p>\n<p>With a scalable set of Data Warehousing offerings including SQL Server 2008 R2, Reference Architectures and Data Warehouse appliances, Microsoft enables customers to gain business insights from increasingly large and diverse data sets.\u00a0 The world of data is evolving and Microsoft is committed to helping our customers navigate those changes successfully. We look forward to your feedback on these updates and connectors!<\/p>\n<p>Learn more by visiting <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/\">SQL Server Parallel Data Warehouse<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today, businesses are increasingly facing a \u201cdata deluge,\u201d as the complexity and volume of data grows steadily. Meanwhile, IT continues to grapple with how to manage, store that data, as well as unlock the valuable business insights that data holds.<\/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":[2463],"coauthors":[2487],"class_list":["post-4343","post","type-post","status-publish","format-standard","hentry","content-type-updates","topic-data-warehousing","review-flag-1593580427-503","review-flag-1593580414-58","review-flag-1593580410-819","review-flag-1593580770-633","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-integ-1593580287-179","review-flag-lever-1593580264-545","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Parallel Data Warehouse News and Hadoop Interoperability Plans - 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\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Parallel Data Warehouse News and Hadoop Interoperability Plans - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Today, businesses are increasingly facing a \u201cdata deluge,\u201d as the complexity and volume of data grows steadily. Meanwhile, IT continues to grapple with how to manage, store that data, as well as unlock the valuable business insights that data holds.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/\" \/>\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-08T16:29:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:02+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\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Parallel Data Warehouse News and Hadoop Interoperability Plans\",\"datePublished\":\"2011-08-08T16:29:00+00:00\",\"dateModified\":\"2024-01-23T06:50:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/\"},\"wordCount\":618,\"commentCount\":4,\"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\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/\",\"name\":\"Parallel Data Warehouse News and Hadoop Interoperability Plans - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2011-08-08T16:29:00+00:00\",\"dateModified\":\"2024-01-23T06:50:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Parallel Data Warehouse News and Hadoop Interoperability Plans\"}]},{\"@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":"Parallel Data Warehouse News and Hadoop Interoperability Plans - 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\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/","og_locale":"en_US","og_type":"article","og_title":"Parallel Data Warehouse News and Hadoop Interoperability Plans - Microsoft SQL Server Blog","og_description":"Today, businesses are increasingly facing a \u201cdata deluge,\u201d as the complexity and volume of data grows steadily. Meanwhile, IT continues to grapple with how to manage, store that data, as well as unlock the valuable business insights that data holds.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2011-08-08T16:29:00+00:00","article_modified_time":"2024-01-23T06:50:02+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\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Parallel Data Warehouse News and Hadoop Interoperability Plans","datePublished":"2011-08-08T16:29:00+00:00","dateModified":"2024-01-23T06:50:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/"},"wordCount":618,"commentCount":4,"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\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/","name":"Parallel Data Warehouse News and Hadoop Interoperability Plans - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2011-08-08T16:29:00+00:00","dateModified":"2024-01-23T06:50:02+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/08\/parallel-data-warehouse-news-and-hadoop-interoperability-plans\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Parallel Data Warehouse News and Hadoop Interoperability Plans"}]},{"@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\/4343","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=4343"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4343\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=4343"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=4343"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=4343"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=4343"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=4343"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=4343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}