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.
2017 State of IT ReportIn today's technology-driven world, "innovation" has become a basic expectation. IT leaders are tasked with making technical magic, improving customer experience, and boosting the bottom line -- yet often without any increase to the IT budget. How are organizations striking the balance between new initiatives and cost control? Download our report to learn about the biggest challenges and how savvy IT executives are overcoming them.