Integration of data from secondary source to a third party application, implementation offers agent automation on the desktop. The technology runs on an IBM RS6000, with AIX version 4.1.4 and utilizes the Oracle 7.3.2 relational database engine.
Development of replication software developed in Microsoft Visual Basic 5.0, replicating data between the Oracle 7.3.2 engine and the data warehouse, Microsoft SQL Server. Replication runs on a Microsoft NT platform automatically on a nightly basis.
Development of reports in Microsoft Visual Basic 5.0, reporting data into Microsoft productivity tools (Excel and Access). Reports utilize ODBC as supported with Oracle Open Client and ODBC drivers.
Ready server for production providing processes for data backup and recovery, high availability design, architecture upgrade development, etc.