Hello ODI Experts!
Quick question. We have an Oracle R12 Financials Database and we have ODI connected to it and it's pulling data across to our Financial Analystics database on a scheduled 4 hour turn around. It's working fine.
If we wanted to reduce the 4 hours down to a number as close to 0 as possible, i.e. nearly real-time, what's the best approach?
Is there any wizardry that could be done to make the ODI integration more pass-through real-time rather than batch? Perhaps using GoldenGate?
Many Thanks