About
Oracle Data Integrator not only uses hsqldb for its demo environment. It is also used as the in memory database for the so called Sunopsis Memory Engine.
When creating interfaces for sources and targets that do not store data in a relational database format, you must select a staging area other than the source or target; as an option, you can configure and use Oracle Data Integrator's staging area—Sunopsis Memory Engine.