Is there a way to query the H2 Database in Apache NiFi ?
1 - i want to be able to list all Queues in a Process Group.
2 - i want to be able to associate Process Group/Processors with their IDs and Given names.
This way i can build a dynamic mechanism to better integrate and administer the NiFi work.
There's no specific processor for H2 DB but you can use it with standard JDBC processor in NiFi. You can use a Database Connection Pooling Service with JDBC driver forH2 DB and use processor like PutDatabaseRecord or any other JDBC processor to ingest data.
There are lot of questions/article on SQL processor in NiFi.
Have you tried this?