Versions Compared

Old Version 12

changes.mady.by.user Randall Ward

Saved on

compared with

New Version 13

changes.mady.by.user Randall Ward

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

(info) At least one Data Source or Data Source Profile needs to be configured before you can use the SQL Macro or SQL-query Macro or SQL-file.

...

MethodPrimary BenefitKey AttributesDocumentationExpress EditionPro Edition
Data Source ProfilesConvenience
  • SQL for Confluence specific configuration
  • Convenience 
    • Configuration change in affect immediately
    • File system access not needed
  • Can reference application server defined Data Sources
  • Recommended for evaluation, testing, short term scenarios
  • Medium or heavier use scenarios should also employ Cache for Confluence
Configure Data Source Profiles(tick)(tick)
Application Server-based Data SourcePerformance
  • Application server based configuration
  • Best performance via connection pooling/reuse
  • Requires Confluence restart after configuration change
  • Recommended for long term/heavy use scenarios
Configure Application Server-based Data Sources - v9(error)(tick)


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
titleMacro Security for data source access control

Macro Security for Confluence can be used to control access to specific Data Sources in the same way no matter what method is used.

...