informa
/
2 MIN READ
Commentary

Open Source Blossoms at TDWI

The people who say that open source has no impact or visibility in the data warehouse market were shown to be wrong at the TDWI conference in San Diego. Jaspersoft, Talend, Ingres and newcomer Kickfire all had booths at this event. That's a big change from no presence roughly 18 months ago. What's notable is that we're not talking about just BI tools...
The people who say that open source has no impact or visibility in the data warehouse market were shown to be wrong at the TDWI conference in San Diego. We saw a continued rise in open source data warehousing products this summer. Jaspersoft, Talend, Ingres and newcomer Kickfire all had booths at this event. That's a big change from no presence roughly 18 months ago.

What's notable about this is that we aren't talking about just BI tools. This combination of vendors provides complete coverage of the standard data warehouse technology stack, from platform to BI. If you wanted to, you could acquire a complete open source BI solution at this event.Kickfire is another entrant in the data warehouse appliance market, and one of the few with specialized hardware. What they deliver could be described as MySQL on a chip, with the difference that unlike standard MySQL they deliver a compressed columnar data store.

Ingres delivers both a database with BI-enabling features and pre-configured bundles of the database with data warehousing tools. What they call the Icebreaker BI appliance includes ETL and BI tools, pre-configured and installed in Linux virtual machine so you have what amounts to a turnkey software install.

Talend announced at the show the first open source data quality offering that comes integrated with ETL and data profiling tools. I covered the data quality announcement elsewhere. ETL is tough market these days, with free tools from Oracle and Microsoft. What open source ETL providers offer is a measure of independence from the databases.

Jaspersoft provides web-delivered interactive and static reporting tools, dashboards and even Excel and OLAP plugins. They're one of the products bundled with the Icebreaker BI appliance, and used extensively by application vendors who need embedded BI capabilities.

There are many other open source offerings, of both commercial and community varieties, who were not present at the show. You can find open source tools for everything from real-time and service integration (e.g. Jitterbit) to Java embeddable report libraries (e.g. BIRT). It's a part of the data warehouse and BI market worth exploring.The people who say that open source has no impact or visibility in the data warehouse market were shown to be wrong at the TDWI conference in San Diego. Jaspersoft, Talend, Ingres and newcomer Kickfire all had booths at this event. That's a big change from no presence roughly 18 months ago. What's notable is that we're not talking about just BI tools...

Editor's Choice
James M. Connolly, Contributing Editor and Writer
Carrie Pallardy, Contributing Reporter
Roger Burkhardt, Capital Markets Chief Technology Officer, Broadridge Financial Solutions
Shane Snider, Senior Writer, InformationWeek
Sara Peters, Editor-in-Chief, InformationWeek / Network Computing
Brandon Taylor, Digital Editorial Program Manager
Jessica Davis, Senior Editor
John Edwards, Technology Journalist & Author