SQL*XL - Customer Case Study


GSW Inc.


GSW Inc is a manufacturer of a diversity of consumer durable products such as building products and water heaters based in North America.




Requirements to meet

Our ERP system (Baan) sits on top of an Oracle 8 database. We need to perform ad-hoc queries and perform analysis on the results.

Issues to tackle

Getting data out of the ERP system into Excel in a format that is easy to work with can be a challenge for ad-hoc queries. 

Approach taken

I use SQL*XL to quickly dump data from our ERP system into Excel.


SQL*XL parses and formats the data for you and therefore it saves a lot of time.
The results are easy to pivot, filter or manipulate the data in excel.