CDC in Green Plum/Post gresql

Four Stars

CDC in Green Plum/Post gresql

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.

 

Moderator

Re: CDC in Green Plum/Post gresql

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.