How to Read from H2 datanase in NiFi

[#1]

Hi,

Is there a way to query the H2 Database in Apache NiFi ?

Scope:

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.

Thx

[#2]

Hi @Adrian Oprea

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?

[#3]

You connect to H2 database like any other database using JDB connection. Here is the link where you can find H2 driver and documentation.

www.h2database.com/html/download.html

By the way, I have also uploaded a video explaining step by step process on connecting to NiFi H2 database. You may check it out here. 
https://www.youtube.com/watch?v=tsAR2f4uGK4