The CData ADO.NET Provider for Confluence models Confluence data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures. Live connectivity to these objects means that any changes to your Confluence account are immediately available.

Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Confluence account.

Commonly used tables include:

Table	Description
AllUsers	Returns a complete list of all registered users in the Confluence instance, including both active and disabled accounts.
Attachments	Retrieves metadata for attachments stored in Confluence, such as file names, sizes, and related content pages.
AuditRecords	Provides a paginated list of audit records detailing user and system activities performed since a specified time period.
Blogposts	Retrieves detailed information about blog posts, including titles, authors, publication dates, and associated spaces.
Comments	Returns information about comments made on pages, blog posts, or other content, including author details and timestamps.
Contributors	Lists the users who have contributed to a specific page or space, providing insight into collaboration and content ownership.
Groups	Returns information about user groups configured in Confluence, such as group names, descriptions, and membership details.
GroupMembers	Retrieves all users belonging to a specified group, including their display names and account details.
Labels	Returns the labels associated with a specific piece of content, helping categorize and organize information within Confluence.
Pages	Contains structured data about all Confluence pages, including titles, content IDs, authors, and associated spaces.
PageAncestors	Displays the parent hierarchy of a page, showing how the current page is positioned within the overall content structure.
PageChildren	Displays the child hierarchy of a page, showing which subpages are nested under a given parent page.
PageComments	Retrieves all comments made on a particular page, including text content, authors, and creation dates.
PageContents	Provides access to the textual and metadata content of a Confluence page, including version and author information.
Spaces	Retrieves metadata and configuration details about spaces, including names, keys, descriptions, and access settings.
SpacePermissions	Returns detailed permission settings for one or more spaces, specifying which users and groups have access or administrative rights.
Tasks	Provides information on tasks assigned or created within Confluence, including assignees, due dates, and completion status.
Users	Returns details for a specific user, such as username, display name, email address, and account status.
ViewsAnalytics	Shows analytics data on total views of a specific content item, including repeated visits by the same user.
Whiteboards	Retrieves details about collaborative whiteboards created within Confluence, including titles, owners, and associated spaces.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including searching, managing attachments, and managing OAuth tokens.