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 connect postgresql with nifi?

how to connect postgresql with nifi?

New Contributor

i using

hdp 2.5,

Apache NiFi - Version HDF-2.0.0.0-579

4 REPLIES 4

Re: how to connect postgresql with nifi?

@Narasimma varman

Use the PutSQL and ExecuteSQL processors. You can read more about them and their usage at the below link.

https://nifi.apache.org/docs.html

You can configure them as below:

15738-13448-putsql.jpg

Also, to get a better idea of how to chain the processors, take a look at the below article for an example flow that ingests data into a relational database using Nifi.

https://www.batchiq.com/database-ingest-with-nifi.html

As always, if you find this post helpful, don't forget to "accept" answer

Re: how to connect postgresql with nifi?

@Narasimma varman

Please share a snapshot of the ExecuteQuery processor "properties" tab and the SQL query you are running.

Re: how to connect postgresql with nifi?

New Contributor

I follow all steps that are mentioned in link but i got table not found error

15795-screenshot-from-2017-05-26-120559.png

Re: how to connect postgresql with nifi?

New Contributor

HI Narasimma varman ,

Above error comes when you have created schema and did not configured it in Database pool controller service ,can you please provide my snap shot of configuration.