16
Customers have installed this app in at least 16 active instances.
    by KFK Solutionsfor Confluence Server 5.3 - 6.12.2
    Supported
    KFK Solutions supports this app.

    Get support

    SQL results from database | REFRESH ON DEMAND | Results can be placed on the page body | Simple configuration

    SQL results from database | REFRESH ON DEMAND | Results can be placed on the page body | Simple configuration

    SQL results from database | REFRESH ON DEMAND | Results can be placed on the page body | Simple configuration

    Great SQL macro on page

    Great SQL in Macro Browser

    Great SQL Admin Configuration Page

    GREAT SQL FEATURES

    Auto-resizing table

    Floating header

    Highlighting active row

    Table content can be visible from Confluence search (persistant mode)

    Contextual queries (based on logged user)

    THREE REFRESHING MODES

    Auto – execut sql always when is page load

    On demand – execute sql only when you click a refresh button

    Auto (persist) – execute sql always when is page load (but results are persist in page)

    SIMPLE CONFIGURATION

    Up to 30 Database Connctions

    More details

    POWERFULL CONFLUENCE SQL ADD-ON

    > Great SQL provides external database connections for Confluence

    > Support all of database engines such as: Oracle, Microsoft SQL Server, MySql, Postgre (via JDBC)

    > You can refresh results from database in three modes

    1. Automatic – query will be executed on database always when the page is loading

    2. On demand – query will be executed on database only when you click a special refresh button. In this mode on page will be presented results from last refresh - not directly from database.

    3. Automatic– query will be executed on database always when the page is loaded but result are persisting in the page body

    > Contextual query - sql query can be executed diffrently depending on Confluence Logged User.

    Use this expressions to enter contextuality:

    #Confluence_logged_user_name#

    #Confluence_logged_user_fullname#

    #Confluence_logged_user_email#

    Sample query using contextuality:

    "select * from salary where user_name = #Confluence_logged_user_name#"

    Reviews for cloud

    (3)
    Sign in to write a review
    by Bruno Venditti on 2017-07-10
    A very intuitive to use add-on that opens up great possibilities for dynamic page content.
    Was this review helpful?YesNo
    by Juan Martinez on 2017-02-13
    Wow! Refresh on-demand is what I needed from sql macro. I recommend!
    1 out of 3 found this review helpful
    Was this review helpful?YesNo
    by Adam Wyszomirski on 2017-02-10
    This is really usefull sql add-on.
    0 out of 2 found this review helpful
    Was this review helpful?YesNo

    Reviews for server

    (3)
    Sign in to write a review
    by Bruno Venditti on 2017-07-10
    A very intuitive to use add-on that opens up great possibilities for dynamic page content.
    Was this review helpful?YesNo
    by Juan Martinez on 2017-02-13
    Wow! Refresh on-demand is what I needed from sql macro. I recommend!
    1 out of 3 found this review helpful
    Was this review helpful?YesNo
    by Adam Wyszomirski on 2017-02-10
    This is really usefull sql add-on.
    0 out of 2 found this review helpful
    Was this review helpful?YesNo

    Reviews for Data Center

    (3)
    Sign in to write a review
    by Bruno Venditti on 2017-07-10
    A very intuitive to use add-on that opens up great possibilities for dynamic page content.
    Was this review helpful?YesNo
    by Juan Martinez on 2017-02-13
    Wow! Refresh on-demand is what I needed from sql macro. I recommend!
    1 out of 3 found this review helpful
    Was this review helpful?YesNo
    by Adam Wyszomirski on 2017-02-10
    This is really usefull sql add-on.
    0 out of 2 found this review helpful
    Was this review helpful?YesNo

    Cloud Pricing

    Server Pricing

    Data Center Pricing

    10 users$2025 users$5050 users$100100 users$150250 users$250500 & 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 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

    KFK Solutions provides support for this app.

    Vendor support resources

    Documentation

    Find out how this app works.

    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 1.1.5 Confluence Server 5.3 - 6.12.2 Released 2017-07-15

    Summary

    Contextuality

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

    Similar apps