...
5. Creating database and views
After going through all the previous steps to configure the NiFi flow in Import NiFi pipelines, the final step is now to create the database and its views. This will allow NiFi to refresh the data properly.
Check the following documentation for creating the creation of the 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).