At work we run on system-i with a DB2 database and a highly custom application for our order entry program. That program is all green screen/telnet used by our c.s. staff - which actually is fast when you get used to it. Written in RPG/CL.
We want to redo our online shopping cart which runs on an antiquated, heavy, slow, custom web server(Strategi) that talks w/ RPG to bring our order system to the www. We have Zend Server for IBM-i installed parsing PHP applications but my question is: Are we better off building a shopping cart ground up or is there benefit in a Open Source package and marrying it to our system?
My concern with open source is the time it would take to get the two talking but at the same time getting a shop up from scratch seems just as time consuming and you lose all the benefits of testing, security, etc...
Does anyone have any thoughts or experience putting an open source app. on an existing DB similar to this situation? We've put SUGAR on a windows box and used Pentaho with a JDBC driver to get that Open Source app. talking w/ our DB2 but that is day old data replicated in a nightly run. This would have to be real-time transactions against inventory qty's.
I appreciate any insight..