Update Confluence page automatically

[Michael Wojtowicz]

We are building a taxonomy database and this database will be updated as new taxonomy information is discovered. We want to create and update a confluence page that can be refreshed every day from this database (using a query) to publish the latest Taxonomy information. 

Any suggestions ? 

[Kurt Klinner]

@Michael Wojtowicz

Hi Michael

one option could be to embed the data from your taxonomy databases directly to a confluence page by using one of the sql-query add ons available at the marketplace

https://marketplace.atlassian.com/search?query=sql

i used the "SQL for Confluence" addon to realise direct db access.

Another option would be to use a custom script that queries your database and adds the data afterwards to a confluence page by using the API

BR

Kurt

[Michael Wojtowicz]

Thanks - trying the plug in first.  Trying to keep the technical debt manageable but keeping custom scripts to a minimum.