Great SQL (DB Connector)
As we continue to move towards a cloud future together, new server app sales and installs are no longer available for customers. You can update app version via Atlassian Marketplace until the end of support for server on Feb 15, 2024. Learn more
SQL 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
Results visible in the Confluence search
Great SQL in Macro Browser
Auto – executing query always when page is loading
On-demand – executing query when click the button (persistant results)
Great SQL Configuration Page
Up to 30 Database different database connections
(When using Informix in the Database field enter: databaseName|informixServer )
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:
Sample query with contextuality:
"select * from salary where user_name = #Confluence_logged_user_name#"
Privacy and security