Pentaho Kettle - Unable to connect to virtual Oracle Database
So the trick was to go into the Options tab in the Edit Connection dialogue and create a database parameter to define the connection string.