Support Questions
Find answers, ask questions, and share your expertise

Nifi PostgreSQL CDC

Rising Star

Hello,

QueryDatabaseTable processor provides to capture inserts. Is it possible to get updates and deletes without a trigger or postgresql solution?

Regards.

8 REPLIES 8

Hi @Mustafa Kemal MAYUK

There's a MySQL CDC processor in NiFi (CaptureChangeMySQL) but no native CDC solution for PostgreSQL currently. You can capture updates by using and updating a timestamp field together with QueryDatabaseTable. Delete are harder to get, you can use logical delete with delayed hard delete to let NiFi get them before. Another option is to use external CDC solution like Attunity.

I hope this helps

Rising Star

Thanks @Abdelkrim Hadjidj.

Do you mean software delete by logical deleting? (Not actually delete, update some fields)

Are there any native solution for mongodb or cassandra?

What do you think about using triggers? (writing insert,delete,update records to a table)

Regards.

Explorer

I’m finishing this component in nexts 3 weeks... is a processor fto NiFi.

Explorer

Here a link

CDC PostgreSQL

New Contributor

how can i use it

Explorer

Is there any news how to get this ?

Explorer

I can't login into Jira of apache. Is there any way for me to get it ?

Explorer

sorry? Does he provided the answer somewhere?

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.