How to access the Confluence database?

Christian Christian December 3, 2011

We do have multiple systems in place and hence want to avoid the duplication of data. There is one application which we are running which we have not managed so far to connect to our AD/LDAP. As Confluence is synced with the AD/LDAP I am looking for a possibility to access following data from the Confluence database via an external application:

- User information (name, telephone, email, ...)
- groups and their members

Is this possible or does Confluence not allow this at all?

Thanks,
Christian

1 answer

1 accepted

1 vote
Answer accepted
Dennis Kromhout van der Meer
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.
December 4, 2011

You can always extract this information via database directly, but you have to be careful with your queries for deletion, etc. For example, this query returns all the users in Confluence:

select child_name
from cwd_membership
where parent_name='confluence-users'

It's also possible to get the required information via the Confluence API or via the Atlassian Commandline Interface.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events