As a prominent mortgage company in the U.S., our client has extensive computer and data systems. Over the years, multiple databases had been introduced into their ecosystem due to acquisitions and application development. Most of these databases run on different RDBMS, such as Informix, Oracle, SQL Server, and, in some cases, Access.
Due to this convoluted database collection, each department created their own reporting solutions via technologies, like Excel, Oracle Reports, and Crystal reports. These solutions depended on the client’s IT team for setup and changes. This workflow created huge overhead in terms of maintenance costs and created a severe security risk; sensitive consumer data could be accessed by multiple users across divisions without centralized control of any sort. In addition, some reports taxed the production databases causing noticeable delays during business hours.