{"id":413,"date":"2014-12-16T09:00:00","date_gmt":"2014-12-16T17:00:00","guid":{"rendered":""},"modified":"2024-01-22T22:48:42","modified_gmt":"2024-01-23T06:48:42","slug":"relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/","title":{"rendered":"Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3"},"content":{"rendered":"<p><em>This blog post was authored by: <\/em><a href=\"https:\/\/social.technet.microsoft.com\/profile\/matt%20usher%20(msft)\/?WT.mc_id=Blog_SQL_Announce_DI\">Matt Usher<\/a><em>, Senior PM on the Microsoft Analytics Platform System (APS) team<\/em><\/p>\n<p>Microsoft is happy to announce the release of the <a href=\"http:\/\/www.microsoft.com\/aps?WT.mc_id=Blog_SQL_Announce_DI\">Analytics Platform System<\/a> (APS) Appliance Update (AU) 3. APS is Microsoft\u2019s big data in a box appliance for serving the needs of relational data warehouses at massive scale. With this release, the APS appliance supports new scenarios for utilizing <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/\">Power BI<\/a> modeling, visualization, and collaboration tools over on premise data sets. In addition, this release extends the PolyBase to allow customers to utilize the HDFS infrastructure in Hadoop for ORC files and directory modeling to more easily integrate non-relational data into their data insights.<\/p>\n<p>The AU3 release includes:<\/p>\n<ul>\n<li>PolyBase recursive Directory Traversal and ORC file format support<\/li>\n<li>Integrated Data Management Gateway enables query from Power BI to on premise APS<\/li>\n<li>TSQL compatibility improvements to reduce migration friction from SQL Server SMP<\/li>\n<li>Replatformed to Windows Server 2012 R2 and<a href=\"http:\/\/www.microsoft.com\/sqlserver?WT.mc_id=Blog_SQL_Announce_DI\"> SQL Server 2014<\/a><\/li>\n<\/ul>\n<h1>PolyBase Directory Traversal and ORC File Support<\/h1>\n<p><a href=\"\/sqlserver\/2014\/06\/02\/polybase-in-aps-yet-another-sql-over-hadoop-solution\/?WT.mc_id=Blog_SQL_Announce_DI\">PolyBase<\/a> is an integrated technology that allows customers to utilize the skillset that they have developed in TSQL for querying and managing data in Hadoop platforms. With the AU3 release, the APS team has augmented this technology with the ability to define an external table that targets a directory structure as a whole. This new ability unlocks a whole new set of scenarios for customers to utilize their existing investments in Hadoop as well as APS to provide greater insight into all of the data collected within their data systems. In addition, AU3 introduces full support for the Optimized Row Column (ORC) file format \u2013 a common storage mechanism for files within Hadoop.<\/p>\n<p>As an example of this new capability, let\u2019s examine a customer that is using APS to host inventory and Point of Sale (POS) data in an APS appliance while storing the web logs from their ecommerce site in a Hadoop path structure. With AU3, the customer can simply maintain a structure for their logs in Hadoop in a structure that is easy to construct such as <i>year\/month\/date\/server\/log<\/i> for simple storage and recovery within Hadoop that can then be exposed as a single table to analysts and data scientists for insights.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png\" alt=\" \" border=\"0\" \/><\/a><\/p>\n<p>In this example, let\u2019s assume that each of the Server<i>xx<\/i> folders contains the log file for that server on that particular day. In order to surface the entire structure, we can construct an external table using the following definition:<\/p>\n<pre>CREATE EXTERNAL TABLE [dbo].[WebLogs]\n(\n\t[Date] DATETIME NULL,\n\t[Uri] NVARCHAR(256) NULL,\n\t[Server] NVARCHAR(256) NULL,\n\t[Referrer] NVARCHAR(256) NULL\n)\nWITH\n(\n\tLOCATION='\/\/Logs\/',\n\tDATA_SOURCE = Azure_DS,\n\tFILE_FORMAT = LogFileFormat,\n\tREJECT_TYPE = VALUE,\n\tREJECT_VALUE = 100\n);\n<\/pre>\n<p>By setting the LOCATION targeted at the \/\/Logs\/ folder, the external table will pull data from all folders and files within the directory structure. In this case, a simple select of the data will return data from only the last 10 entries regardless of the log file that contains the data:<\/p>\n<pre>SELECT TOP 5\n\t*\nFROM\n\t[dbo].[WebLogs]\nORDER BY\n\t[Date]\n<\/pre>\n<p>The results are:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-2.png\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-2.png\" alt=\" \" border=\"0\" \/><\/a><\/p>\n<p><b>Note: <\/b>PolyBase, like Hadoop, will not return results from hidden folders or any file that begins with an underscore (_) or period(.).<\/p>\n<h1>Integrated Data Management Gateway<\/h1>\n<p>With the integration of the Microsoft Data Management Gateway into APS, customers now have a scale-out compute gateway for Azure cloud services to more effectively query sophisticated sets of on-premises data.\u00a0 Power BI users can leverage PolyBase in APS to perform more complicated mash-ups of results from on-premises unstructured data sets in Hadoop distributions. By exposing the data from the APS Appliance as an OData feed, Power BI is able to easily and quickly consume the data for display to end users.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-3.png\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-3.png\" alt=\" \" border=\"0\" \/><\/a><\/p>\n<p>For more details, please look for an upcoming blog post on the Integrated Data Management Gateway.<\/p>\n<h1>TSQL Compatibility improvements<\/h1>\n<p>The AU3 release incorporates a set of TSQL improvements targeted at richer language support to improve the types of queries and procedures that can be written for APS. For AU3, the primary focus was on implementing full error handling within TSQL to allow customers to port existing applications to APS with minimal code change and to introduce full error handling to existing APS customers. Released in AU3 are the following keywords and constructs for handling errors:<\/p>\n<ul>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms175976.aspx?WT.mc_id=Blog_SQL_Announce_DI\">TRY\u2026CATCH<\/a><\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ee677615.aspx?WT.mc_id=Blog_SQL_Announce_DI\">THROW<\/a><\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms178592.aspx?WT.mc_id=Blog_SQL_Announce_DI\">RAISERROR<\/a><\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms176047.aspx?WT.mc_id=Blog_SQL_Announce_DI\">PRINT<\/a><\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms190358.aspx?WT.mc_id=Blog_SQL_Announce_DI\">ERROR_MESSAGE<\/a>, <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms175069.aspx?WT.mc_id=Blog_SQL_Announce_DI\">ERROR_NUMBER<\/a>, <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms178567.aspx?WT.mc_id=Blog_SQL_Announce_DI\">ERROR_SEVERITY<\/a>, <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms180031.aspx?WT.mc_id=Blog_SQL_Announce_DI\">ERROR_STATE<\/a>, <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms188398.aspx?WT.mc_id=Blog_SQL_Announce_DI\">ERROR_PROCEDURE<\/a><\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms188790.aspx?WT.mc_id=Blog_SQL_Announce_DI\">@@ERROR<\/a><\/li>\n<\/ul>\n<p>In addition to the error handling components, the AU3 release also includes support for the <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms189797.aspx?WT.mc_id=Blog_SQL_Announce_DI\">XACT_STATE<\/a> scalar function that is used to indicate the current running transaction state of a user request.<\/p>\n<h1>Replatformed to Windows Server 2012 R2 and SQL Server 2014<\/h1>\n<p>The AU3 release also marks the upgrade of the core fabric of the APS appliance to <a href=\"http:\/\/www.microsoft.com\/windowsserver?WT.mc_id=Blog_SQL_Announce_DI\">Windows Server 2012 R2<\/a> and SQL Server 2014. With the upgrade to the latest versions of Microsoft\u2019s flagship server operating system and core relational database engine, the APS appliance takes advantage of the improved networking, storage and query execution components of these products. For example, the APS appliance now utilizes a virtualized Active Directory infrastructure which helps to reduce cost and increase domain reliability within the appliance helping to make APS the price\/performance leader in the big data appliance space.<\/p>\n<h1>APS on the Web<\/h1>\n<p>To learn more about the Microsoft Analytics Platform System, please visit us on the web at <a href=\"http:\/\/www.microsoft.com\/aps?WT.mc_id=Blog_SQL_Announce_DI\">http:\/\/www.microsoft.com\/aps<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog post was authored by: Matt Usher, Senior PM on the Microsoft Analytics Platform System (APS) team Microsoft is happy to announce the release of the Analytics Platform System (APS) Appliance Update (AU) 3. APS is Microsoft\u2019s big data in a box appliance for serving the needs of relational data warehouses at massive scale.<\/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":[2397],"content-type":[2448],"topic":[2451,2457],"coauthors":[2487],"class_list":["post-413","post","type-post","status-publish","format-standard","hentry","product-power-bi","content-type-updates","topic-big-data","topic-data-analytics","review-flag-1593580427-503","review-flag-3-1593580441-293","review-flag-5-1593580452-31","review-flag-integ-1593580287-179","review-flag-lever-1593580264-545","review-flag-new-1593580247-437","review-flag-on-pr-1593580830-202"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3 - 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\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This blog post was authored by: Matt Usher, Senior PM on the Microsoft Analytics Platform System (APS) team Microsoft is happy to announce the release of the Analytics Platform System (APS) Appliance Update (AU) 3. APS is Microsoft\u2019s big data in a box appliance for serving the needs of relational data warehouses at massive scale.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/\" \/>\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=\"2014-12-16T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:48:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.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=\"4 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\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3\",\"datePublished\":\"2014-12-16T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:48:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/\"},\"wordCount\":855,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/\",\"name\":\"Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png\",\"datePublished\":\"2014-12-16T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:48:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3\"}]},{\"@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":"Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3 - 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\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/","og_locale":"en_US","og_type":"article","og_title":"Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3 - Microsoft SQL Server Blog","og_description":"This blog post was authored by: Matt Usher, Senior PM on the Microsoft Analytics Platform System (APS) team Microsoft is happy to announce the release of the Analytics Platform System (APS) Appliance Update (AU) 3. APS is Microsoft\u2019s big data in a box appliance for serving the needs of relational data warehouses at massive scale.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2014-12-16T17:00:00+00:00","article_modified_time":"2024-01-23T06:48:42+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png","type":"","width":"","height":""}],"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":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3","datePublished":"2014-12-16T17:00:00+00:00","dateModified":"2024-01-23T06:48:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/"},"wordCount":855,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/","name":"Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png","datePublished":"2014-12-16T17:00:00+00:00","dateModified":"2024-01-23T06:48:42+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-dec16-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/12\/16\/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3"}]},{"@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\/413","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=413"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/413\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=413"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=413"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=413"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=413"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=413"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}