Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Nearly real time data integration from Informix to Oracle Database

762168Mar 23 2010 — edited Mar 23 2010

Hi every experts,

In my situation, I have an IBM Informix (IDS) running as a production database server. In the meantime, I have another oracle (10g) database running as the repository of the data from the informix server. My boss is requesting to have nearly real time data integration from the informix server to that oracle DB. I have searched for posts and known that there are some middleware like IBM InfoSphere DataStage, Oracle Data Integrator and Oracle Golden Gate can perform the ETL function.

I would like to know the above apps can work under heterogeneous systems??

And I'm so sorry I have no experience at data integration, normally, which side should the data integration app be placed?? Like my situation, should I put it at informix (production server) or oracle (data repository)?? Any performance issue or conern??

If I put the data integration app at Oracle side, say, using ODI, how it capture the data change at informix??'

Thanks for any reply, I really need some help...!!

Edited by: user12846361 on 2010/3/23 下午 7:23

Edited by: user12846361 on 2010/3/23 下午 7:25

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2010

Added on Mar 23 2010

#business-intelligence-applications, #data-integrator, #odi, #repository, #system-management-and-integration

0 comments

679 views