Integration

Integration with Slack

Introduction

Slack is a cloud-based communication and collaboration platform designed to unite team members and streamline organizational communication. It allows teams to communicate in real-time through instant messaging, voice and video calls, and file sharing.

Slack's features include channels, which are dedicated spaces for specific topics or projects, and integrations with tools and services such as Google Drive, Trello, and Salesforce.

Slack's main goal is to simplify communication and collaboration, reduce email clutter, and increase productivity by providing a centralized platform for team members to work together. 

OvalEdge Integration

Integrating OvalEdge with Slack is based on the extensibility of alerts that are sent through the mail to clients. Users can send a direct message to their desired Slack channel from OvalEdge.

The messages can be related to the Data Catalog (sharing the data definitions, data lineage, and data quality information), Workflow (sharing the data workflows, such as data preparation and data analysis), Data Asset (sharing information about data sources, data quality, and data usage) and Data Governance (sharing data governance tasks, such as data privacy and compliance). 

To integrate OvalEdge with Slack, a couple of Slack parameters (optional and mandatory) and the configurations in the OvalEdge application are required.

Components of Slack

The following are some of the important components of Slack. 

  1. Workspace in Slack
  2. Apps in Slack
  3. Channels in Slack
  4. Direct messages in Slack

Workspace in Slack

The Slack workspace consists of channels that team members can use to communicate and collaborate. You will likely be able to communicate with people from your organization or your specific team here daily. 

Apps in Slack

Slack apps allow you to connect other software (like Google Calendar, Salesforce, or internal company tools) to Slack. In this use case, we connect Ovaledge to Slack. To receive OvalEdge notifications in their Slack workspace, clients must create an App.

Channels in Slack

Slack channels are used for teamwork and communication. A channel helps you share ideas, make decisions, and move work forward by bringing the right people together. 

For example, A channel named #Mobile App Dev Team is created so that the group of people who are working on developing a mobile application will share their ideas and updates in this channel.

Direct messages in Slack

In this app, individuals can chat privately, similar to other communication apps.

Integrating OvalEdge with Slack

To Integrate OvalEdge with Slack, complete the following tasks.

  1. Create a Workspace in Slack.
  2. Generate User OAuth Token in Slack.
  3. Configure the OAuth Token in OvalEdge. 

Creating a Workspace in Slack

To create a Workspace:

1.   Install Slack on your machine. 

2.   Once after the successful installation of Slack, open the Slack application.

     

3.   Click on Create a new workspace link. The Slack login page is displayed.

     

4.   Enter your organization's email address (Ex: test@ovaledge.com). The 6-digit code is sent to your entered email address.

5.   Enter the code. The code entered is validated and the Open Slack pop-up window is displayed.

6.   Click on the Open Slack button. The Add Slack Workspace page is displayed.

     

7.   Enter the name and upload the photo that helps your teammates recognize more easily and click on the Next button. The Add Teammates window is displayed. 

     

8.   Enter your teammates' email address who needs to be included in the workspace and click on the Next button. The purpose of the workspace window is displayed.

     

9.   Enter the purpose of the workspace and click on the Next button. The Workspace Name, The Purpose of the Workspace, and Team and Administrators details are displayed on the Slack home page.

     

Generating User OAuth Token in Slack


To generate the User OAuth Token in Slack:

1.   On the Slack home page, click on the workspace name and select the Settings & administration option. 

     

2.   Select the Manage Apps option. The Installed Apps page is displayed.

     

3.   In the header menu, click on the Build option. The Your Apps page is displayed

     

4.   Click on the Create New App button, the Create an app pop-up window is displayed.

     

5.   Click on the From scratch option, the Name app & choose workspace pop-up is displayed,

     

6.   Enter the name of the app in the App Name textbox.

7.   By default, the workspace created will be displayed in the Pick a workspace to develop your app in the dropdown. Select the workspace and click on the Create App button. The Basic Information page is displayed.

8.   In the Basic Information page, under the Add Features and Functionality, click on the Bots widget. The Application home page is displayed.

     

     

9.   Click on the Review Scopes to Add, and the OAuth & Permissions page is displayed.

     

10.  Scroll down to the User Token Scopes section, and for Add permission by Scope or API method, select the chat:write permission from the dropdown.

     

     

11.  Once after selecting the permissions, click on the Install to Workspace button. The confirmation page is displayed.

     

