...
Here, there are four fields that the user must set up before enabling the controller service:
Input name | Value |
|---|---|
Database Connection URL | Connection URI for the database. Example: jdbc:postgresql://host:port/database_name |
Database Driver Class Name | Database driver according to the database manager to use. |
Database Driver Location(s) | NiFi path where the database driver is located. |
Database User | Database user. |
Database Password | Database password. |
This fields are already set up for a postgresql database connection, in case there is a need to change the database instance, this fields may change accordingly.
...
Make sure that either the DBCPConnectionPool and JsonTreeReader controllers are enabled, otherwise there will be components with the warning icona the warning icon. Also make sure that the parameter context from https://psi.atlassian.net/wiki/spaces/ZMO/pages/edit-v2/583630850#3.-Create-context-parameters is configured for all the processes.
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 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).