SQL Plugin for Confluence

(22) 49594 downloads Bob Swift Atlassian Add-ons (an Appfire Company) Reports & chartsAvailable for Confluence 5.3 - 5.4.4 Atlassian Verified
This add-on is supported by Bob Swift Atlassian Add-ons (an Appfire Company), an Atlassian Verified vendor.

Get support

Confluence becomes a business intelligence tool

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

You can browse available OnDemand add-ons here.

User reviews

(22)Sign in to write a review »
by David Jensen on 23 Dec 2013
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 01 Nov 2013
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 06 Sep 2013
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
by Jahsie on 17 Dec 2012
Awesome product, helps us to be so much more productive. Was using an access database to display all of our reports before this. Thanks Bob~!
Was this review helpful?YesNo
by John Rotenstein on 12 Nov 2012
We use the SQL plugin extensively within Atlassian -- it's the lifeblood for our corporate reporting, which is all done within Confluence. The SQL plugin brings realtime data into a normally-static Confluence page, which means people can search for, and access, data without having to leave Confluence. It's great being able to put descriptive information on the same page as "live" data -- it lets us explain terminology and provide analysis side-by-side with the data. For examples of how we use it, see: http://bit.ly/howto-report
Was this review helpful?YesNo

More details

This plugin enables you to display results from an 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. Confluence becomes a reporting and business intelligence tool that is integrated with your other collaborative data.

  • Supports JDBC complaint databases, such as MSSQL, Oracle, DB2, PostgreSQL, and MySQL.
  • Multiple data sources can be access. Either application server defined or directly defined data sources can be accessed.
  • Supports Common table capabilities, such as advanced sorting, row highlighting, and column totals and styles.
  • Compatible with the Chart macro to create charts from the SQL results.
  • Enabled for Macro Security for Confluence to control use. Datasource specific restrictions provide flexibility.
  • Advanced logging support assists administrators with usage and problem determination.
  • Paid-via-Atlassian pricing FAQ

    How do upgrades and renewals work?

    You can upgrade your Atlassian host product license to increase the user tier for add-on licenses any time. Upgrade prices are calculated based on Atlassian's formula, and are automatically reflected in your cart. View an example of the JIRA upgrade price matrix here.

    Add-on licences for downloaded Atlassian products are perpetual. Your original purchase includes 12 months of maintenance. To continue receiving upgrades and support after the initial 12 months, you can renew your maintenance for 50% of the original purchase price. You can purchase maintenance for up to 36 additional months at any time.

    OnDemand add-on subscriptions renew each month and can be canceled any time.

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

    What's the difference between OnDemand and download pricing?

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

    OnDemand:
    Subscriptions renew every month
    Add-ons and instances are hosted by Atlassian
    Download:
    Licenses last forever, support and upgrades last for 12 months
    Instances and add-ons are hosted on your servers
    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.

    Do you offer enterprise pricing?

    Choose enterprise pricing if your Atlassian host application is billed for enterprise licenses.

    Enterprise pricing includes 24/7 phone and email support, access to training through Atlassian University, and other perks. Learn more.

    Can I extend my free trial?

    You can extend your 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.

    Alternatively, if you remove your expiring trial license from your Atlassian host application, you can re-add it back for another free trial.

    What are legacy pricing tiers?

    If you bought your Atlassian host application during or before February 2012, you qualify for legacy pricing tiers.

    • JIRA tiers are 10, 25, 50, and 100 users. The legacy unlimited tier was 100+ users.
    • The Confluence legacy tiers are 10, 25, 50, 100, 500, and 2000 users. The unlimited legacy tier was 2000+ users.
    • There are no enterprise licenses prior to and including February 2012.

    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 supports SQL Plugin for Confluence. You can visit the support site to get help.

    Get support

    Release notes

    version 6.2.0Confluence 5.3 - 5.4.4

    Release Notes 6.2

    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 Plugin for Confluence 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 Plugin for Confluence. You're prompted to log into MyAtlassian. SQL Plugin for Confluence 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 Plugin for Confluence versions compatible with your instance, you can look through our version history page.

    Similar add-ons