Pentaho Kettle - Unable to connect to virtual Oracle Database I'm attempting to connect to a virtualized Oracle database but I am receiving the following error:

Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
Listener refused the connection with the following error:


  ORA-12505, TNS:listener does not currently know of SID given in
  connect descriptor The Connection descriptor used by the client was:
  foohost:1521:foodba


Since SIDs are not usable with virtualized databases I need to provide a fully qualified URL (from what I have heard), however I'm not certain how to configure Pentaho to accomplish this.
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.