And as far as I know OGG does not support Pervasive DB (correct me if I'm wrong).
What version do you use?
Have you considered using Oracle Heterogeneous Services for accessing Pervasive via database links?
Do you plan to use Pervasive DB as a source or as a target?
I am using the latest version of Golden Gate. The Pervasive DB would be the target. Would the Oracle Heterogeneous Services for accessing Pervasive via database links be a better option?
1 person found this helpful
It depends no your replication routine. If you plan to replicate data on online basis (with real-time capture) from Oracle to Pervasive, plus if you have licensed OGG, then you could use User Exit that writes data to flat files and develop a daemon that monitors these files and updates/uploads data to Pervasive DB.
If you just need to have your Oracle data in Pervasive DB say by the end of a day, you could use Heterogeneous Services to connect from Oracle to Pervasive and to update/upload data via DB link.