Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to Read from H2 datanase in NiFi

How to Read from H2 datanase in NiFi

Contributor

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 REPLIES 2
Highlighted

Re: How to Read from H2 datanase in NiFi

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?

Highlighted

Re: How to Read from H2 datanase in NiFi

Explorer

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

Don't have an account?
Coming from Hortonworks? Activate your account here