How to Automate your DWH Deployments

How to Automate your DWH Deployments

Efficient development processes are based on automated processes to test, integrate, and deploy applications into production. With typical applications, this is quite an easy task. For database applications, it’s a bit harder. This article explains why and how to execute this process successfully.

Some time ago, I wrote about the Challenges in Automating Multi-Schema Database Deployments. It was about why automated database deployments are crucial to efficient development processes and why they are challenging to establish with multi-schema applications.

Automating Multi-Schema-Database Deployments — The challenges!

Deployment of Multi-Schema-Database Applications is different from deploying your regular Single-Schema-Database! This…

blog.usejournal.com

After implementing many automated DWH deployment processes, I now summarized the most important steps to get there and explain why not only technological implementations have to be made but also process changes and why they are crucial.

A deployment process from hell

Manual deployments include all the processes that require manual steps to install your software into production. Those manual steps can be:

  • Emailing the install scripts to other people (lack of centralized repository).

  • Manual execution of installation scripts (lack of automated pipelines).

  • Copying files around (lack of centralized repository).

  • Sending emails (lack of automated processes).

  • People outside the team execute the installation (lack of ownership).

    Image for post

Example of a manual deployment process where communication happens over email.

In the picture above, an example of a manual deployment process is shown. The team member sends an installation package over email to the DBA. The DBA then manually installs the scripts on the target database. He then sends an email back to the team member with a message if the deployment was successful or not. If it wasn’t, he attaches a log file with the error. The team member then has to start looking for the problem and sends a fix again to the DBA…

devops development process-improvement continuous-integration toolchain

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Hire Dedicated DevOps Developers

Hire our Dedicated DevOps Developers who have in-depth skills and expertise to develop an interactive and secure web application. Get custom DevOps solutions for your project.

Hire DevOps Developer

Looking to hire top DevOps developers at affordable prices? **[Hire DevOps Developer](https://hourlydeveloper.io/hire-dedicated-devops-developer/ "Hire DevOps Developer")** from **[HourlyDeveloper.io](https://hourlydeveloper.io/...

Measuring DevOps Metrics: A How-To Guide

DevOps is supposed to help streamline the process of taking code changes and getting them to production for users to enjoy. But what exactly does it mean for the process to be "streamlined"? One way to answer this is to start measuring metrics.

How long does it take to develop/build an app?

This article covers A-Z about the mobile and web app development process and answers your question on how long does it take to develop/build an app.

DevOps Guide: Implementing Four-Eyes Principle With Process Automation Tooling

With great power comes great responsibility. More and more organisations are moving towards a DevOps based organisational model, putting more and more respon...