For modification Tomcat context params, add to context config file (and modify according to your credentials):

<Parameter name="jdbc.driverClassName" value="oracle.jdbc.OracleDriver" override="false" />
<Parameter name="jdbc.url" value="jdbc:oracle:thin:@host:1521:db" override="false" />
<Parameter name="jdbc.username" value="user" override="false" />
<Parameter name="jdbc.password" value="pass" override="false" />
<Parameter name="jdbc.dialect" value="org.hibernate.dialect.Oracle9Dialect" override="false" />

Or If you use properties file for configuration:

jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@host:1521:db
jdbc.username=user
jdbc.password=pass
jdbc.dialect=org.hibernate.dialect.Oracle9Dialect

Do not forget to add jar with JDBC driver to the application server classpath.

Since CloverETL Server version 1.2.1, dialect org.hibernate.dialect.Oracle10gDialect is no longer available. Please use org.hibernate.dialect.Oracle9Dialect instead.

These are privileges which have to be granted to schema used by CloverETL Server:

CONNECT
CREATE SESSION
CREATE/ALTER/DROP TABLE
CREATE/ALTER/DROP SEQUENCE

QUOTA UNLIMITED ON <user_tablespace>;
QUOTA UNLIMITED ON <temp_tablespace>;