OGL Software & Sales Vision Stock Data Analysis

Abacus Creative Resources use a Software System called OGL which has ODBC & uses Pivot Tables to analyse data such as stock patterns & trends. We are looking for someone that has experience with OGL, or similar, as we are wanting to set up a routine analysis system. Currently I am looking through daily despatch notes which takes me an hour each day, and tells me what our daily fulfillment rate is along with new customers, helps identify what products are selling well and helps me plan for offers. We would like to automate this, so that we can analyse the data quickly.