Database repository nifi

[#1]

Hello everyone,

I am wondering about the database repository. I'm not getting its use case. There are 4 files but I haven't found articles explaining how can we use them.

Is it an audit basis? If yes how can we use them else how can we audit nifi?

Thanks

[#2]

@nesrine salmene

The Database repository consists of two H@ databases:

1. nifi-user-keys.h2.db
2. nifi-flow-audit.h2.db

When NiFi is running you will see two additional lock files that correspond to these databases.

• The nifi-user-keys.h2.db is only used when NiFi has been secured and it contains information about who has logged in to NiFi. The same information here is also output to the nifi-user.log. You can parse the nifi-user.log to audit who has logged in to a particular NiFi instance.
• The nifi-flow-audit.h2.db is used by NiFi to keep track of all configuration changes made within the NiFi UI. The information contained in this DB is viewable via the "Flow Configuration History" embedded UI found under the Upper right corner hamburger menu in NiFi's UI:
  

  
  You can use NiFi's rest API to query the Flow Configuration History.

Thanks,

Matt