We've got a Win2K CF server on a completely seperate network from the AS400,
with 2 firewalls and 200 miles inbetween them. We're using a product called
Ironside (www.ironside.com) which sits on the AS400 to listen for XML (in
Ironside's strange proprietary format) sent from the web server, then passes
parameters to existing back-office RPG programs, and returns the responses.
I construct and send the XML via a socket connection with a simple JavaCFX
tag I knocked up in a day or so.
Benefits of this -
- It uses the existing back-office logic for order processing
Drawbacks of this -
1) It uses the existing back-office logic! If your existing legacy programs
are not designed for randomly dipping into the database and retrieving a big
batch of data in one go, you're screwed!
Example: If I want to display a list of say 20 products, together with
available stock, then because of the way our legacy systems are designed, I
have to do two separate AS400 calls for each product. At up to 10 seconds
per transaction, that's over 400 seconds to display one page!
2) Price! Ironside costs about half a million.
I'm seriously thinking of writing an alternative in Java to sit on the
AS400. If anyone has any experience/hints/recurring nightmares of this, I'd
be VERY interested.....
Cheers,
Alistair Davidson
Senior CF Developer
Rocom
www.rocomx.net
-----Original Message-----
From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2001 09:09
To: CF-Talk
Subject: integrating ColdFusion with legacy AS400 data
anyone have any idea about integrating ColdFusion with legacy AS400 data?
I'm currently have a CF server sitting on a Sun Solaris, how can i configure
the CF server to access the legacy AS400 data? any idea?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
