topic CDC components with Microsoft SQL server replication in Talend Studio

CDC components with Microsoft SQL server replication

danped — Fri, 28 Nov 2014 21:29:54 GMT

Hi,
I'm looking into talend as our choice of ETL tool. we have recently implemented a new source system which is an MSSQL 2012 database which has a replicated database for reporting. I'm looking to extract that data into our corporate datawarehouse.
I can only assume that replication on MSSql works in a similar way to turning on CDC on databases and tables. If this is the case are talends cdc connectors effective in connecting to a replicated data source?
Thanks,
Dan

Re: CDC components with Microsoft SQL server replication

Anonymous — Sat, 29 Nov 2014 13:35:51 GMT

Hi,
Are you catching changed data in your replication DB? Have you already checked document about: TalendHelpCenter:Change Data Capture (CDC)?
Best regards
Sabrina

Re: CDC components with Microsoft SQL server replication

danped — Sat, 29 Nov 2014 17:08:48 GMT

Thanks - I'll check the talend documentation. On the capturing of changed data, my question is whether or not having replication on a database in MsSQL is sufficient for the talent connector to pick up changes - I'm conficent it will work if CDC is turned on on the replicated database.
Dan

Re: CDC components with Microsoft SQL server replication

Anonymous — Sun, 30 Nov 2014 15:33:01 GMT

Hi,
What's your target DB? Is your replication DB working well in real time?(as the same feature with source DB)?
Have you already checked document: TalendHelpCenteratabase support for CDC?
Best regards
Sabrina

Re: CDC components with Microsoft SQL server replication

danped — Fri, 05 Dec 2014 21:58:02 GMT

Thanks - I'll read that.
Dan

Re: CDC components with Microsoft SQL server replication

Anonymous — Wed, 10 Dec 2014 06:22:58 GMT

Hi Dan,
Any update for your issue? Can we consider your topic as resolved?
Best regards
Sabrina