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)
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.
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.