12.  Click on the Allow button, and the OAuth Token for Your Workspace is generated and displayed in the User OAuth Token textbox.

     

13.  Copy the User OAuth Token and paste it in the OvalEdge Slack Configuration.

Configuring the OAuth Token in OvalEdge

To configure Slack’s User OAuth Token in the OvalEdge application.

1.   Log in to the OvalEdge application.

2.   In the left menu, click on the Administration module name and click on the Configuration sub-module name. The Configuration home page is displayed. 

3.   Click on the Notifications tab and select the Configuration Type as “OVALEDGE_APP” and Key as “slack.app.oauth.token”. 

4.   Click on the Value and paste the User OAuth Token which was generated in Slack.

5.   Click on the Save button. The User OAuth Token configurations will be saved.

6.   Once after entering the User OAuth Token configuration details, mention the Slack ID on the OvalEdge My Profile page.

7.   In the Slack application, click on the Profile name. The About page is displayed.

8.   Click on the View Full Profile link, and under the Profile name, click on the 3 Dots option. The Account settings option menu is displayed. 

     

     

9.   Click on the Copy Member ID, and the Slack ID will be copied to the clipboard.

10.  Navigate to the OvalEdge application.

11.  In the left menu, click on the My Resource module name, and click on the My Profile sub-module name. The My Profile home page is displayed.

12.  Click on the Edit Profile icon. The Edit Profile pop-up window is displayed.

     

13.  In the Slack ID textbox, paste the Member ID, which was copied from the Slack View Full Profile page.

14.  Click on the Save button, and the message “Profile updated successfully” is displayed.

15.  Once after entering the Slack ID details. Under the Notification Settings section.

16.  Select the messages or alerts which you want to view on Slack. The available alerts are related to Collaboration, Watchlist Alerts, System Alerts, Data Quality Alerts, Service Desk Alerts, Governance Roles Alerts, and Team Communication.

     

17.  Once after selecting the notifications, navigate to Administration > Configurations and click on the Notifications tab.  

18.  Click on the Test button.

19.  Click on the Test Slack option. 

     

20.  The provided User OAuth Token and Slack ID are validated, and a message “Successfully sent Test Message to Slack” is displayed. Here, the Test message from the Ovaledge application is sent to Slack.

     

21.  Verify the Test message in Slack.

     

Testing Collaboration Notifications 

1.   In the OvalEdge application.

2.   In the left menu, click on the Data Catalog main module menu, and click on the Databases sub-module name. The Databases home page is displayed.

3.   Click on the Schema name, and the Schema Summary page is displayed.

4.   In the Schema Summary page, click on the Collaboration icon and enter the test information by tagging the administrator using @ annotation.

5.   Click on the Submit button. The notification is sent to the administrator, which is also displayed in the Slack Workspace under the administrator profile.

     

6.   Verify the Collaboration Test message in Slack.

     

7.   If the Collaboration is used by tagging any other teammates using @ annotation. Then the notification is sent to that particular user, which is also displayed in the Slack Workspace under that particular user profile.

     

Note: To receive the Slack Notification, the particular user must be created in OvalEdge, and their Slack ID must also be configured in the OvalEdge My Profile > Slack ID.

Testing Job Workflow Notifications 

1.    In the OvalEdge application.

2.   In the left menu, click on Administration > Job Workflow.

3.   Click the + icon on the Job Workflow Information page. A new job workflow template is displayed.

4.   Enter a Job Workflow name.

5.   Click the Job Types and choose the related jobs to be added to the workflow.

6.   Drag and drop the Jobs in the workflow space.

7.   Click on the Save icon to save the Job Workflow.

     

8.   Click on the 9 Dots option and select the Notifications options. The Notification Settings pop-up window is displayed.

9.   Select the checkboxes to send a notification on Error or on Success, or on Partial Success.

10.  Click on the Notify Experts button. The message “Notification added successfully” is displayed.

11.  Click on the Expert icon, and the Add or Remove experts pop-up window is displayed.

12.  Select the teammates to whom the notification needs to be sent and click on the Update Experts button. 

13.  Once after selecting the teammates, click on the Run icon, the job is initiated, and the notifications will be sent to the expert's email, and the same notifications will also be sent to the Slack ID.

14.  Verify the Job Workflow notification message in the Administrator Slack.

     

15.  Verify the Job Workflow notification message in the Teammate Slack.