[CUSTOMER]

An international manufacturer and designer of lenses

[BUSINESS NEED]

The company held 22 Whip and Ship Reports in Spotfire, which hit the database all at once every 2 hours, bringing down the database server.

[CUSTOMER CHALLENGES]

The database holding the reports being a Transactional Database, brought down the data server due to multiple transactions, each time the reports were called. This scenario caused an outage in production, on multiple occasions.