Continuous integration framework

Continuous integration poses a major challenge in the area of MSSQL Server BI. No standardized solution is available on the market for integrated development of the MSSQL BI components (SQL, SSIS, SSAS and SSRS). There are only autonomous proprietary and open source tools available for individual subtasks and continuous integration. Open source tools only are used in this project. The custom-developed framework is implemented by three fundamental components. Jenkins integration server (I) controls the execution of PowerShell scripts (II), as soon as a change to the source code is reported by the source code management system subversion (III). The BI components are managed by the .Net Framework Assemblies and MSBuild. The result of the integration process is presented in Jenkins in the form of MSTest results and is then passed on to developers, as appropriate.