Oninit cdi / Archive
Talk to an expert →

CDC between IDS 11.5 & MS-SQL

Posted in 2011

Topics: General Discussion

Jonathan Smaby — — source: IIUG Forums & Mailing Lists

Just a follow-up question to the one I asked last week. Has anyone successfully integrated IDS 11.5 with Microsoft SQL server with replication via Change Data Capture (CDC) feature? If so, were the two database environments able to connect/replicate with a 3rd party product? Or did you need something like Infosphere or something as a go-between with IDS and MSSQL? Thanks in advance for any insight. Sincerely, Jonathan B. Smaby<http://www.facebook.com/photo.php?pid=392289&l=a2b304ccd3&id=1000008613412 48> Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu http://www.uscgamdr.org/classes http://wwww.facebook.com/JonathanSmaby -- Semper Paratus! "Always Ready!" [cid:image001.jpg@01CBBBE8.29999950] ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.

↪ replying to Jonathan Smaby
Madison Pruet — — source: IIUG Forums & Mailing Lists

IBM data mirror From: "Jonathan Smaby" <Jonathan.Smaby@pomona.edu> To: ids@iiug.org Date: 01/24/2011 07:01 PM Subject: CDC between IDS 11.5 & MS-SQL [22553] Sent by: ids-bounces@iiug.org Just a follow-up question to the one I asked last week. Has anyone successfully integrated IDS 11.5 with Microsoft SQL server with replication via Change Data Capture (CDC) feature? If so, were the two database environments able to connect/replicate with a 3rd party product? Or did you need something like Infosphere or something as a go-between with IDS and MSSQL? Thanks in advance for any insight. Sincerely, Jonathan B. Smaby< http://www.facebook.com/photo.php?pid=392289&l=a2b304ccd3&id=100000861341248 > Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu http://www.uscgamdr.org/classes http://wwww.facebook.com/JonathanSmaby -- Semper Paratus! "Always Ready!" [cid:image001.jpg@01CBBBE8.29999950] ------------------------------------------------------------- This message has been scanned by Postini anti-virus software. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Jonathan Smaby
Richard Snoke — — source: IIUG Forums & Mailing Lists

I've seen it done although I did not personally set it up. CDC (IBM's product name for the former DataMirror product) requires nothing more. CDC has interfaces to the DBMS's to read the transaction logs on each source system and uses standard SQL to insert, update or delete on the target systems. Cheers, Dick Snoke IBM ChannelWorks dsnoke@us.ibm.com (404) 487-1595 From: "Jonathan Smaby" <Jonathan.Smaby@pomona.edu> To: ids@iiug.org Date: 01/24/2011 08:01 PM Subject: CDC between IDS 11.5 & MS-SQL [22553] Sent by: ids-bounces@iiug.org Just a follow-up question to the one I asked last week. Has anyone successfully integrated IDS 11.5 with Microsoft SQL server with replication via Change Data Capture (CDC) feature? If so, were the two database environments able to connect/replicate with a 3rd party product? Or did you need something like Infosphere or something as a go-between with IDS and MSSQL? Thanks in advance for any insight. Sincerely, Jonathan B. Smaby< http://www.facebook.com/photo.php?pid=392289&l=a2b304ccd3&id=100000861341248 > Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu http://www.uscgamdr.org/classes http://wwww.facebook.com/JonathanSmaby -- Semper Paratus! "Always Ready!" [cid:image001.jpg@01CBBBE8.29999950] ------------------------------------------------------------- This message has been scanned by Postini anti-virus software. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary