Human Capital Management - EBS (MOSC)

MOSC Banner

Help Needed for using Oracle Data Integrator for real-time data integration

Hi All,

 

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center