Re: Connecting Informix / Oracle for data movement -- repost

John, It's funny that I read your article because we have just written in a (30 hour period - no sleep) a C++ application accessing ODBC to transfer data. Basically the program comes up and allows you to select the 'source' ODBC driver and the 'destination' ODBC driver. It then allows you to enter the 'Number of Threads' and the '# of Blocked Rows'. It will read all tables and let you select or all. The application will create ~20 threads inserting at 'blocked' fetches of 10-1000 rows....meaning we are getting inserts of 1000-2000 rows per second. This was done from SQL Server into Informix 7.1! We have not gotten the performance yet into Sybase but you get the picture! Because of ODBC it will work with any database! You could do the same... :) David J. Meyer Guerilla Software dmeyer9@ix.netcom.com In article <34D79CDD.5625@bellsouth.net>, carlson1@bellsouth.net wrote: > I didn't receive many replies, so I don't know if it is (relatively) > easily possible. Thought I'd repost just to make sure. > > .. begin repost .. > > I've perused the IIUG archives and dejanews also. Still have some > questions. > > We're in the midst of negotiations with a retail software company to > install a new POS system in our stores. Data will be polled from > the individual stores and reside in the Oracle data warehouse, here > in the home office. Here's the challenge. > > There will be pieces of data that would be polled that need to > migrate into our Informix financial systems. Likewise, certain > information would need to migrate to the Oracle system as it is > updated in the Informix financial system. We're looking for a > seamless solution for the data migration issues. > > We've heard the offerings from Oracle, but there's a certain > learning curve associated with that. > > I've looked at the Informix Enterprise Gateway Manager. It looks > pretty good, especially being able to access Oracle through > DBAccess, 4GL, etc. Any other possibilities? While I have a good > feel for things of the Informix nature, these new concepts > (providing connections between two dissimiliar databases, ODBC, > etc.) are a bit boggling. Any help or direction will be greatly > appreciated. > > .. end repost .. > > Another question would be . . . > Is a straight ODBC connection between the two databases (different > boxes) be enough? Please remember that I'm new to this "database > connectivity". We're under a certain amount of pressure from our > warehousing software sales persons to use ASCII files to transfer > information between the systems. (Of course, they would be the ones to > write the Oracle piece. <G> ) Somehow, there must be a better way, even > though it may be a bit more expensive. > > Thanks again! > > John Carlson > Informix DBA > WH Smith, Inc. > > > Thanks in advance, > > John Carlson > Informix DBA > WH Smith, Inc.