We would like to transfer around 4 millions rows of data from Oracle Database to PostGreSQL using Oracle Database Integrator (ODI).
At the moment we have around 4 million rows on 600 columns (columns will potential increase in the future) in Oracle and when we transfer them in PostGreSQL it takes around 4 hours. For the transfer of the data we use JYTHON knowledge module in ODI.
4 hours is quite a long time and it is not an acceptable option for what we are doing. We would like someone to provide us with alternative options on how to move this amount of data, using ODI ONLY, from Oracle to PostgreSQL but with reduced time
Thank you