> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform
> data transformation and real time CDC from Oracle to PostgreSQL. Do
> we have any good open source tool to achieve this with No Coding
> involved.??
To meet all of your requirements, you are almost certainly going to need to look at a commercial solution such as:
* EDB's xDB.
* Oracle's Golden Gate.
* FiveTran's HVR.
We've used xDB successfully in the past for this type of migration.
One open-source change capture tool that you might investigate is:
https://www.symmetricds.org
I personally don't have experience with it, but it might be suitable.
Best,
-- Christophe