Help Needed for using Oracle Data Integrator for real-time data integration
We are looking for key suggestions for requirement on setting up real-time data integration between Oracle 10g database ( HRMS suite – R12.0.6 ) and SQL server database on external system. The requirement is about having seamless integration between both the systems in such a way that the identified changes happening in Oracle database are captured and transferred to external system in real-time manner. This is a typical E-TL (Extract – Transform – Load) scenario where both systems should have proper handshaking.
We were evaluating the option of using Oracle Data Integrator (ODI) for this requirement. We don’t want to use ODI with Change Data capture (CDC) just to avoid creating a staging database for using CDC in asynchronous manner, and involves DBA monitoring. We don’t have any fusion middleware setup at this point as well as we are not looking for any TIBCO ( or equivalent) setup for integration.