Since we can not enable CDC on Oracle database, is there any PL/SQL procedure we can write to get the changed records on daily basis? So that I can automate this script to my ADF pipeline to get the change data on daily basis. Please help?
Change data capture (cdc) for Oracle edw
95 views Asked by RK. At
2
There are 2 answers
0
On
You may have a look at MOVEX CDC. https://gitlab.com/otto-group-solution-provider/movex-cdc
It is a standalone solution for CDC from Oracle-DB to Kafka.
From my past experience I can tell you that doing it in manual/DIY way is very cumbersome.
Although there are Debezium connectors written for the same task as far as Oracle is concerned:
https://debezium.io/documentation/reference/stable/connectors/oracle.html
I have not tested it's feasibility for Oracle db per say. Debezium setup works wonderfully for MS SQL server database.
Although this do not answer your question directly. This will serve you good as a good starting path for your research.
Hope this helps. Thanks.