Table describing data source types:
|Data Source Type||Primary Benefit||Key Attributes||Express Edition||Pro Edition|
|Data source profiles||Convenience|
- SQL for Confluence specific configuration
- Configuration change in effect immediately
- File system access not needed
- Can reference application server defined data sources
- Recommended for evaluation, testing, or short term scenarios
- Medium or heavy use scenarios should also employ Cache for Confluence to improve page performance
|Application server defined data source||Performance|
- Application server based configuration
- Best performance by connection pooling or reuse
- Requires Confluence restart after a configuration change
- Recommended for long-term or heavy use scenarios
Over the years, we've grown the number of parameter and parameter options that you can flex within our SQL macros. Ideally, we want to provide our users with all the built-in capabilities from the database vendor their data sources are accessing. Knowing fully that some of these parameters can be sensitive, we also provide the ability for your administrator to control their usage.
With key concepts under your belt, we recommend you explore and familiarize yourself with the macros shipped with SQL for Confluence.