This is a step by step guide to setting up Pentaho on Amazon EC2.
If you haven’t already done so, you’ll need to sign up with EC2.
Once you’ve signed up, log in to the AWS Management Console and launch a new instance. I usually create a spot request because I just want a sandpit and it can be significantly cheaper (but don’t tell anyone or it will get more expensive). A small instance is fine here. Choose the most basic Fedora package (as of writing “Basic Fedora Core 8″, ami-84db39ed). We’ll install everything else ourselves.
Read more…
Tweet This Post 
Delicious 
Digg This Post 
Facebook
It had to happen sooner or later, today I had to query an XML type column in Oracle. It’s a lot easier than I thought it would be – but only because I wanted to return a singular attribute.
This is how I did it using Toad:
Read more…
Tweet This Post Delicious Digg This Post Facebook
Following in the footsteps of the US (http://www.data.gov/), Australia (http://data.australia.gov.au/) and countless others, the UK government have launched their central repository of public data – http://data.gov.uk/.
At first glance it looks well organised. They’ve probably gone a bit overboard with Web 2.0, by including:
- 2.0 colours
- Blog
- RSS feeds
- Bookmark and share tags
- Forum
- Twitter
- Wiki
That aside, the important part is the data. Read more…
Tweet This Post Delicious Digg This Post Facebook