Re: Informix Export Capabilities

Jeff Crist wrote: > > I know little about Informix but want to access a subset of an Informix > database from a web application. We are currently using MS Access and > ORACLE as back-end databases to our Web site. The Informix database is > unfortunately inside our firewall. > > How hard would it be to export some of the fields in an Informix database > to an MS Access or ORACLE database? Is it possible to automate this > process so it does it automatically once each day? The best way I can think of is to write a SQL script that extracts the data from the columns you want into an ASCII file or a pipe and then take that data into Oracle or Access. Most of these could be automated by cron. This is not true export/import as defined by either Informix or Oracle because the data is going across a heterogeneous database environment, but should work. You may also find some third party tools (or even gateways from Informix and Oracle) that can provide more features, but the above is probably the most inexpensive method. Arun