SQL*XL - Customer Case Study

Company

GSW Inc.

Description

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

Web

www.gswinc.com

 

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.

Results

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.