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. To get more information go here.
More info:
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.
Pingback:Parallel Data Warehouse (PDW) benefits made simple | James Serra's Blog
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?
Thanks,
Indira
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.
Regard
Kalpesh