Created 10-20-2017 12:00 AM
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
Created 10-20-2017 04:51 AM
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?
Created 04-09-2020 01:29 PM
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