On this page

The SQL for Confluence (Pro Edition) app version 11.x has removed the support for application server-defined data sources in Confluence 8.x. (Atlassian has ended support for the data source connections in Confluence 8.0. For more information, refer to Configuring a data source connection.)

In Confluence 8.x, we recommend reconfiguring the application server-defined data source profile to the connection string profile. For more information, refer to How to convert an application server defined data source profile to a connection string profile.

SQL for Confluence (Pro Edition) app version 11.x works seamlessly with Confluence 7.x (Confluence 7.4 to Confluence 7.20) versions, including support for application server-defined data sources (JNDI data source connections).

Description

The SQL File macro has parameters and behavior similar to the SQL macro. There are two primary reasons for using this macro:

Security - it can be secured independently of the SQL and SQL attachment macros. If you are an administrator:
- You can control the queries accessible to the general users who are authorized using the Macro Security for Confluence app.
- If you are not using Macro Security for Confluence app, you can disable the SQL and SQL Query macros while allowing access to the SQL File macro. (As it allows users to query only a fixed set of statements.)
Simplified File Access — the modified parameter makes it easier to specify and read SQL from files.

For more information on:

Common SQL parameters, refer to Common SQL parameters - 11.x
Common table parameters, refer to Common Table Parameters - 11.x

Example: Use SQL Macro with Markup

Browser not supported