Re: Export Data automatically from Informix DB to Oracle DB
DataStage? Informix Gateway Manager? From: Marat <maratkotik@mail.ru> > >See www.peerdirect.com >May by it would be used > >Imran Hussain wrote: > > > Try WinSQL Professional at http://www.indus-soft.com/winsql > > > > Patrick Dwyer wrote: > > > > > Informix DataStage will read from Informix and Write to Oracle. > > > It is a DataWarehousing ETL (extract,transform and load tool). The > > > product was designed by a company called Ardent. It's a GUI and > > > is reasonably easy to use. It's sure as heck will be easier than >coding > > > this fine process. > > > > > > Paddy > > > > > > Manfred Tischendorf wrote: > > > > > > > Hello experts, > > > > > > > > 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). > > > > > > > > Manfred Tischendorf > > > > > > > > --------------------------------------- > > > > /\\ > > > > / a\\ Manfred Tischendorf > > > > / s \\ > > > > / u \\ Tunnelstrasse 14 > > > > / k \\ D 70469 Stuttgart-Feuerbach > > > > / r \\ Deutschland / Germany > > > > \\a / > > > > \\ / Tel.: +49 711 81781-56 > > > > \\ / Fax: +49 711 81781-51 > > > > \\____/ E-Mail: tischendorf@arkusa.de > > > > \\ / WWW: http://www.arkusa.de/ > > > > \\/ > > > > --------------------------------------- > > > > -- > > ===================================================================== > > Imran Hussain > > imranh@imranweb.com > > > > For FREE Software visit > > http://www.imranweb.com/freesoft > > ===================================================================== > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com