Oracle CDC...

Sunday, December 04, 2011 12:23 PM

0

Hello, all. I've read that SQL 2012/SSIS will have support for Oracle CDC (Change Data Capture). Was wondering if anyone can point me in the right direction on setting up this up, or provide an example.

Thanks.
Roz

All Replies

Thursday, December 08, 2011 9:23 PM

0

Hello,

I did not see anything built in in SSIS 2012 regarding Oracle CDC, but here is Attunity Oracle-CDS for SSIS.

http://www.attunity.com/oracle_cdc_for_ssis

Looking forward for more details!

Thanks

Aamir
http://sqlage.blogspot.com/
Tuesday, December 27, 2011 10:19 AM

0
HOPE THIS WILL HELP -

http://www.mattmasson.com/index.php/2011/12/cdc-in-ssis-for-sql-server-2012-2/?utm_source=rss&utm_medium=rss&utm_campaign=cdc-in-ssis-for-sql-server-2012-2
- Proposed As Answer by Jason H - SQLMicrosoft Employee Friday, January 27, 2012 5:59 AM
Tuesday, January 31, 2012 2:13 AM

0

If you want to beta test it, the .iso DVD image file for SQL Server 2012 Release Candidate 0 has the two setup files which you can run to get the Attunity Oracle CDC service.

Download the .html from here, and it will tell you how to get the .iso for the beta trial edition. http://www.microsoft.com/download/en/details.aspx?id=28145

Or get the RC0 iso download here using the ISO download menu: http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/

I haven't unzipped mine yet, but I think the msi is in a subfolder like these examples:

D:\Tools\AttunityCDCOracle\x64\1033\AttunityOracleCdcDesigner.msi
D:\Tools\AttunityCDCOracle\x64\1033\AttunityOracleCdcService.msi

D:\Tools\AttunityCDCOracle\x86\1033\AttunityOracleCdcDesigner.msi
D:\Tools\AttunityCDCOracle\x86\1033\AttunityOracleCdcService.msi

Thanks, Jason
Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
Tuesday, February 21, 2012 6:48 PM

0

I started a wiki page for other folks who may run across this thread.

http://social.technet.microsoft.com/wiki/contents/articles/7644.microsoft-sql-server-2012-change-data-capture-for-oracle-by-attunity-topics.aspx
Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance