{"id":103884,"date":"2024-09-11T17:00:00","date_gmt":"2024-09-11T17:00:00","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=103884"},"modified":"2024-09-07T15:37:01","modified_gmt":"2024-09-07T15:37:01","slug":"data-activator-the-secrets-of-monitoring-alerts","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/data-activator-the-secrets-of-monitoring-alerts\/","title":{"rendered":"Data Activator: The secrets of monitoring alerts"},"content":{"rendered":"<p>Data Activator supports email and Teams alerts. These are good options when we would like to monitor some information and receive alerts about it.<\/p>\n<p>However, these options have some limitations:<\/p>\n<ul>\n<li>Teams: It can only connect to the same tenant and doesn&#8217;t support sending messages to channels.<\/li>\n<li>Email: It can only send messages to emails in the same domain as Fabric.<\/li>\n<\/ul>\n<p>How to solve this problem, being more flexible to send alert messages?<\/p>\n<h2>The Solution: Alerts in Pipelines<\/h2>\n<p>Pipelines have activities to send email and to send teams messages. These activities don&#8217;t have any of these limitations.<\/p>\n<p>Each of these activities allow you to use a login to one of these services: outlook email or teams. You can use any account for the login. It doesn&#8217;t need to be either your Fabric account or any account in the same domain as Fabric.<\/p>\n<p>This means you can send teams messages and emails to any domain, no restrictions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"608\" height=\"161\" class=\"wp-image-103885\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/09\/a-screenshot-of-a-computer-description-automatica.png\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" \/><\/p>\n<h2>Fabric Item Action<\/h2>\n<p>In a Reflex object you can use a Fabric Item Action to trigger a pipeline. You can choose pipelines from any workspace.<\/p>\n<p>The limitation we still have is that we can&#8217;t send parameters to the pipeline.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"411\" class=\"wp-image-103886\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/09\/a-screenshot-of-a-computer-description-automatica-1.png\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" \/><\/p>\n<h2>Environments and the Alerts<\/h2>\n<p>In a scenario where you have a DEV, TEST and PROD environment, it&#8217;s important to identify the messages according to the environment.<\/p>\n<p>It would be great if we could parameterize this information and use a pipeline parameter to dynamically build the message subject.<\/p>\n<p>This could make it possible to configure a deployment pipeline rule to dynamically change the parameter value when we promote the pipeline across the environments.<\/p>\n<p>Unfortunately, pipeline parameters are not recognized by the deployment pipeline for the creation of rules. It&#8217;s also not possible to send pipeline parameters from the Reflex action.<\/p>\n<h2>Summary<\/h2>\n<p>It&#8217;s great that we can work around the problem and send notification messages as we would like. However, this is a limited solution considering the problems it creates for the development lifecycle.<\/p>\n<p>We hope the development lifecycle will evolve soon and provide a solution to these problems.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Activator supports email and Teams alerts. These are good options when we would like to monitor some information and receive alerts about it. However, these options have some limitations: Teams: It can only connect to the same tenant and doesn&#8217;t support sending messages to channels. Email: It can only send messages to emails in&#8230;&hellip;<\/p>\n","protected":false},"author":50808,"featured_media":103888,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,159164],"tags":[159116,145486,158997,101611],"coauthors":[6810],"class_list":["post-103884","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blogs","category-microsoft-fabric","tag-data-activator","tag-data-factory","tag-microsoft-fabric","tag-power-bi"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/103884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/50808"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=103884"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/103884\/revisions"}],"predecessor-version":[{"id":103887,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/103884\/revisions\/103887"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/103888"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=103884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=103884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=103884"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=103884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}