Can Confluence display/update tables from External Databases or within it?

[Rupa Jain]

Say I have a database with a few tables either within Confluence or outside of it.

And I am try to achieve the following:

1) Display these tables on Confluence pages so that users can view them.

2) Also if users chose to edit these tables, the database should get update.

Is this achievable?

[Deleted user]

Hi @Rupa Jain ,

You can use SQL for Confluence to display and chart SQL query results by accessing multiple external data sources. You can show data as a table with all customization options available with Common table capabilities.

With regards to editing the SQL data, you can use only use update and insert SQL.But there is no UI to do that in the SQL plugin. The Run macro provides UI forms that can be used in combination with the SQL macro to this kind of thing.

Regards,

Swathi

[Alexis Robert]

Hello, 

you could have a look the SQL Connector plugin: https://marketplace.atlassian.com/plugins/com.playsql.sqlsaas/cloud/overview

You will be able to query and display results in Confluence using this add-on.

I am not sure if an addon is available to perform updates on a table.

Cheers, 

-- Alexis