How to Automatically Create a Formatted Table From SQL Data
On this page
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
More recipes
View all our Recipes for Business Intelligence & Automation. Here are some of our latest updates:
Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.