Menu
Microsoft, Hortonworks to link Excel and Hadoop

Microsoft, Hortonworks to link Excel and Hadoop

Microsoft teams with Hortonworks to develop an ODBC and a JavaScript library for Hadoop

Microsoft is developing a connector that will allow Excel users to download and analyze output from Hadoop, potentially opening the open-source data processing platform to a much wider audience.

Microsoft is working on the connector with Hortonworks, a Yahoo spinoff that offers a Hadoop distribution and commercial support services.

"What makes this announcement significant is that Microsoft is opening up Apache Hadoop to literally millions of new users," said Hortonworks CTO Eric Baldeschwieler. "There are many more millions of Excel and PowerPivot users that can now derive value from Apache Hadoop using software that is already very familiar to them."

The connector was among several Hadoop-related open-source projects that Microsoft and Hortonworks announced Tuesday at the O'Reilly Strata Data Conference, being held this week in Santa Clara, California. The two companies formed a partnership last year to adapt Hadoop to the Windows ecosystem.

Microsoft and Hortonworks are also developing a JavaScript framework, one that will allow JavaScript programs to explore Hadoop data. And they are working on a series of patches for the Hadoop core that will allow the software to be run on Windows Server.

The connector will be an ODBC (Online Database Connector) that interacts with Hadoop through the Hive data warehouse system. Users will be able to analyze data downloaded from Hive in Excel, using tools such as Excel PowerPivot.

"Microsoft's ODBC driver for Hive is something they've built so that Excel, Power Pivot and other Microsoft tools can connect to Hadoop (via Hive) more easily," said Shaun Connolly, Hortonworks vice president of corporate strategy, via email. "Hortonworks is focused on working with Microsoft to bring this technology into open source so it can be more widely available to and used by the Apache Hadoop community,"

Development for the JavaScript framework will follow a similar path, Connolly said. Microsoft built the core platform for its own products, and Hortonworks will modify it for broader use.

Neither the connector nor the Javascript framework are available now, but they will be released in the near future as open source, Connolly said.

Microsoft has already taken some efforts to embed Hadoop in its ecosystem. The company has released a Hadoop connector for SQL Server. It also offers connectivity to an instance of Hadoop on its Azure cloud service, currently as a developer preview.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is Joab_Jackson@idg.com

Follow Us

Join the ARN newsletter!

Error: Please check your email address.

Upcoming

Slideshows

IN PICTURES: Nutanix's .NEXT channel event in Sydney (+20 photos)

IN PICTURES: Nutanix's .NEXT channel event in Sydney (+20 photos)

Nutanix recently held its customer and channel event, .NEXT, in Sydney. The event, held at the Sheraton on the Park saw attendance from more than 150 channel and technology partners and customers. It was the first in a series of events Nutanix is holding in A/NZ in August and September, the objective of which is to brief partners and customers on “what’s next” in the design and management of datacentre technology.

IN PICTURES: Nutanix's .NEXT channel event in Sydney (+20 photos)
IN PICTURES: EDGE 2015 sponsor debrief (+23 photos)

IN PICTURES: EDGE 2015 sponsor debrief (+23 photos)

Some of the sponsors of ARN's inaugural EDGE 2015 event got together at the ARN office for a debrief of the event. Over some drinks and cheese, these attendees got an update on some key statistics that arose from the EDGE event and discussed potential topics and improvements that can be made at next year's event.

IN PICTURES: EDGE 2015 sponsor debrief (+23 photos)
IN PICTURES: ARN Distributor Roundtable, Sydney, 26.08.15 (+26 photos)

IN PICTURES: ARN Distributor Roundtable, Sydney, 26.08.15 (+26 photos)

ARN hosted a distributor roundtable at Cafe Del Mar in Sydney, at which attendees and their partners discussed the changing role of the traditional IT distributor. They spoke about the challenges of digital disruption, the blurring lines of the channel in the age of digital transformation, and examined the ever-evolving business models. This roundtable was sponsored by Distribution Central, Exclusive Networks, Rhipe, and Hemisphere Technologies. Photos by ARN Editorial Director, Mike Gee.

IN PICTURES: ARN Distributor Roundtable, Sydney, 26.08.15 (+26 photos)

iasset.com is a channel management ecosystem that automates all major aspects of the entire sales, marketing and service process, including data tracking, integrated learning, knowledge management and product lifecycle management.

Show Comments