7
Customers have installed this app in at least 7 active instances.
    by KFK Solutionsfor Confluence Server 5.3 - 6.2.4
    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

    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

    Pricing

    10 users$1025 users$2550 users$50100 users$100250 users$150500 & upAdditional pricing details

    Paid-via-Atlassian pricing FAQ

    How does server app pricing work?

    Server products and apps are hosted on your servers. Licenses are perpetual and the purchase price include 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 host 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 host product. The app tier should match the licensed user tier of the Atlassian host product. For example, if you have a Confluence Server license for 25 users, you should purchase the 25-user tier for apps. Even if fewer users want to use the app than your host product license, the two licenses should match exactly.

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

    For server apps, purchase and renewal is half-price if you have an academic license for your Atlassian host product. Server apps 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?

    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 host 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.2.4 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 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