CDC vs ER
User asked about replicating Informix data to Oracle and Informix using CDC, seeking performance comparisons with ER (Enterprise Replication). Responders noted ER is considerably faster, requires no external agents, has lower administrative overhead, supports more data types, and is free. CDC is expensive (per-processor licensing), reliable but network-sensitive and difficult over WAN.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, our customer wants replicate data to oracle and informix server. For oracle wants use CDC and for informix too. Do you have somebody experience with replication over CDC ? 1.informix to oracle and other database system 2.informix to informix. I'm interested also to compare performance between CDC and ER thanks Petr
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } ER would be considerably faster. It does not require data movement between the capture agent and the source nor between the apply agent and the target. Also ER bypasses most of the SQL layer of the DBMS, CDC can not do that. Sent from Yahoo Mail for iPad On Tuesday, October 25, 2016, 3:29 AM, Petr Pomykacek <Petr.Pomykacek@pomyk.cz> wrote: Hi, our customer wants replicate data to oracle and informix server. For oracle wants use CDC and for informix too. Do you have somebody experience with replication over CDC ? 1.informix to oracle and other database system 2.informix to informix. I'm interested also to compare performance between CDC and ER thanks Petr ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
I should mention also, since ER does not require any external agents, ER does not require nearly as much startup/shutdown coordination between the agents and the server. That means there is much less administrative requirements. Madison Pruet Retired and Loving it On Tuesday, October 25, 2016 9:27 AM, Madison Pruet <madison_pruet@yahoo.com> wrote: #yiv9506860300 blockquote, #yiv9506860300 div.yiv9506860300yahoo_quoted {margin-left:0 !important;border-left:1px #715FFA solid !important;padding-left:1ex !important;background-color:white;} ER would be considerably faster. It does not require data movement between the capture agent and the source nor between the apply agent and the target. Also ER bypasses most of the SQL layer of the DBMS, CDC can not do that. Sent from Yahoo Mail for iPad On Tuesday, October 25, 2016, 3:29 AM, Petr Pomykacek <Petr.Pomykacek@pomyk.cz> wrote: Hi, our customer wants replicate data to oracle and informix server. For oracle wants use CDC and for informix too. Do you have somebody experience with replication over CDC ? 1.informix to oracle and other database system 2.informix to informix. I'm interested also to compare performance between CDC and ER thanks Petr ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Plus fewer restrictions wrt. data types supported .... From: "Madison Pruet" <madison=5Fpruet@yahoo.com> To: ids@iiug.org Date: 25.10.2016 16:55 Subject: Re: CDC vs ER [38039] Sent by: ids-bounces@iiug.org I should mention also, since ER does not require any external agents, ER=20 does=20 not require nearly as much startup/shutdown coordination between the=20 agents=20 and the server. That means there is much less administrative requirements. = Madison Pruet=20 Retired and Loving it=20 On Tuesday, October 25, 2016 9:27 AM, Madison Pruet=20 <madison=5Fpruet@yahoo.com>=20 wrote:=20 #yiv9506860300 blockquote, #yiv9506860300 div.yiv9506860300yahoo=5Fquoted=20 {margin-left:0 !important;border-left:1px #715FFA solid=20 !important;padding-left:1ex !important;background-color:white;} ER would=20 be=20 considerably faster. It does not require data movement between the capture = agent and the source nor between the apply agent and the target. Also ER=20 bypasses most of the SQL layer of the DBMS, CDC can not do that.=20 Sent from Yahoo Mail for iPad=20 On Tuesday, October 25, 2016, 3:29 AM, Petr Pomykacek=20 <Petr.Pomykacek@pomyk.cz> wrote:=20 Hi,=20 our customer wants replicate data to oracle and informix server.=20 For oracle wants use CDC and for informix too.=20 Do you have somebody experience with replication over CDC ?=20 1.informix to oracle and other database system=20 2.informix to informix.=20 I'm interested also to compare performance between CDC and ER=20 thanks=20 Petr=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20
The other thing to consider is cost. CDC is expensive. You pay per processor for both source and target while ER is 'free'. I am currently running CDC from IDS 11.7 on Red Hat to SQLServer. It is quite reliable and efficient but not very resilient. I have found it very sensitive to network glitches and almost impossible over a WAN. Keith On 25 October 2016, at 16:11, Andreas Legner <andreas.legner@de.ibm.com> wrote: Plus fewer restrictions wrt. data types supported .... From: "Madison Pruet" <madison=5Fpruet@yahoo.com> To: ids@iiug.org Date: 25.10.2016 16:55 Subject: Re: CDC vs ER [38039] Sent by: ids-bounces@iiug.org I should mention also, since ER does not require any external agents, ER=20 does=20 not require nearly as much startup/shutdown coordination between the=20 agents=20 and the server. That means there is much less administrative requirements. = Madison Pruet=20 Retired and Loving it=20 On Tuesday, October 25, 2016 9:27 AM, Madison Pruet=20 <madison=5Fpruet@yahoo.com>=20 wrote:=20 #yiv9506860300 blockquote, #yiv9506860300 div.yiv9506860300yahoo=5Fquoted=20 {margin-left:0 !important;border-left:1px #715FFA solid=20 !important;padding-left:1ex !important;background-color:white;} ER would=20 be=20 considerably faster. It does not require data movement between the capture = agent and the source nor between the apply agent and the target. Also ER=20 bypasses most of the SQL layer of the DBMS, CDC can not do that.=20 Sent from Yahoo Mail for iPad=20 On Tuesday, October 25, 2016, 3:29 AM, Petr Pomykacek=20 <Petr.Pomykacek@pomyk.cz> wrote:=20 Hi,=20 our customer wants replicate data to oracle and informix server.=20 For oracle wants use CDC and for informix too.=20 Do you have somebody experience with replication over CDC ?=20 1.informix to oracle and other database system=20 2.informix to informix.=20 I'm interested also to compare performance between CDC and ER=20 thanks=20 Petr=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Gentleman, Thanks for yours answers. Petr Dne 26.10.2016 v 00:45 Keith Simmons napsal(a): > The other thing to consider is cost. CDC is expensive. You pay per processor > for both source and target while ER is 'free'. > I am currently running CDC from IDS 11.7 on Red Hat to SQLServer. It is quite > reliable and efficient but not very resilient. I have found it very sensitive > to network glitches and almost impossible over a WAN. > Keith > > On 25 October 2016, at 16:11, Andreas Legner <andreas.legner@de.ibm.com> > wrote: > > Plus fewer restrictions wrt. data types supported .... > > From: "Madison Pruet" <madison=5Fpruet@yahoo.com> > To: ids@iiug.org > Date: 25.10.2016 16:55 > Subject: Re: CDC vs ER [38039] > Sent by: ids-bounces@iiug.org > > I should mention also, since ER does not require any external agents, ER=20 > does=20 > not require nearly as much startup/shutdown coordination between the=20 > agents=20 > and the server. That means there is much less administrative requirements. = > > Madison Pruet=20 > Retired and Loving it=20 > > On Tuesday, October 25, 2016 9:27 AM, Madison Pruet=20 > <madison=5Fpruet@yahoo.com>=20 > wrote:=20 > > #yiv9506860300 blockquote, #yiv9506860300 div.yiv9506860300yahoo=5Fquoted=20 > {margin-left:0 !important;border-left:1px #715FFA solid=20 > !important;padding-left:1ex !important;background-color:white;} ER would=20 > be=20 > considerably faster. It does not require data movement between the capture = > > agent and the source nor between the apply agent and the target. Also ER=20 > bypasses most of the SQL layer of the DBMS, CDC can not do that.=20 > > Sent from Yahoo Mail for iPad=20 > > On Tuesday, October 25, 2016, 3:29 AM, Petr Pomykacek=20 > <Petr.Pomykacek@pomyk.cz> wrote:=20 > Hi,=20 > > our customer wants replicate data to oracle and informix server.=20 > For oracle wants use CDC and for informix too.=20 > Do you have somebody experience with replication over CDC ?=20 > 1.informix to oracle and other database system=20 > 2.informix to informix.=20 > I'm interested also to compare performance between CDC and ER=20 > > thanks=20 > > Petr=20 > > ***************************************************************************= > ****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > ***************************************************************************= > ****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >