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. |
|
|
|
|
|
|
|