We would like to offer the audience the possibility to work with data from external SQL databases or REST APIs in Confluence and Jira in an interesting and easy way. Let us show how we develop an app that has a lot of pain points, and how it has developed since the start.
Fetch data from any SQL database or REST API you have access to
Users can display results of predefined queries in Confluence pages with a simple macro (and, if permitted, adjust parameters)
Maintain security by controlling access to sensitive information
Use templating mechanism and charts API for custom visualization
Add results to the Confluence search
Cache results to minimize traffic to your datasource
Change parameters dynamically with forms or URL parameters