SQL*XL - Customer Case Study
|
Company |
BT - British Telecom |
|
Description |
BT is one of Europe's leading providers of telecommunications services. Its principal activities include local, national and international telecommunications services, higher-value broadband and internet products and services, and IT solutions. |
|
Web |
http://www.bt.com |
|
|
|
|
Requirements to meet |
|
|
Provide access to an ORACLE database without having to write any application code (except the SQL) and get data into an EXCEL spreadsheet |
|
|
Issues to tackle |
|
|
The main application is in Java but we had no time to do anything fancy to made ad hoc reports (which users wants in EXCEL due to the nature of the data) |
|
|
Approach taken |
|
|
Use SQL*XL3 for the MIS of the system |
|
|
Results |
|
|
Get a complete system much cheaper than if we hand coded the lot |
|
|
|
|
|
|
|