The Channel logo


By | Gavin Clarke 25th March 2008 21:59

Microsoft and JasperSoft connect on Excel

On-demand service taps power of desktop

OSBC Excel is the focus of a technology interoperability initiative between Microsoft and open-source BI specialist JasperSoft.

JasperSoft has announced ODBO Connect, which integrates its web- and GPL-based JasperAnalysis relational OLAP server with PivotTables in Microsoft's Excel spreadsheet package.

JasperSoft ODBO Connect will let people analyze data using the desktop-based Excel client instead of working through a browser. JasperSoft ODBO Connect uses a combination of OLE DB for OLAP, XML for Analysis, and Multidimensional Expressions.

Also announced is Windows Server 2008 certification for the JasperSoft Business Intelligence suite, updating previous certification for Windows Server 2003 and Windows XP.

The connector and certification are part of a series of initiatives intended to fine tune the JasperSoft Business Intelligence suite to Windows Server 2008 and other "key" Microsoft software.

Work between the companies continues Microsoft's strategy of ensuring that Windows remains the platform of choice for users running open source applications and middleware, so they do not drift into using Linux instead.

JasperSoft chief executive Brian Gentile in a statement called Windows Server a "clear standard" adding Excel is "the most widely used desktop data analysis tool." Microsoft claimed more than 50 per cent of OLAP deployments use Excel as the client interface while JasperSoft claims 8,000 commercial customers running its software and services.®

alert Send corrections


Frank Jennings

What do you do? Use manual typwriters or live in a Scottish croft? Our man advises
A rusty petrol pump at an abandoned gas station. Pic by Silvia B. Jakiello via shutterstock

Trevor Pott

Among other things, Active Directory needs an overhaul
Baby looks taken aback/shocked/affronted. Photo by Shutterstock

Kat Hall

Plans for 2 million FTTP connections in next four years 'not enough'
Microsoft CEO Satya Nadella


League of gentlemen poster - Tubbs and Edward at the local shop. Copyright BBC
One reselling man tells his tale of woe