Description

How to do various things using SQL for Confluence.

Topics

• How to combine queries from multiple databases
• How to configure data source profiles for various databases with examples
• How to avoid format errors when using output=wiki
• How to publish SQL queries to Atlassian Cloud
• How to do data source problem determination
• How to configure application server data sources
• How to implement role based security for SQL queries
• How to log SQL activity
• How to use Confluence metadata in SQL queries
• How to use SQL case statement to improve visual appeal
• How to use HTML in queries
• How to improve the display of SQL source
• Limitation of macros=true parameter while using nested SQL queries
• How to index SQL data
• How to securely run SQL queries without page edit restrictions
• How to create a chart with SQL
• How to secure use of SQL macros
• How to implement role based security for PostgreSQL database
• How to inline SQL data
• How to limit active database connections