SQL*XL - Customer Case Study

Company

...anonymous...

Description

Mobile Phone Company based in Sweden

 

Requirements to meet

To create, read, update and delete tables in Oracle 8 and 9 databases for testing a data warehouse solution. We have the same requirements the development of another system: a new case tracking system. This was for maintaining TEST/DUMMY data and for maintaining REFERENCE data. Two things that MS Excel and SQL*XL are extremely well suited to.

Issues to tackle

Solution had to allow very easy/fast manipulation of the data in the tables. SQL*XL allowed this exceptionally well through MS Excel. The data must be exported to "loadscripts" that could be run automatically. Again Excel and SQL*XL allowed to do this easily.

Approach taken

We used SQL*XL with some custom VBA script on top. We put buttons on a toolbar. All the functionality in our solution could be started through these buttons. The users don't ever use the SQL*XL menus although using these menus was essential in working out how to develop our VBA code.
 

Results

Excellent, see screenshot: