 |
Natural Insight, By Mark Madsen
Mark Madsen is president of Third Nature, a consulting and research firm focused on business intelligence, data integration and data management. He is a principal author of Clickstream Data Warehousing and speaks about data warehousing and emerging technology. See More by Mark Madsen 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. 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.  This is a public forum. United Business Media and its affiliates are not responsible for and do not control what is posted herein. United Business Media makes no warranties or guarantees concerning any advice dispensed by its staff members or readers. Community standards in this comment area do not permit hate language, excessive profanity, or other patently offensive language. Please be aware that all information posted to this comment area becomes the property of United Business Media LLC and may be edited and republished in print or electronic format as outlined in United Business Media's Terms of Service. Important Note: This comment area is NOT intended for commercial messages or solicitations of business.
|
|
Blog Channels
Cindi Howson on Business Intelligence Tony Byrne on Content Management Rajan Chandras on IT & Information Management
Seth Grimes on Analytics In Context by Doug Henschen Phil Kemelor on Web Analytics Sandy Kemsley's Column Two Nelson Kingon Enterprise App Development David Linthicumon Changing the Enterprise SharePoint TrendWatchby Shawn Shell Data Frontiers, by Curt Monash Enterprise Architecture TrendWatchby Kas Thomas Alan Pelz-Sharpe on Content Management Neil Raden on Business Intelligence Bruce Silver on Business Process Management
STRATEGIC KNOWLEDGE, BY DAVE STODDER
Subscribe to RSS feed of all blogs Archives
|
|
