The CData ODBC Driver for Microsoft SharePoint models Microsoft SharePoint data as an easy-to-use SQL database with tables, views, and stored procedures. Live connectivity to these objects means that any changes to your Microsoft SharePoint account are immediately reflected in the driver.

Tables

Lists in your Microsoft SharePoint site are dynamically generated as relational tables. This means any change you make in your lists, such as adding a new list or new fields, is reflected in the driver.

Because tables are dynamically generated, documentation on specific tables is not available.

Views

Typically, entities that cannot be modified are represented as Views, or read-only tables.

Common views include:

Table	Description
AllFiles	Retrieves all files and folders across all document libraries on a SharePoint site, including metadata details. Useful for auditing, bulk processing, and data migration.
AllLists	Lists all available SharePoint lists within the domain, including system fields and metadata. Essential for identifying and managing lists across the SharePoint environment.
Attachments	Retrieves attachments associated with a specific list item in a SharePoint list. Helps manage and track attached files related to SharePoint items.
Comments	Contains details about comments made on SharePoint items, including authorship, content, replies, and metadata. Useful for monitoring discussions and user interactions.
Files	Retrieves file attachments associated with a specific SharePoint list item. Facilitates file management and ensures access to necessary attachments.
Groups	Retrieves group details from a SharePoint site, including membership, permissions, and ownership settings. Essential for managing access control and security within SharePoint.
Lists	Retrieves metadata for available lists within a SharePoint site, including list types and settings. Important for understanding the structure of SharePoint lists and their usage.
ListItems	Represents all items within SharePoint lists, including standard columns applicable across different lists. Useful for bulk data extraction and reporting.
RoleAssignmentMember	Retrieves details about members assigned to specific roles within SharePoint site permissions. Helps in auditing and managing user access rights.
RoleAssignments	Retrieves role assignments configured on a SharePoint site, including users and groups with access. Useful for reviewing and managing SharePoint security policies.
RoleDefinitionBindings	Lists role definitions bound to specific security groups or users within a SharePoint site. Helps administrators enforce permission policies.
Roles	Provides details about available role definitions, including permission levels within a SharePoint site collection. Essential for setting up and modifying security roles.
Sites	Retrieves a list of all available sites within the SharePoint server, including metadata and site details. Useful for managing and navigating large SharePoint deployments.
Subsites	Lists all subsites under a specified SharePoint site, including hierarchy and metadata. Helps in structuring and organizing content within a SharePoint environment.
Users	Retrieves a list of users and their assigned roles within a SharePoint site or group. Important for managing permissions and user activity tracking.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including searching, updating, and modifying information.