Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Confluence 6.2/Oracle : which database table contains content of Confluence pages

Rafal Sojka
Contributor
February 15, 2018

Hi,

Do you know if this is possible to identify the database table name in which the content of all pages is stored ? We would like to implement application that connects with Confluence database in read-only mode (in this case it is Oracle,) and retrieve the content of a few pages for further analysis.

Thank you for help,
Rafal

1 answer

1 accepted

2 votes
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2018

The table is Bodycontent, but you really do not want to do this.

To make sense of the content, you're going to have to write a parser to read and interpret the content into something you can read and analyse properly.

If you do this the right way, instead of SQL, it will be far easier - use REST to get the content.

Rafal Sojka
Contributor
February 15, 2018

Thank you Nic, I think you are right and we should switch to REST.  Do you know if there is any document showing how to get a page content using REST  ? 

Best regards,
Rafal

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 16, 2018
Rafal Sojka
Contributor
February 19, 2018

Thank you, right, it will be very useful. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events