Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A new window will open. Click on the controller services tab:

...

(create service link)

...

Here, two controller services will be disabled: DBCPConnectionPool and JsonTreeReader. The JsonTreeReader does not require any additional configuration so it can be enabled right away. The DBPCConnectionPool does require some fields to be updated so before enabling, click on the configuration button for this controller service:

...

And then open click on the properties tab:

...

Here, there are four fields that the user must set up before enabling the controller service:

  • Database Connection URL.

  • Database Driver Class Name.

  • Database Driver Location(s).

  • Database User.

  • 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.

Also, it is important to have a look on the field called Database Driver Location(s), this field allows NiFi to search for a .jar file that is required for the database connection to work. This driver does not come with the NiFi instance, so the file is required to be downloaded and placed in the location defined.

Note

Database connections made via SSH are not supported.

Once the fields are already set up, click on Apply button at the right bottom of the window and now the controller service can enabled:

...

When clicking on the enable button, a new window will show listing all the components using this controller service. Every component will have a warning icon, once the service is enabled, all the listing components will have a stoped icon referencing that the service is now available for the components:

...

Make sure that either the DBCPConnectionPool and JsonTreeReader controllers are enabled, otherwise there will be components with the warning icon.