Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
The Apache Superset Userview Menu plugin is used to integrate Apache Superset dashboards into Joget DX Userview Menu. User can choose to embed their dashboard in either public or protected. Customisation options can be configured to show or hide before rendering the dashboard.
This plugin is created with the use of Superset Embedded SDK to embed the Superset dashboards into Joget DX.
This plugin source code is available in JogetOSS repository at https://github.com/jogetoss/superset-menu.
Figure 1: A dashboard from Apache Superset displayed in userview menu
Menu label. Mandatory field.
Menu element unique ID.
The type of dashboard that is shown to the user.
This field is visible when "Dashboard Type" is public. Defines the entire URL of the dashboard.
Apache Superset URL
This field is visible when "Dashboard Type" is protected. Defines the domain running Apache Superset.
This field is visible when "Dashboard Type" is protected. Superset user name used to create guest token. Refer to Configure Superset User Permissions
This field is visible when "Dashboard Type" is protected. Superset user password used to create guest token.
Dashboard Embed ID
This field is visible when "Dashboard Type" is protected. Embed ID retrieved from Superset dashboard. Refer to Retrieve Superset Dashboard Embed ID.
This option is visible when "Dashboard Type" is protected. Show or hide the title of the dashboard.
This option is visible when "Dashboard Type" is protected. Show or hide the tabs of the dashboard.
Show Chart Controls
This option is visible when "Dashboard Type" is protected. Show or hide the chart controls of the dashboard.
This option is visible when "Dashboard Type" is protected. Show or hide the filter bar of the dashboard.
Settings > List Roles > Edit Record for "Public" role
can read on chart
can read on Dashboard
can dashboard on Superset
can explore json on Superset
all datasource access on all_datasource_access
all database access on all_database_access
...and any other permissions if required
Figure 2: Edit Role for "Public"
Figure 3: Permission "datasource access on [examples]"
Figure 4: Permission "database access on [examples]"
When "Dashboard Type" is protected, username and password is required. The user is required to generate guest token for end user to access the dashboard anonymously. The guest token that is generated follows the role configured in config.py for Superset (Figure 5). Note: the guest does not follow the role of the user configured in Apache Superset Userview Menu. The default role for guest is "Public".
To generate the least permission user to only be used to generate guest token, create a new user and role for it.
Create a new role (Figure 6):
Create a new user (Figure 7):
Figure 5: Default setting for Guest Role at Config.py for Superset
Figure 6: Add new role to generate guest token
Figure 7: Add new user to generate guest token
At config.py for Superset, enable "EMBEDDED_SUPERSET" to True.
Dashboards > any dashboard > Settings > Embed dashboard
Copy the embed ID
Figure 8: Enable Embedded_Superset to True at Config.py for Superset
Figure 9: Embed dashboard option enabled after setting in Config.py
Figure 10: Embed ID in Embed dashboard
Show Chart Controls
Figure 11: Original dashboard without customisation
Figure 12: Show Title
Figure 13: Show Chart Controls