Hi every expert,
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 on 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 side??'
Thanks for any reply, I really need some help...!!