The transactional system runs on Oracle database. The analytic application runs on Postgres database. We need data from Oracle to Postgres every day with incremental change. It is not a complete database copy. It may also require to copy selective record from a particular table also. What is the best idea/ solution for this use case?
Hope it explained the busines use case. I am happy to explain details if you want. Thanks in advance!!