Load Ingest Data
Results 1 to 3 of 3
Like Tree1Likes
  • 1 Post By mikedba

Thread: Attunity / SQL Server 2012 & Oracle 12 support

  1. #1
    Tieme is offline Junior Member
    Join Date
    Jul 2015
    Posts
    2
    Rep Power
    0

    Attunity / SQL Server 2012 & Oracle 12 support

    Hi everybody,
    At a client we use Attunity CDC to capture changes in the source system. The reason is that my client's source database (Oracle 11) contains two tables that are too large to capture using "regular ETL". Hence we are developing a solution, which initially loads two tables, containing 25+ billions records each, to our data warehouse and afterwards captures the changes using CDC.
    We are using the next setup:
    - Source database: Oracle 11
    - Attunity Oracle CDC Designer 1.1.3000.0
    - Attunity Oracle CDC Service 1.1.3000.0
    - Destination database: Microsoft SQL Server 2012 11.0.5058
    - Windows Server 2012 R2 Version 6.3 Build 9600
    Like written, the clients database is Oracle 11. Next autumn they want to upgrade their system to Oracle 12. I have two questions:
    1. Is there anyone with experience between Attunity CDC and Oracle 12? In other words: Is Oracle 12 supported by Attunity CDC 1.1.3000.0?
    2. Has anyone ever experienced a database upgrade during their CDC runtime?
    Hope to hear from anyone soon!
    --
    Thank you in advance and kind regards,
    Tieme Pool

  2. #2
    javier.valvano is offline Junior Member
    Join Date
    Dec 2014
    Posts
    1
    Rep Power
    0

    Oracle 12 c with Attunity CDC for oracle

    Hi,

    a client's have implemented Attunity CDC for oracle 11g, and they want to migrate to oracle 12c. Is there any support for CDC Attunity with the Source: Oracle 12c?

    Kind regards.

    Javier.



  3. #3
    mikedba is offline Junior Member
    Join Date
    Nov 2014
    Posts
    8
    Rep Power
    0
    SQL Server will need to be upgrade to 2016 to support Oracle 12c as the source:
    https://msdn.microsoft.com/en-us/library/dn175418.aspx
    fajweb likes this.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •