Gate ingestion review

* Remove JDBC data source use from process
* Change test as memory test
* Define transit DAO in memory for tests