Our client had SQL Server, SSIS, SSRS, SSAS, MDS, all sitting together. The OLTP databases were cohabiting with the BI databases. All this led to security issues as well as some huge performance issues. Besides their datawarehouse was more a copy of certain tables but not a real datawarehouse designed to build cubes on top. We designed and put in place a new architecture to separate the roles, taking into account the budget restrictions. Once the new architecture was approved, we planned the migration and implemented it. The new topology now delivers much better performance. This also brought new business perspectives thanks to a real BI analysis.
