Modern data warehouse solutions from Microsoft help you find new insights from Big Data by seamlessly combining traditional high volume relational stores with new data stores for unstructured data like Hadoop.
Today, non-relational data sources like web logs, sensor data, social sentiment, and devices are being collected to provide deeper insights and gain competitive advantages. The traditional strategy of extracting and cleansing relational data into a central repository needs to adapt for this new world of data. A modern data warehouse solution from Microsoft can accommodate new storage technologies like Hadoop to incorporate non-relational sources and provide integration between the relational warehouse and the Hadoop cluster.
Through a strategic partnership with Hortonworks, Microsoft co-developed the Hortonworks Data Platform for Windows to customers who want to deploy Hadoop on their own servers.
SQL Server Parallel Data Warehouse is a pre-built appliance that has a relational data warehouse engine and a Hadoop region within the same rack. Unlike some Hadoop-only or data warehouse-only appliances, a single appliance provides a completely integrated solution.
Spin up or spin down a Hadoop cluster in the cloud using Microsoft Azure HDInsight. With no hardware to purchase and minimal setup, customers can be up and running on their Hadoop implementation within ten minutes.
PolyBase unifies the relational and non-relational worlds at the query level. Instead of learning a new query language like MapReduce, customers can leverage what they already know (T-SQL). PolyBase integrates with existing Hadoop offerings, including Hortonworks and Cloudera.