data.vic.gov.au launched
Victoria is the latest state to jump on the open data bandwagon following the Australian government and NSW. So how does it stack up?
Read more…
Victoria is the latest state to jump on the open data bandwagon following the Australian government and NSW. So how does it stack up?
Read more…
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.
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: