ODBC driver for Hive will enable Microsoft Excel and PowerPivot for Excel users to explore Hadoop data.
The partners announced last October that they would jointly develop a Windows Server-compatible distribution of Hadoop. Hortonworks, a Yahoo! spinoff and major contributor to the Hadoop community, has since developed a series of software patches that will enable the open source data processing platform to run on Windows Server. That software is expected to become a part of future Hadoop releases, including the pending 0.23 branch currently under review.
Hive is the data warehousing component of Hadoop, and the new ODBC (open database connectivity) standard integration will enable users of the ubiquitous Microsoft Excel spreadsheet to tap into and explore data from within Hadoop. In addition, users with access to Microsoft's PowerPivot in-memory plug-in for Excel will be able to explore far larger sets of data that might contain tens or even hundreds of millions of rows of information.
It's not clear exactly when Microsoft and Hortonworks will be able to offer a Windows-server compatible Hadoop software distribution, but the inclusion of an ODBC driver for Hive will give that release an accessible data-exploration option. IBM took similar steps when it introduced IBM InfoSphere BigInsights Hadoop software by including a spreadsheet-style BigSheets data-exploration tool.
Excel users will be able to derive value from Hadoop in a way that is familiar to them," said Herain Oberoi, director, product marketing, SQL Server, at Microsoft, in a statement.
The expanded partnership was announced at this week's Strata Conference in Santa Clara, Calif.
How Enterprises Are Attacking the IT Security EnterpriseTo learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
IT Strategies to Conquer the CloudChances are your organization is adopting cloud computing in one way or another -- or in multiple ways. Understanding the skills you need and how cloud affects IT operations and networking will help you adapt.