Business Situation
The current Reporting Server hardware was reaching end-of-life and had experienced component failures over the previous 18 months. Furthermore, the growth in Reporting scope and increased demand for Reporting outputs had brought the old hardware to the limit of its capacity. In order to ensure continued availability and supportability of the BP Compliance Reporting Service, it has been decided to migrate Reporting processes to a new platform.
Solution
Pineywoods was able to provide consulting services via subject matter expertise and knowledge in transitioning to a new reporting environment that better suited the needs of the department. We created superior SQL CLR routines to replace old procedures. We guided the recommendations to optimize performance and effeciencies on the new platform.
Result
BP Compliance staff and report consumers experienced a much more stable, performant, and upgraded system.
