Skip to:

Great SQL (DB Connector)

works with Confluence Server 4.2.3 - 8.8.1 and more

OVERALL RATINGS

We no longer offer sales and support for server apps. You can stay connected by exploring the migration options to either the cloud or Data Center version of this app.

Explore migration program

Key highlights of the appSQL results from Databases | On-demand refreshing | Persistant Results | Simple configuration

IMPORTANT - Enable Confluence HTML Macros !

Magage apps ->list all-> search "html"

Enable: Confluence HTML Macros -> html (html-xhtml) & html(html)

GREAT SQL FEATURES

Persistent results

Refresh on-demand

Results visible in the Confluence search

Context query

Great SQL in Macro Browser

REFRESHING MODES

Auto – executing query always when page is loading

On-demand – executing query when click the button (persistant results)

Great SQL Configuration Page

SIMPLE CONFIGURATION

Up to 30 Database different database connections

(When using Informix in the Database field enter: databaseName|informixServer )

Supporting media

More details

CONFLUENCE DATABASE CONNECTOR

Great SQL provides external database connections to fetch data and visualize SQL results on Confluence pages.

Supports database engines: Oracle, Oracle Pluggable, Microsoft SQL Server, MySql, Postgre, DB2, Derby, MongoDB, Sybase, Informix

Two refreshing modes:

  • Auto – query is executed always when the page is loading
  • On-demand – query is executed only when user click "refresh button". *In this mode table with results is save on the page and if database connection is not available the results will still visible.*In this mode results are visible from Confluence Search!

Contextual query - queries 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 with contextuality:

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

Resources

Privacy and Security

Privacy policy

Atlassian's privacy policy is not applicable to the use of this app. Please refer to the privacy policy provided by this app's partner.

Partner privacy policy

Security program

This app is not part of the Marketplace Bug Bounty program.

Version information

We no longer offer sales and support for server apps. You can still explore the earlier versions but these may not offer the necessary support.

Explore all server versions

Learn and explore

  • What’s Marketplace
  • App installation
  • About Atlassian
  • Atlassian resources
  • Search and ranking
  • Atlassian events
  • Atlassian foundation

Follow