8 June 2015
8 June 2015

How to integrate DLM Dashboard with (just about) every service you use

Integrate DLM Dashboard with almost every tool you use in your workplace

If you haven’t heard of DLM Dashboard, let me fill you in –  it’s a new free tool for helping SQL Server DBAs and developers know what database schema is deployed where. One of the main ways DLM Dashboard does this is by sending an email notification as soon as it spots any unexpected schema changes.

DLM Dashboard’s email notifications have proved hugely popular. Over the last 6 months we’ve had heaps of feedback from users telling us how they’ve avoided problems by being notified of unexpected schema changes.

But what if you don’t live in your email inbox? Something that most users don’t know is that receiving notifications in your inbox is just the start of what you can do with DLM Dashboard. In fact, the possibilities are practically limitless. You can use DLM Dashboard’s email notifications to automate a vast array of tasks, like alerting you and your team via HipChat, or automatically creating a new issue on GitHub when an unplanned schema change is made.

Screenshot of DLM Dashboard and Slack integration

DLM Dashboard alerts in Slack

All you need to do is configure DLM Dashboard’s email notifications to be sent to a web integration service such as Zapier or IFFFT. Once connected, you can configure the email notifications to trigger automated tasks with a huge number of services and apps.

How does this work?

When a schema change is made to a database that DLM Dashboard is watching, an alert is triggered.  DLM Dashboard then sends an email notification to your chosen web integration service. The web integration service receives the notification email and, depending on the contents of the email, triggers an automated task within your chosen app or service.

Don’t worry if you’ve already set up email notifications to be sent to your email address; DLM Dashboard allows you to send notifications to multiple email addresses. Most web integration services allow you to configure email addresses which in turn trigger an action.

So what exactly can I do?

Pretty much anything! The only requirements are that you’ve set up DLM Dashboard email notifications and have an account with a web integration service (e.g. Zapier or IFTTT).  Here are a few of the ideas we’ve come up with to help you and your team manage schema changes:

  1. Receive a team Slack or HipChat alert when your database schemas change
  2. Create a Trello testing task every time you push a change to your testing environment
  3. Create a Jira or GitHub issue or a Zendesk ticket every time your production database drifts from the expected schema
  4. Keep a detailed record of all database changes in Google Sheets
  5. Track the frequency of database changes with Geckoboard
  6. Turn on a red alert light whenever your production database drifts with Philips Hue and IFTTT

How do I get started?

All you need to do is set up email notifications in DLM Dashboard and configure them to be sent to Zapier or IFTTT. You can then create an automated task which is triggered whenever an email is sent. I’d definitely recommend spending some time experimenting with all of the various integrations and services – as I said before, the possibilities are limitless!

If you’d like more detailed instructions, why not read my follow-up article? It includes an in-depth explanation of how to send Slack IM alerts to you and your team whenever your database schemas change.

In the meantime – have fun experimenting!

DLM Dashboard is Redgate’s new free tool for helping DBAs and developers know what database schema is deployed where. If you want to find out more, download the free edition!

Tools in this post

DLM Dashboard

Track your SQL Server databases and be the first to know about schema changes.

Find out more

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

Related posts

Also in Blog

Learning from the Accelerate “Four Key Metrics”

There's been a lot of excitement about the book Accelerate, which summarizes research from the past several years of the State of DevOps Report from DORA (which Redgate sponsors).

Perhaps the most po...

Also in Software development

How to unlock the budget for your next IT initiative – free Redgate webinar

When you’ve got a great idea for transforming software development or IT processes in your organization, it can be frustrating. You might have a clear picture of what you can achieve, but often you...

Also about DLM Dashboard

DLM Dashboard – the inside story

As a DevOps engineer at Redgate, I’m one of those responsible for keeping the systems going behind the scenes. That’s everything from the internal systems and databases to the infrastructure that ...