Recipe overview

This recipe provides step-by-step instructions for building a formatted table based on a SQL data source. It allows you to transform raw data into attractive and compelling information. This recipe utilizes the following items:

• The SQL for Confluence add-on, which comes in both Express and Pro editions, to query a SQL database to retrieve the data to be presented in the chart.

• The Cache for Confluence add-on to ensure the rendering of the page occurs as quickly as possible.

• The Macro Security for Confluence add-on to safeguard the page and the database it uses by ensuring that only Administrators can use the SQL macro.

It will take you approximately 10-12 minutes to complete this recipe. Jump to Step 5 to see a preview of the final result!

Recipe level

Ingredients

Preparation

• Install MySQL and the sample Examplegear Database, including defining the "examplegeardb" data source profile.

Steps