Data sources - 8.x

Owned by Randall Ward
Last updated: Mar 02, 2020 by Smita Nair
1 min read

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 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
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
Configure application server based data sources(error)(tick)

Macro 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.

Use 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.

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.