resource center   >  topics  >  Admin Set Up

Implementing Stracl Tableau Web Data Connector

Purpose 

This document provides a brief description of the benefits of using the Web Data Connector(WDC), and then it explains how customers can connect Tableau to Stracl using the WDC. 

Overview

Stracl is a cloud-based software to automate and accelerate change management. It is primarily used by Change Management Professionals, Project Managers,Instructional Designers, and Security Specialists to do the following tasks: 

  • Conduct Stakeholder Analysis  
  • Conduct Change Impact Analysis 
  • Analyze and mitigate Change Impacts  
  • Create and manage Communication and Engagement Plans  
  • Perform Training Analysis & Design and track Training Development  
  • Map future-state roles to security access and required training   
  • Access selected corporate Organizational Data to support projects

Benefits  

  • Analyze your Stracl data in Tableau
  • Your company determines what can be seen. 
  • Each team can analyze the data the way they want.

When Tableau accesses Stracl SaaS, your change impact data analysis improves. Your data requests are accurately and efficiently delivered to Tableau because of changes in your company’s Org. Data are automatically synced by Stracl SaaS.

Requirements 

Client needs to have Tableau Desktop Application or Server. 

WDC URL 

https://apps.stracl.com/yourinstance/tableau/wdc.aspx 

Authentication 

Stracl will provide you with an authentication key. 

Available Data 

The following data objects are available:  

  • Org. Data 
  • Stakeholder Group 
  • Stakeholder Group - Employee
  • Stakeholder Group - Change Impact Analysis
  • Stakeholder Analysis 
  • Change Impact Analysis 

Org. Data 

Field ID Type Alias Description
Person_ID String Person ID
Employee_ID String Employee ID
First_Name String First Name
Last_Name String Last Name
Email String Email
Level_1_Manager String Level 1 Manager
Level_1_Manager_ID String Level 1 Manager ID
Approving_Manager_ID String Approving Manager ID
Country String Country
Location String Location
Title String Title
Login_ID String Login_ID
Custom_Field_1 String Custom Field 1
Custom_Field_2 String Custom Field 2
Custom_Field_3 String Custom Field 3
Custom_Field_4 String Custom Field 4
Custom_Field_5 String Custom Field 5
Custom_Field_6 String Custom Field 6
Custom_Field_7 String Custom Field 7
Status String Status A' for "Active" and 'I' for "Inactive" 
Last_Modified_By String Last Modified By
Date_Last_Modified String Date Last Modified

Stakeholder Group

Field ID Data Type Alias
Stakeholder_Group_ID String Stakeholder Group ID
Stakeholder_Name String Stakeholder Name
Owner String Owner
Team String Team
Add_Email_List String Additional Email List
Status String Status
Project_ID String Project ID
Project_Name String Project Name
Last_Modified_By String Last Modified By
Date_Last_Modified String Date Last Modified

Stakeholder Group - Employee

Field ID Data Type Alias
Stakeholder_Group_ID String Stakeholder Group ID
Person_ID String Person ID
Status String Status
Comments String Comments
Custom_Field_1 String Custom Field 1
Custom_Field_2 String Custom Field 2
Custom_Field_3 String Custom Field 3
Custom_Field_4 String Custom Field 4
Custom_Field_5 String Custom Field 5
Last_Modified_By String Last Modified By
Date_Last_Modified String Date Last Modified

Stakeholder Group - Change Impact Analysis

Field ID Data Type Alias
Stakeholder_Group_ID String Stakeholder Group ID
Change_Impact_ID String Change Impact ID
Stakeholder_Category_ID String Stakeholder Category ID

Stakeholder Analysis

Field ID Data Type Alias Description
Stakeholder_Analysis_ID String Stakeholder Analysis ID
Stakeholder_List_ID String Stakeholder List ID
Stakeholder_Person_ID String Stakeholder Person ID
Stakeholder String Stakeholder
Stakeholder_Description String Stakeholder Description
Stakeholder_Expectations String Stakeholder Expectations
Stakeholder_Concerns String Stakeholder Concerns
Stakeholder_Owner String Stakeholder Owner
Type String Type
Analysis_Owner String Analysis Owner
Analysis_Level String Analysis Level
Analysis_Status String Analysis Status
Suggestions String Suggestions
Communication_Method String Communication Method
Key_Messages String Key Messages
Members String Members
Ranking_Power String Ranking Power
Ranking_Interest String Ranking Interest
Ranking_1 String Ranking 1
Ranking_2 String Ranking 2
Ranking_3 String Ranking 3
Ranking_4 String Ranking 4
Custom_Field_1 String Custom Field 1
Custom_Field_2 String Custom Field 2
Project_ID String Project ID
Project_Name String Project Name
Last_Modified_By String Last Modified By
Date_Last_Modified String Date Last Modified

Change Impact Analysis

Field ID Data Type Alias Description
Change_Impact_ID String Change Impact ID
Change_Impact String Change Impact
Analysis_Owner String Analysis Owner
Impact_Date String Impact Date
Ranking_Impact String Ranking Impact
Ranking_Probability String Ranking Probability
Ranking_Risk String Ranking Risk
Current_State String Current State
Future_State String Future State
Action_Required String Action Required
Change_Value String Change Value
Custom_Field_1 String Custom Field 1
Custom_Field_2 String Custom Field 2
Change_Filter_1 String Change_Filter 1
Change_Filter_2 String Change_Filter 2
Status String Status 'A' for "Active" and 'I' for "Inactive"
Project_ID String Project ID
Project_Name String Project
Last_Modified_By String Last Modified By
Date_Last_Modified String Date Last Modified

Join The Organizational Change Management Software Revolution Today

Schedule Demo