Overview
...
Info |
---|
At least one data source or data source profile must be configured before you can use |
...
the SQL Macro |
...
, SQL-query Macro, or, SQL-file Macro. |
SQL Macros use Data Sources This page describes two methods to configure data sources for the macros provided by SQL for Confluence. SQL macros use data sources to access databases. A Data Source A data source defines the access parameters including credentials. The same database access information is required for each method. Similarly, the database must allow access using the information provided no matter which method is used.
Method | Primary Benefit | Key Attributes | Documentation | Express Edition | Pro Edition |
---|---|---|---|---|---|
Data Source Profilessource profiles | Convenience |
| Configure data source profiles | ||
Application server defined Data Source-based data source | Performance |
| Data Source configuration - Configure application server-based data sources |
Tip |
---|
You can configure data sources using either of the methods or both - for instance use a data source profile while testing or for low-use scenarios, then switch to a server-based data source when/if it becomes clear it is going to be around for a long while. |
Tip | ||
---|---|---|
| ||
Macro Security for Confluence can can be used to control access to specific Data Sources data sources in the same way no matter what method is used. |
Tip | ||
---|---|---|
| ||
Give your users better response times and reduce the load on your server by using Cache for Confluence macros macros for heavy use scenarios. |
Next Step: Deep Dive into Data Sources Profiles
Regardless of whether you elect to create Application server defined Data Sources for performance or opt to keep things simple, you will need to configure Data Source Profiles, so let's head there next.
Data Source Profiles - 9.xThe data source is referenced using the dataSource (data source name) parameter. The exact configuration of a data source is application server and database specific. The configuration must be done by a Confluence administrator and the Confluence application server must be restarted for changes to be active. The configuration must be done very carefully as any errors result in the data source being unusable . Each database you need to access in Confluence needs to a have a data source configuration.