Discussion Locked

Connecting AS400 to the web front end.

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Has anyone connected legacy AS400 databases on the backend to Unix/Linux & Apache web servers on the front end for the web? We have two sets of web servers, one being an AS400 for dynamic look ups and the other being the Apache box. I want to intergrate them more and pull data from the AS400 to the Unix box and update information as well. I'm fairly certain this can be done and just want to know which works best and which does not. Will PHP, ASP, XML, SQL and various others work in doing this? Any success stories and tips will help, I'm closing the gap between our front end design and backend design teams.

Thank you,

Rob

3 replies

by jay eckles

I've been a system tester on one project that connected a DB2 database running on an AS400 (I think that's right) with a web front-end by using IBM's DB2Connect to access the database through Java Beans.

As far as will PHP, ASP, XML, SQL work in doing this, well that sort of depends. Any server-side programming language will work if you have a way to access the database with it; if you have a driver that can bridge to the db on the AS400 and perhaps emulate ODBC or something standard like that, then you're golden. I'd be surprised if you found anything out-of-the-box that worked for PHP or ASP. As far as XML goes, it might be useful in doing something like modelling data retrieved from the db on the AS400 and transmitting it to the Unix box, then using XSL or CSS to convert it to HTML. SQL will only help if the database on the AS400 can be queried using SQL.

All of this assumes you're looking to do real time queries and updates; I think in the past batch processes have been a common solution. You update the client/server database with data from the AS400 once a day, and at the end of each day you update the AS400 database with all the transactions that happened on the client/server system.

Again, my only advice is to look to the vendor of your legacy database and see if they don't have a product like DB2Connect for DB2 that bridges the gap between legacy and client/server for you.

Good luck.

Jay Eckles
www.jayeckles.com

This discussion is closed to new replies.