Confluence: connect to external SQL database and display results as dashboard or in tabular format

[Rajesh Selvam]

hi Team,

How can i connect to an external SQL database [testrail ] and display the query results  in confluence as a dashboard or in Tabular format. 

here i do not want to use any add-on like (SQL Plugin for Confluence, Play SQL Base, and PocketQuery). 

is there a code snippet /steps that i can refer to 

Thanks

[David at David Simpson Apps]

Your options are:

• Use an existing add-on
• Write your own new add-on

Confluence is basically a documentation platform that is extensible with add-ons.

When it doesn't do what you need, you can bend it you your needs with either time and knowledge (build your own add-on), or money (use someone elses add-on).

Any of the add-ons you suggested above could help.

[Rajesh Selvam]

thanks for your reply .

in forums, its says php is not supported 

can you guide me on the scripting language /language name that supports so that i can achieve this 

[David at David Simpson Apps]

Assuming you're using Confluence Server, you'll need Java skills :)

[Harshit Manchanda]

Hi David can you explain how using Java can we do the same.. @David at David Simpson Apps