...
Check the following documentation for creating of database, tables and views required for this NiFi flow: DataWareHouse .
This will require to configure NiFi DBCPConnectionPool (see https://psi.atlassian.net/wiki/spaces/ZMO/pages/edit-v2/583630850#4.-Adding-controllers to configure the controller properly)