Configuration of DB connection is optional. Embedded Apache Derby DB is used by default and it is sufficient for evaluation, however configuration of external DB connection is strongly recommended for production deployment. It is possible to specify common JDBC DB connection attributes (URL, username, password) or JNDI location of DB DataSource.

Configurations and their changes may be as follows:

Upgrade of DB schema

If you replace older version of CloverETL Server by new one above the same DB, there may be some changes in DB schema. Since CloverETL Server version 1.2, DB patches above existing DB schema are done automatically, during first startup. However If you are upgrading from DB schema of version 1.1. you will have to preset this feature by these SQL updates:

CREATE TABLE sys_schema_patches (patch varchar(256) unique not null, applied timestamp);
INSERT INTO sys_schema_patches (patch,applied) values ('0000_create.sql', null );

Do not execute it above empty DB! It is intended only for upgrading from existing DB schema of 1.1. version.