0

I need to capture PostgreSQL changes and I would prefer if it is log based.

How does tpostgresqlCDC work? Is it log/trigger based?

Is this component available on Talend open studio for data integration suit? I know it is available on the big data version, but I can seem to find it in Talend open studio for data integration?

Al Sweigart
  • 11,566
  • 10
  • 64
  • 92
rachid el kedmiri
  • 2,376
  • 2
  • 18
  • 40
  • Did you try https://help.talend.com//pages/viewpage.action?pageId=272769191#Raa37041 ? All CDC components are only available in licenced products, and not in Open Studio edition. – Corentin Apr 11 '17 at 13:19
  • Thanks Corentin for getting back at me, the issue is that Talend implements CDC by using triggers, which add an estimate of 8% overhead.giving the age of the Talend project, does anyone found a work around this problem. – rachid el kedmiri Apr 11 '17 at 18:16

1 Answers1

2

Except AS400 and Oracle, all Talend CDC - trigger based plus:

  • it only in subscription version
  • at least in MySQL realisations - I found some wrong logic

opposite to MySQL it not so wide available, but You can try to check:

  1. Bottledwater
  2. wla2jjson
  3. Debezium , main site

CDC + Kafka - give real flexibility

a_vlad
  • 261
  • 3
  • 8