242,153
Customers have installed this add-on in at least 2,153 active instances.

SQL for Confluence (Pro Edition)

by Bob Swift Atlassian Add-ons (an Appfire company) for Confluence Server 5.4.3 - 5.8.6 and more versions
Versions available for Confluence Server 2.2 - 5.4.3
Atlassian Verified
Bob Swift Atlassian Add-ons (an Appfire company) is an Atlassian Verified vendor. Verified vendors demonstrate Atlassian standards for add-on quality, reliability, and support.

Learn more

Supported
Bob Swift Atlassian Add-ons (an Appfire company) supports this add-on.

Get support

Data Center
This add-on is compatible with the clustering and high-availability capabilities of our products.

    All your data. In Confluence. In real time

    Display and chart SQL query results

    Access multiple data sources

    Secure use with Macro Security

    Show data as a chart using the Confluence Chart macro. Or show data as a table with all customization options available with Common table capabilities.

    Supports JDBC complaint databases, such as MSSQL, Oracle, DB2, PostgreSQL, and MySQL. Data from multiple data sources can be combined on the same page. Flexible options for configuring data sources.

    Use Macro Security for Confluence to control who can create SQL based content. Content, once created by an authorized user, can be viewed by anybody with view rights. Datasource specific restrictions provide flexibility.

    Pricing overview

    Pricing details are loading…

    This add-on is not available for Cloud.

    You can browse available Cloud add-ons here.

    User reviews

    (24)
    Sign in to write a review »
    by Afshin Moazami on 2014-10-24
    The worst documentation ever!
    0 out of 1 found this review helpful
    Was this review helpful?YesNo

    Vendor response

    Thanks for the comment. We do know this is an area that needs attention and plan to improve it significantly over the coming months.
    by Ethan Foulkes on 2014-08-27
    Simply great! This is extremely powerful and has allowed us to display many queries from our ERP into Confluence which is hugely appreciated by our users. Thanks Bob!
    Was this review helpful?YesNo
    by David Jensen on 2013-12-23
    Is there a way to format the text of the SQL results? Currently, I can only get it to return in the default paragraph formatting in confluence. I really need the results to be formatted in a larger font so the results can be read on a TV monitor from a distance.
    Was this review helpful?YesNo

    Vendor response

    You can use various Confluence techniques for this like div and style from Content Formatting Macros (https://marketplace.atlassian.com/plugins/com.adaptavist.confluence.contentFormattingMacros).
    by Rupert Neethling on 2013-11-01
    I tried to install the trial version on Confluence 5.1.5. Simply couldn't enable it. Generated multiple trial licence keys, uninstalled, reinstalled, nothing helped. Error: "This add-on could not be loaded. It has one or more errors which prevent it from being enabled." I have many people in my company who are interested in this plugin, but nobody's going to pay for it until they can see what it can do for them.
    Was this review helpful?YesNo

    Vendor response

    Make sure you are using a recent version of UPM and it is installing a compatible version of the plugin. Your Confluence logs may contain more information on the failure. If still not working, open a support issue with Atlassian - they are primarily responsible for UPM installation and licensing issues. If they can't resolve it promptly, let us know by opening a support issue with us at https://bobswift.atlassian.net/browse/SQL.
    by Davin Studer on 2013-09-06
    This is a great plugin and we use it quite a lot for reporting purposes and coupled with the run plugin this plugin gets even better.
    Was this review helpful?YesNo

    More details

    For a lower cost option, see SQL for Confluence (Express Edition).

    Ideal for generating Business Intelligence (BI) reports from external data within Confluence.

    Works best with:

    Details

    Display results from a SQL query. Data from one or more result sets are formatted and typically displayed as a table. This enables dynamic data to be easily displayed on pages together with documentation and other data. Integrate business intelligence reports with your other collaborative data.

    • Supports JDBC complaint databases, like MSSQL, Oracle, DB2, PostgreSQL, MySQL.
    • Supports multiple data sources. Application server defined or directly defined data sources can be accessed.
    • Supports Common table capabilities: advanced sorting, row highlighting, and column totals & styles.
    • Works with the Chart Macro for data visualization.
    • Enabled for Macro Security for Confluence to control use.

    Paid-via-Atlassian pricing FAQ

    How does add-on pricing work?

    Just like your Atlassian host application, there are two pricing models for add-ons. Pick the model that matches your Atlassian product, and the same rules apply:

    Server pricing:

    • Products and add-ons are hosted on your servers.
    • Licenses last forever and include 12 months of maintenance (support and version updates).
    • You can renew maintenance after 12 months at 50% of the original purchase price.
    • You can upgrade the tier of your host product and add-on licenses at any time. Upgrade prices are calculated based on Atlassian's formula (view example).

    Cloud pricing:

    • Products and add-ons are hosted by Atlassian.
    • You are eligible for support and automatic version updates as long as your subscription is active.
    • Your subscription automatically renews every month. Annual pricing is also available.
    • Your pricing tier for host products and add-ons is automatically upgraded (as necessary) when you add users to your instance.
    How do I determine my pricing tier?

    Choose the same user tier you pay for in the Atlassian host application. For example, if you have a JIRA Server license for 25 users, you should purchase this tier. Even if fewer users want to use the add-on than your host application license, the two licenses should match exactly.

    Do you offer academic, community, or open-source licenses?

    Add-on purchase and renewal is half-price if you have an academic license for your Atlassian host application.

    Add-ons are always free for community and open-source licenses.

    For more details about qualifying for special licenses, see here.

    Can I extend my free trial?

    You can extend your Server add-on trial up to 5 times - in other words, for up to six months. Extend your trial by generating a new evaluation license key from Atlassian Marketplace. Click Free Trial and you'll be directed to generate a license at MyAtlassian. Paste this license key into the add-on listing in UPM from your Atlassian host application, and you're all set.

    You cannot extend your Cloud free evaluation period. All Cloud add-ons are immediately subscribed by a user, and we provide a free evaluation of period. This is a minimum of 30 days and ends on the second billing cycle after you first subscribe to the add-on.

    How can I buy add-ons for my legacy JIRA or Confluence license?

    If you own a legacy JIRA Unlimited (100+ users) or Confluence Unlimited (2000+ users) license purchased in 2012 or earlier, legacy add-on pricing is no longer available. You have two options for add-on purchasing:

    • Purchase the add-on at the non-legacy Unlimited (10000+ users) tier.
    • Renew your JIRA or Confluence license at a non-legacy tier, then purchase the add-on at the same tier.

    Learn more

    Support

    Bob Swift Atlassian Add-ons (an Appfire company) is Atlassian Verified. Verified add-on vendors demonstrate high quality, reliability, and business traction. Learn more

    Bob Swift Atlassian Add-ons (an Appfire company) supports SQL for Confluence (Pro Edition). You can visit the support site to get help.

    Get support

    Release notes

    Version 7.1.1 Confluence Server 5.4.3 - 5.8.6 Released 2015-03-07

    Summary

    Fix to show data source profiles in drop-down list for non-administrators

    Installation

    1. Log into your Confluence instance as an admin.
    2. Click the admin dropdown and choose Atlassian Marketplace. The Manage add-ons screen loads.
    3. Click Find new add-ons from the left-hand side of the page.
    4. Locate SQL for Confluence (Pro Edition) via search. The appropriate add-on version appears in the search results.
    5. Click Try free to begin a new trial or Buy now to purchase a license for SQL for Confluence (Pro Edition). You're prompted to log into MyAtlassian. SQL for Confluence (Pro Edition) begins to download.
    6. Enter your information and click Generate license when redirected to MyAtlassian.
    7. Click Apply license. If you're using an older version of UPM, you can copy and paste the license into your Confluence instance.

    To find older SQL for Confluence (Pro Edition) versions compatible with your instance, you can look through our version history page.

    Similar add-ons