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.
A cumbersome and slow Enterprise Data Warehouse (EDW) solution which adhered to a stringent set of schemas. The company needed a way to ingest data from various sources & house it in an easily accessible repository.