Re: Export Data automatically from Informix DB to Oracle DB

From: "Manfred Tischendorf" <tischendorf@arkusa.de> >Hello experts, And me! And me! >I have the requirements to import relational data stored in an informix >database into an Oracle database. Unfortunately this is not a one time move >of the data. I have to mirror data every 24h in one case. In the other case >the actualisation should be done every 60-120 seconds. >What input (platform, versions) is important to find a solution? >I know, that the Informix DB is on a unix platform. If it makes sense, I >can >get a mirrored Informix DB on NT (would be slow, how to synchronize the >mirroring and the loading into Oracle). The Oracle DB (probably 8.0.4, may >be 7.3.4 for the fist few months) is running on NT. > >Which possibilities are there to solve these requirements? >1.) One solution could be to execute Informix utilities, write flat files >and improt these data using SQL-Loader. >2.) Another idea is to mirror the Informix DB to an Informix on NT and then >using ODBC (I wonder if there is an > ODBC-Interface for HP-UX. I know there is one for Linux but I never >used >it before) >3.) What about Gateway tools. Is there one for accessing Informix? > >Which solution would be the fastest? And what about the costs for the >customer. > >Do you have any suggestion how I can get an overview to possible solutions? >And which solution would you prefer? > >Thanks for any advice. Do you answer per email? If not, because this topic >could be interesting for other members also, please email me where I will >find your answer (additional information). Both Informix and Oracle have gateways. In addition, Informix 9.2x has something called a Virtual Table Interface, which, I understand, allows you to build an Informix mask over Oracle tables and access them as though they were part of the Informix database. There is also something called Praxis OmniReplicator that will do this. Or you can write something with DataStage and lots of bit of string and sealing wax. It's going to be expensive, either in terms of licenses, man hours or both. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com