I was having a discussion with the CEO of an Open Source company recently and we started discussing our opinion of the “kett uhl” Open Source ETL projects. It quickly became clear that we had different ideas about the project and its sponsorship. Until there was a clearly identifying difference… An “ah ha” moment.

Kinetic ETL (open source ETL project) is not the same as KETTLE (open source ETL project).

There’s only a handful of Open Source ETL projects currently. It seems silly that there should already be brand confusion for such a small group of players… Anyone from either of these projects care to comment on their choice of such similar names? Pure coincidence?

Not earth shattering news, and who knows if there isn’t some “extra stuff” in it for the Beta releases, but I just realized that OWB is placing more than 1GB of it’s own bits on my virtual workstation. Beta4 would not fit on one CD (800 MB).

Of course the actual release might differ, and your mileage may vary, etc. That, and who really cares about disk space these days? Disk space is cheap! 🙂

Don’t want to get too far into it, because there has been some significant developments from when I last surveyed the scene about 6 months ago. However, I did want to point out that Pentaho has made significant progress in building their Open Source BI stack and are starting to build 1.x release candidates. They’ve sorted out $5 million in financing to really allow them to take this to the next level.

Congratulations on the progress, and I personally look forward to seeing more great work coming from Orlando, FL.

I had organized an opportunity for Paris users to get together and swap stories, tips, etc. There were many different viewpoints represented and I’m glad that we had a chance to virtually meet up and discuss our experiences with the product. There is not another virtual user group meeting planned, but we are setting up an online forum to continue the peer to peer discussions.

If you are an OWB Beta program member (legal reasons) and would like to get on the forum, please email me.

PS – I’m happy to open it up to the community as soon as the developer preview release hits OTN.

I’m usually posting pictures about fancy new features in OWB Paris, and doling out little tidbits about how to this and that… I thought I’d change it up a bit and ask a question! Now that I’ve got comments working I can do fun things like that! I don’t want to influence any ideas so I won’t mention how I would go about this, so, here ’tis.

What is the most EFFECIENT way using Oracle SQL to calculate effective/expiration for denormalized tables? ie, if you have two tables with the SAME natural key with their own set of effective/expiration dates what is the most EFFICIENT SQL to generate a new denormalized table with accurate effective/expiration dates?