Feed on
Posts
Comments

Archive for April, 2007

I’ve got talend and I’m going to use it…

Posted in BI, ETL, Java, Palo, SQLite, Talend, data, excel, kettle, olap, xLite on April 30, 2007 | 1 Comment »

For the last few months I’ve being looking for my ideal ETL platform. That ideal would be open source, platform independent (well at least Windows and Linux), flexible, and easily deployable. It had looked like a combination of Kettle and my micro-ETL combinations of Ruby/SSQLite and Excel/SQLite would be the eventual “winners”. [...]

Read Full Post »

Google Docs & Spreadsheets Help

Posted in GAFyD, education, excel, tagged on April 27, 2007 | 3 Comments »

Most of the discussions about Google D&S tend to frame the conversation in relation to MS Office assuming prior knowledge of the likes of Excel and Word. But my wife, an IT Coach, is finding that more and more people who are drawn to first-time use of computers because of a wish to access [...]

Read Full Post »

HacketyHack from WhyTheLuckyStiff

Posted in Ruby, education, news on April 26, 2007 | No Comments »

No it’s not a tip for the 5.50 at Punchestown it’s the latest project from _why (a legend in the world of Ruby, if a language as young as Ruby can have legends). HacketyHack is a framework to teach kids how to program, built using Ruby and the gekco browser engine, it’s free [...]

Read Full Post »

Talend ETL - A New Contender

Posted in BI, ETL, SQLite, Talend, kettle, news, olap on April 26, 2007 | 4 Comments »

Talend have released a new version of their Open Studio ETL tool. Not as full featured as Pentaho Kettle; only supports a limited number of databases and file formats - no SQLite support shock-horror! The press release promises More than 100 Native Connectors and promises connectors to ERP and CRM tools but [...]

Read Full Post »

New Open Source OLAP

Posted in BI, ETL, data, news, olap, tagged on April 22, 2007 | 4 Comments »

Cubulus is a Mondrian-like OLAP engine supporting a subset of MDX and offering an alternative way of organising fact tables using “hierarchial range clustering of keys” rather than the traditional star-schema approach. Written in Python, very much a pre-alpha release. Interesting but a bit too experimental for me this early on a Sunday morning; [...]

Read Full Post »

New software - Pentaho Kettle 2.5 RC1 and IMP:Palo

Posted in BI, ETL, Palo, data, excel, kettle, news on April 21, 2007 | 3 Comments »

I’ve spend a few hours trying out the latest Kettle 2.5.0 RC1 release candidate, new UI and lots of new features. Looks like the PALO code developed by 3a-strategy will not make into this release, but I see Cubeware have released IMP:PALO cube loading software, offering both a free and a premium [...]

Read Full Post »

More Google Goodness

Posted in JavaScript, data, news, tagged on April 18, 2007 | 1 Comment »

Another interesting Google announcement, this time an AJAX feed API. The API essentially provides the same functionality as Yahoo Pipes but without the user-friendly UI i.e. the ability to create mashups without the need for server-side proxy code. Currently it supplies RSS and ATOM feeds normalised to an ATOM-like JSON output, but [...]

Read Full Post »

What’s up Docs & Spreadsheets?

Posted in ETL, GAFyD, Proto, excel, news, tagged , on April 18, 2007 | No Comments »

Google Spreadsheets now supports simple graphs and named ranges; see the announcement on the google-d-s.blogspot.com blog. I’ve also just noticed that my Google Apps account now includes Docs & Spreadsheets; finally I can move my business documents from my private GMail account into Goggle Apps. Looks like a presentation tool is also on [...]

Read Full Post »

I hope their intentions are honorable…..

Posted in Proto, RSSBus on April 14, 2007 | No Comments »

I’ve said before that these two would make an ideal couple, I see the courting flirting has begun …..
RSSBus
Proto

Read Full Post »

Proto

Posted in ETL, Proto, SQLite, excel, xLite, tagged on April 13, 2007 | 5 Comments »

In the two months since I first came across Proto I’ve worked my way through most of the tutorials and sample applications and I’ve come away with a very positive impression of the product. I hadn’t however managed to the find the time to create a VBA based component; that is until last [...]

Read Full Post »

Habemus Proto

Posted in ETL, Proto, SQLite, excel, xLite on April 10, 2007 | 1 Comment »

I’ve just uploaded my first Proto module; a rewrite of a VBA module I’ve been using for many years to provide me with a bridge between the ease of use of desktop user-focused tools and the power of a SQL enabled database. In the past that database was Oracle (and occasionally MS Access) and [...]

Read Full Post »

Rathmore Exchange to be broadband enabled…

Posted in Rathmore, eadestown, news, tagged , , , on April 6, 2007 | 2 Comments »

For the last year and half I’ve been connecting to the internet via a wireless service provided by a local firm Torque Internet (recently taken over by Callidus Telecom). While the service has its ups and downs (the downs sometimes lasting 2 or 3 days at a time!) it’s a huge improvement on my [...]

Read Full Post »