3
222
Customers have installed this app in at least 222 active instances.

    SQL for Confluence (Express Edition)

    by Bob Swift Atlassian Apps (an Appfire company)for Confluence Server 6.11.0 - 7.8.1 and more versions
    Versions available for Confluence Server 5.2 - 6.10.3
    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Supported
    Bob Swift Atlassian Apps (an Appfire company) supports this app.

    Get support

    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Connect and query your SQL databases and create dynamic BI reports — right within Confluence

    Connect and query your SQL databases and create dynamic BI reports — right within Confluence

    Connect and query your SQL databases and create dynamic BI reports — right within Confluence

    Connect databases with a simple, form-based setup

    Run and modify SQL queries in an intuitive editor

    Display SQL data as a table, chart, or graph

    Spend less time configuring your data and more time gaining valuable insights. Create and save up to 3 data source profiles with step-by-step configuration. Monitor connection status with real-time, visual indicators.

    Preview your SQL queries live and customize the results in an easy, form-based macro editor.

    Display business intelligence reports as dynamic tables with advanced sorting, filtering, totaling, and styling. Combine with Confluence's Chart macro to visualize your SQL data as real-time charts or graphs.

    More details

    For unlimited database connections, a Data Center approved version, and additional features, see SQL for Confluence (Pro Edition).

    Highlights:

    • Preview your SQL queries live and customize the results in an intuitive editor
    • Use with Confluence's native Chart macro to visualize your SQL query results
    • Enhance your data tables with column sorting, filtering, totaling, row highlighting, and other custom styling
    • Access your MSSQL, Oracle, PostgreSQL, and MySQL databases
    • Combine multiple data sources for richer reports
    • Use with Macro Security for Confluence, Run Self-Service Reports for Confluence, and Cache for Confluence to create the ultimate BI dashboard

    Appfire helps great makers build what's next. Our growing portfolio of apps empowers teams worldwide with workflow automation, business intelligence, and administration at scale.

    Watch our on-demand webinar

    Reviews for cloud

    (3)Sign in to write a review

    There are no reviews yet. Be the first to review this app.

    Reviews for server

    (3)
    Sign in to write a review
    by CJ on 2020-06-12
    This app is just what we needed to make reports from our database data. It's been really handy to be able to show a bunch of queries on a single page and to be able to add notes in Confluence to give some more context, and then easily share the report with everyone. Plus, once it's set up, if you're able to write your SQL queries, it's quick and easy to make new reports.
    Was this review helpful?YesNo
    Bob Swift Atlassian Apps (an Appfire company)

    Hi CJ,

    Thanks for taking the time to tell us why you love SQL for Confluence! We're always happy to see a 4-star review come through, and glad that we could make an app that suits your SQL needs.

    Best,

    Kelsey Weaver, Product Marketing Manager

    Bob Swift Atlassian Apps (an Appfire company)

    kelsey (dot) weaver (at) appfire (dot) com

    by Artem Fomin on 2019-02-25
    I believe this add-on is powerful and useful for those admins who have a decent knowledge of Confluence DB schema. Yes, it requires a bit of technical expertise, but the fact that you get DB access without needing to connect directly to DB (which is a common use case on managed hosting instances) simplifies things quite a bit.
    Was this review helpful?YesNo
    Bob Swift Atlassian Apps (an Appfire company)

    Hi Artem,

    Thanks for the detailed 4-star review — very helpful! We’re happy you’re finding value using this app with your Confluence database (just one of the many types of SQL data you can bring into your Confluence pages) and we appreciate your feedback!

    Thanks,

    Kat Sandin, Product Marketing Manager

    Bob Swift Atlassian Apps (an Appfire company)

    kat (dot) sandin (at) appfire (dot) com

    by Ulf Herrmann on 2018-07-24
    May be a good add-on, I don't know, as I did not get that far. Setting up a simple database connection is unnecessarily complicated. It sucks. I am for sure no expert for jdbc, but to use this app, you need to be one. There is another app, pocketquery, where I needed only about 1 minute to set up the database connection, so it looks like it's possible to solve this far simpler.
    2 out of 3 found this review helpful
    Was this review helpful?YesNo
    Bob Swift Atlassian Apps (an Appfire company)

    Hi Ulf,

    Thank you so much for your candid feedback. Our team also felt the setup process was too complicated, and this, along with other valuable user feedback, helped shape the all-new configuration menu we just recently released in version 9.0.

    We would be very grateful if you could give us one more try, but this time ensure that you've installed version 9. And we would love to learn more about your experience with our latest release or help troubleshoot any particular issues that may come up for you. Please feel free to reach out to me directly at holly (at) appfire (dot) com.

    Thank you,

    Holly Wright, Marketing Director

    Bob Swift Atlassian Apps (an Appfire company)

    holly (at) appfire (dot) com

    Reviews for Data Center

    (3)Sign in to write a review

    There are no reviews yet. Be the first to review this app.

    Cloud Pricing

    Server Pricing

    Data Center Pricing

    10 users$1025 users$11350 users$189100 users$378250 users$567500 & upAdditional pricing details

    Pricing FAQ

    How does server app pricing work?

    Server products and apps are hosted on your servers. This app is sold as a perpetual license, and the purchase price includes 12 months of maintenance (support and version updates).

    You can renew maintenance after 12 months at 50% of the current purchase price. You can upgrade the tier of your Atlassian product and app licenses at any time. Upgrade prices are calculated based on Atlassian's formula (view example).

    If app pricing changes after your initial purchase, there's a 60-day grandfathering period during which you can renew based on the old pricing.

    How do I determine my server pricing?

    Apps are billed based on the number of users in your Atlassian product. The app tier should match the licensed user tier of the Atlassian product. For example, if you have a Confluence license for 500 users, you should purchase the 500-user tier for apps. Even if fewer users want to use the app than your Atlassian product license, the two licenses should match exactly.

    Can I install this app in a Data Center product?

    This app does not have a Data Center approved version. Only apps meeting a set of performance requirements for large, clustered environments are approved for Data Center.

    However, while server apps are built for single-server deployments, many customers successfully install them in Data Center products. If you're using a Data Center product, Atlassian recommends you contact the vendor to determine compatibility at scale.

    Learn more about Data Center approved apps

    What type of license do I need if I'm using this app in a Data Center product?

    Because this app does not have a Data Center approved version, you should purchase a Server license if you decide to install this app in a Data Center product.

    Learn more about Data Center licensing

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

    For server apps, academic licenses are available at a 50% discount if you have an academic license for your Atlassian product.

    Community and open-source licenses are available for server apps. Learn more about community and open source licenses.

    Can I extend my free trial?

    For server apps, you can extend your app 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 Try it free and you'll be directed to generate a new license. Paste this license key into the app listing in UPM from your Atlassian product, and you're all set.

    How can I buy apps for my legacy Jira Server or Confluence Server license?

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

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

    Learn more

    Bob Swift Atlassian Apps (an Appfire company) provides support for this app.

    Vendor support resources

    Documentation

    Find out how this app works.

    Community

    Community discussions connect you to the vendor and other customers who use this app.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Atlassian-hosted discussions connect you to other customers who use this app.

    Versions

    Version 10.2.0 • Confluence Server 6.11.0 - 7.8.1 • Released 2020-06-17

    Summary

    Filter table data, define delimiter for exports, improved row and column styles.

    Details

    In version 10.2:

    • Use search terms or regular expressions to filter table data
    • Specify a custom file delimiter such as comma, tab, or semicolon to be used when table data is downloaded or exported
    • Enforce user-defined CSS styles for rows and columns

    Read more in the full release notes.

    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 apps or Find new add-ons from the left-hand side of the page.
    4. Locate SQL for Confluence (Express Edition) via search. The appropriate app 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 (Express Edition). You're prompted to log into MyAtlassian. SQL for Confluence (Express 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 (Express Edition) versions compatible with your instance, you can look through our version history page.

    Similar apps