Load Ingest Data
Results 1 to 3 of 3

Thread: Performing CDC using Views as Source for Oracle/Non-Oracle Databases

  1. #1
    akanksha.1787 is offline Junior Member
    Join Date
    Nov 2016
    Posts
    22
    Rep Power
    0

    Performing CDC using Views as Source for Oracle/Non-Oracle Databases

    Hi Experts,

    We have a requirement in our project, where we have to replicate data by using Views as Source for Oracle Database.

    When we create a source endpoint using 'Oracle' type we could not see the views.
    We later realized that to access views, the connection needs to be created using the ODBC for oracle and ODBC with CDC for other databases with no transactional logs.

    Could you let us know the process if there is any to perform CDC on views instead of tables.

    Your response would be highly appreciated.

    Regards,
    Akanksha

  2. #2
    Hein is offline Senior Member
    Join Date
    Dec 2007
    Location
    Nashua, NH - USA.
    Posts
    161
    Rep Power
    12

    Replicate supports views for Oracle sources for full-load only when enabled.

    Replicate supports views for Oracle for full-load when enabled.
    To enable this, use the 'advanced' tab on the endpoint to set the internal parameter :

    • exposeViews=true


    Please note that the CDC will be based on base-table changes only.
    That's just the nature of the beast.
    Replicate obtains change data from the redo (and archive) logs.
    Oracle only records those for the base table

    Hope this helps,
    Hein.



  3. #3
    akanksha.1787 is offline Junior Member
    Join Date
    Nov 2016
    Posts
    22
    Rep Power
    0
    Hi Hein,

    Thank you for your response.
    I was able to set the internal parameter as you suggested.
    I will respond back if I am able to see the views with all grants in place for the user.

    Thanks & Regards,
    Akanksha Bassin

Posting Permissions

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