Versions Compared

Old Version 8

changes.mady.by.user Randall Ward

Saved on

compared with

New Version 9

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.

SQL macros use Data Sources to access databases. 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.

MethodPrimary BenefitKey AttributesDocumentationExpress EditionPro Edition
Data Source profilesProfilesConvenience
  • 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
Data Source Profiles(tick)(tick)
Application server defined 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
Data source Source configuration - application server(error)(tick)

...

Tip
titleUse Cache and Future macros around SQL macros

Give your users better response times and reduce the load on your server by using Cache for Confluence 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.x