Getting Started

There are so many Azure Pipelines Extensions that it is hard to know where to start. This wiki will explain the basics of applying DevOps to your Data Warehouse.

The first steps you need to take are:

1. Set up your Development Desktop
2. Put your databases, cubes and SSIS packages under source code control by importing them into SQL Server Data Tools (SSDT)
   • Import Databases
   • Import SSAS Projects
   • Import SSIS Projects
   • Import SSRS Projects
3. Set up an Azure Pipeline which builds each of your components
   • Build Databases
   • Build Tabular Cubes
   • Build Multidimensional Cubes
   • Build SSIS Projects
   • Build SSRS Projects

When you have done all the above, you are ready to extend your Azure Pipeline by having the agent deploy the databases, cubes and SSIS packages to a build server, load test data and then run a set of automated tests against all the components. To do this, you will need an in-house self-hosted build server running the Azure Pipelines self-hosted agent.

1. Set up an In-House Build Server
2. Deploy each of your components
   • Deploy Databases
   • Deploy Tabular Cubes
   • Deploy SSIS Projects
   • Deploy SSRS Projects