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.
The Agile ArchiveWhen it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
2014 Analytics, BI, and Information Management SurveyITís tried for years to simplify data analytics and business intelligence efforts. Have visual analysis tools and Hadoop and NoSQL databases helped? Respondents to our 2014 InformationWeek Analytics, Business Intelligence, and Information Management Survey have a mixed outlook.