Overview

The CData ADO.NET Provider for Microsoft Project models Microsoft Project objects as relational tables and views. Microsoft Project objects have relationships with each other, which the provider expresses through foreign keys.

Connecting with the ODataV2 Schema

In the ODataV2 Data Model (default), column metadata is dynamically retrieved for each entity, but the schema is fixed and custom fields are not included.

Connecting with the ODataV1 Schema

In the ODataV1 Data Model, metadata is dynamically retrieved, including the custom fields for this schema. This schema is read-only.

Key Features

• The provider models Microsoft Project entities as relational tables and views, allowing you to write SQL to query Microsoft Project data.
• Stored procedures allow you to execute operations to Microsoft Project.
• Live connectivity to these objects means any changes to your Microsoft Project account are immediately reflected when using the provider.