Microsoft announced support for BigData on Azure platform on 12th October 2011 (News). Launched platform deliver 100% Apache Hadoop based distribution installed on Windows Servers. Distribution comprises of HDFS, Hive, PIG installation and available as hadoop-1.1.0-SNAPSHOT under HDInsight 1.6. The exposed REST services/interface can be leveraged by developers to submit and execute MR jobs. JavaScript based interface provides GUI based environment and can be used as an alternate along with Hadoop command prompt.

The same environment can easily be integrated with existing BI tools (Power View, Power View, MS Excel) and allows HIVE connectivity using ODBC Drivers. Following are two additional connectors that allows connectivity to access structures/unstructured data:

  1. SQL Server connector for Apache Hadoop
  2. SQL Server PDW connector for Apache Hadoop

Further references


Leave a Comment