Optivision DatawareHousing (ODH)

The client is a large paper company having mills in different parts of the country. ODH is a suite of three different applications Optivision Datawarehousing The challenge was to design and develop a system to fully automate the datawarehouse building process. Data is extracted from the Informix database from all the mills of the Paper Company located at different parts of US linked through a WAN. The extracted data is massaged to comply with the warehouse values and formats, to map the new columns, and also calculate values. This transformed data is loaded into a single database on SQL Server, which is maintained as a datawarehouse for the whole company. Data loading is scheduled for daily, weekly and monthly runs. The runs are scheduled in the Aswin scheduler to synchronize with the mills uploads. The process gets triggered through Aswin. As this is a real time system, the data has to be captured at predefined time frames to get the exact figures for Analysis. The system was developed in VB 4.0, SQL Server 6.0/6.5 on Windows NT, Aswin Scheduler - A Seagate Product