What is the Microsoft Analytics Platform System (APS)?

Analytics Platform System (APS) is simply a renaming of the Parallel Data Warehouse (PDW).  It is not really a new product, but rather a name change due to a new feature in Appliance Update 1 (AU1) of PDW.  That new feature is the ability to have a HDInsight region (a Hadoop cluster) inside the appliance.

So APS combines SQL Server and Hadoop into a single offering that Microsoft is touting as providing “big data in a box.”

Think of APS as the “evolution” of Microsoft’s current SQL Server Parallel Data Warehouse product.  Using PolyBase, it now supports the ability to query data using SQL across the traditional data warehouse, plus data stored in a Hadoop region, whether in the appliance or a separate Hadoop Cluster.

More info:

The data platform for a new era

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in PDW/APS, SQLServerPedia Syndication. Bookmark the permalink.

4 Responses to What is the Microsoft Analytics Platform System (APS)?

  1. Very interesting. I clicked on the Polybase article and found that very interesting also. I’ve got to sit down and start diving into this stuff a little. Sounds like SQL PDW and SQL 2014 will be very exciting in terms of the relationship with non-relational and NoSQL technologies.

  2. Pingback: Parallel Data Warehouse (PDW) benefits made simple | James Serra's Blog

  3. Indira says:

    Hi James,

    Could you please let me know what are the steps involved to move on-premise PDW to Azure SQL Database? What are the business cases/ benefits that will need such migration? As we know Azure SQL Database will be a subscription based model does that mean my appliance will be redundant after the migration?


  4. Kalpesh says:

    Thanks James for detailed explanation. Can you please update the hardware requirement for using Microsoft APS? I am mainly looking for details like Operating system, Number of CPUs, RAM required, any third party tools required to connect relational data and BIG Data etc.
    Thanks in advance for your response.