By default the server uses embedded database (Derby) - this database is not recommended for production use.
We need to set up the database for production use. The database to use (Oracle) has strict access control, and does not allow the application to create tables etc. dynamically. We need to provide schema / DDL to the database administrator, and they will set up the database for CloverETL server to use.
Will this work with CloverETL? Where or how can we get the DDL?
We do not use database connection in our graph or job flow. The database is only for CloverETL server management data.