Home

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.

• Getting Started
• Development Desktop
• Build Server Setup

Import into SSDT

• Import Databases
  • Fixing Database Import Issues
• Import SSAS Projects
• Import SSIS Projects
• Import SSRS Projects

Build

• Basic Build Pipeline
• Basic Overview
• Build Databases
• Build Tabular Cubes
• Build Multidimensional Cubes
• Build SSIS Projects
• Build SSRS Projects

Deployment

• Build Server Setup
• Build/Deploy Pipeline
• Deploy Databases
  • DAC Publish Profile
• Deploy Tabular Cubes
• Deploy SSIS Projects
• Deploy SSRS Projects

Unit Tests

• SSDT Unit Tests
• tSQLt Unit Tests

Integration Tests

• Import Test Data
• Run ETL Tasks
• NBi Integration Tests
• SpecFlow Integration Tests

Packaging Artifacts

• Creating Nuget Packages

Deployment Tools

• Publish to Octopus Deploy