Online Order Processing System (OOPS)

OOPS was developed for a large phone company. Webject designed, developed, implemented and extended production support for OOPS. The solution involved conceptualization, application development, data migration, reports and querying modules. OOPS V1.0 is a client /server application using Visual Basic 5.0 and Oracle 8.0.3 OOPS V2.0 is an Internet application for the Order Entry and Processing. The front end of OOPS is a Web Browser. The WebPages are developed using Microsoft Active Server Pages, Java Script, VB script and HTML. The business logic was implemented with embedded Active X controls. PL/SQL is used for coding the server logic using the stored procedures in Oracle 8.0.4 on Windows NT Server 4.0. SyncDaemon The challenge was to fully automate the process of Import and Export of data from Oracle8.0.3 on NT server to DB2 database on AS/400 and vice versa. The process is triggered using NT scheduler every night for Export and every morning for Import. This process creates a snapshot at periodic intervals and refreshes the data on the oracle server keeping it in sync with the main DB2 database