[ 
https://issues.apache.org/jira/browse/NIFI-7533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17138184#comment-17138184
 ] 

Firenz commented on NIFI-7533:
------------------------------

CDC for MySQL and PostgreSQL are two distinct "technologies" and require 
differents efforts. Si there is no Postgres CDC "out of the nifi box".

 
 * A simple CDC for Postgres : use Postgres Logical Replication with 
publish/suscribe + JSON format to output in local/nfs. GetFiles with nifi and 
parse. 
 * Alternative : use Postgres Logical Replication  + KafkaConnect + Kafka.

Of course it depends of lot of things (OnPrem Postgres, OS access, network 
typo, perfs...).

 

> Urgent requirement for cdc for Postgres
> ---------------------------------------
>
>                 Key: NIFI-7533
>                 URL: https://issues.apache.org/jira/browse/NIFI-7533
>             Project: Apache NiFi
>          Issue Type: Wish
>            Reporter: Vivek
>            Priority: Major
>
> Hi Team, I can see the cdc for mysql in Nifi & was successfully able to use 
> it but now I need to use cdc with Postgres. Can someone suggest if this is 
> possible in Nifi.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to