Jira
It s possible to create some basic data visualizations for any SQL+JQL query.
You can find all the provided gadgets by searching for “SQL+JQL”
Sharing Dashboards is safe with SQL+JQL since all the data is always displayed according to the calling user’s permissions in Jira.
From the 7.12.2 version, the Pivot and Flat tables support users' saved queries for backward compatibility. The saved query id is not displayed on the User’s Saved Queries listing for re-using in gadgets:
Available gadgets
Confluence
In order to add Jira gadgets to Confluence pages please follow this Atlassian’s documentation.
Since the 7.6 version, Jira content cannot be embedded in external iframes. It requires an explicit configuration for security headers.