CDC in Green Plum/Post gresql

Anonymous — Wed, 04 Apr 2018 11:24:17 GMT

Hi,

We are successfully did CDC with tOracleCDC component on Oracle data base. We are trying to implement CDC on green plum Database. This time we are using tPostgresqlCDC component.

We followed same instructions like how we did in Oracle side. But in we are facing issue while implementing CDC on Green Plum Side.

All the set up we did it. -- There is no issue at this point.

To test this we are inserting data into source table. here we are facing the below mentioned error.

---------

SQL Error [XX000]: ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg26 avw7gpdbsdwq4.gphd.local:1027 pid=545831) (cdbdisp.c:1322)
Detail:
SQL statement "INSERT INTO "geagp_xplore"."TCDC_customersgp1" ( "TALEND_CDC_SUBSCRIBERS_NAME", "TALEND_CDC_STATE", "TALEND_CDC_TYPE", "TALEND_CDC_CREATION_DATE", "cust_id" ) SELECT "TALEND_CDC_SUBSCRIBER_NAME", '0', 'I', CURRENT_TIMESTAMP, $1 FROM "geagp_xplore"."TSUBSCRIBERS" WHERE "TALEND_CDC_TABLE_TO_WATCH"='geagp_xplore.customersgp1'"
PL/pgSQL function "customersgp1_record_i" line 2 at SQL statement

Is it possible to to implement CDC for green plum by using tPostgresqlcdc component. Can you please help me on this issue.

Re: CDC in Green Plum/Post gresql

Anonymous — Fri, 04 May 2018 05:02:50 GMT

Hello,

Postgres components are not 100% compatible with Greenplum.

Currently, there is no a Greenplum CDC component.

Please have a look at this online document about:TalendHelpCenter: Database support for CDC.

Best regards

Sabrina

topic Re: CDC in Green Plum/Post gresql in Talend Studio

CDC in Green Plum/Post gresql

Re: CDC in Green Plum/Post gresql