Blog: Dan E. Linstedt Subscribe to this blog's RSS feed!

Dan Linstedt

Bill Inmon has given me this wonderful opportunity to blog on his behalf. I like to cover everything from DW2.0 to integration to data modeling, including ETL/ELT, SOA, Master Data Management, Unstructured Data, DW and BI. Currently I am working on ways to create dynamic data warehouses, push-button architectures, and automated generation of common data models. You can find me at Denver University where I participate on an academic advisory board for Masters Students in I.T. I can't wait to hear from you in the comments of my blog entries. Thank-you, and all the best; Dan Linstedt http://www.COBICC.com, danL@danLinstedt.com

About the author >

Cofounder of Genesee Academy, RapidACE, and BetterDataModel.com, Daniel Linstedt is an internationally known expert in data warehousing, business intelligence, analytics, very large data warehousing (VLDW), OLTP and performance and tuning. He has been the lead technical architect on enterprise-wide data warehouse projects and refinements for many Fortune 500 companies. Linstedt is an instructor of The Data Warehousing Institute and a featured speaker at industry events. He is a Certified DW2.0 Architect. He has worked with companies including: IBM, Informatica, Ipedo, X-Aware, Netezza, Microsoft, Oracle, Silver Creek Systems, and Teradata.  He is trained in SEI / CMMi Level 5, and is the inventor of The Matrix Methodology, and the Data Vault Data modeling architecture. He has built expert training courses, and trained hundreds of industry professionals, and is the voice of Bill Inmons' Blog on http://www.b-eye-network.com/blogs/linstedt/.

If you haven't heard of them already, you should! These guys are hot in the market space. They are open source ETL, ELT, BI, Dashboards, and Analytics. Two awesome companies that should be checked out. One is Pentaho, and the other is Bread-Board BI. For low-cost solutions, these guys are hot. There are major institutions out there currently examining the use of tools like these. for prime-time.

Apparently I'm not the only one to notice. Pentaho grabs $8M in funding according to Computer Business Review Online. Shawn Rogers had a post back in July referencing these two vendors.

The link to the open source (sourceForge project for Pentaho is):
http://sourceforge.net/projects/pentaho
http://www.pentaho.org

"A complete business intelligence platform that includes reporting, analysis (OLAP), dashboards, data mining and data integration (ETL). Use it as a full suite or as individual components that are accessible via web services. Ranked #1 in open source BI. "

The link to Bread-Board BI is:
http://www.breadboardBI.com
Bread Board BI has an On-Line demo that hits real-data in a real database....
http://24.5.207.85:7070/pentaho/Navigate?&solution=breadboard

"In a highly competitive global marketplace, knowing your customers, supply chain, finances, and workforce are critical to success. In the recent past, the complex systems required to consolidate and display this knowledge were extremely expensive and time-consuming to build. As a result, many systems never moved past the brainstorming stage, others were killed in development due to cost overruns.

Packaged Content + Open Source = The Breadboard Difference
Seasoned experts from Breadboard BI or one of our global partners match your needs to one or more Breadboard BI Solution Areas. Your solution is then iteratively customized using open source Solution Slices™. The result is a highly-tailored, scalable, enterprise solution built rapidly and inexpensively."


Posted September 13, 2006 8:07 AM
Permalink | 5 Comments |

5 Comments

A similar project is Talend Open Studio. To discover it, visit http://www.talend.com !

Talend's solutions were created to allow users to develop their own components as well as easily integrate existing modules. Talend supplies a simple and functioning tool to package a module and integrate it into the Talend library.

The Talend solution is universal: its open component library is accessible to the developer community where quick and reliable product enhancements are completed.

The BBBI demo has moved to http://breadboardbi.dnsalias.com. Your old link does not work.

Scriptella provides a developer's view on ETL process. It's like Ant for ETL and script execution - no fancy GUI, but it does its job well. Check it out!!


Scriptella is an Extract-Transform-Load (ETL) and script execution tool. Its primary focus is simplicity. It doesn't require the user to learn another complex XML-based language to use it, but allows the use of SQL or another scripting language suitable for the data source to perform required transformations.

One more similar product is ETL Integrator. Though the code is not yet open source, its available for free download. The link is www.glassfishwiki.org/jbiwiki/Wiki.jsp?page=ETLSE

Time has proven Olivier right if you are considering the tremendous evolution of Talend Open Studio since 2006. Indeed, the fast-growing Talend community, combined with the expertise of the engineers, has made it possible to improve significantly the first open source data integration solution.

Here are some features that have been added since the product's initial release:
- support of new databases (including bulk loaders)
- enhancement of context management (GUI, new tContextDump component)
- significant performance improvements of a number of components and connectors
- release of the ELT mode, which was subsequently enhanced with the ability to externalize SQL patterns

It proves that the strength of open source doesn't reside only in the cost savings, but also in that open source solutions improve faster than proprietary ones.

Leave a comment

    
Search this blog
Categories ›
Archives ›
Recent Entries ›