Overview

The CData ODBC Driver for Microsoft Project models Microsoft Project objects as relational tables and views. A Microsoft Project object has relationships to other objects; in the tables, these relationships are expressed through foreign keys.

Connecting with the ODataV2 Schema

The ODataV2 Data Model (default) can be used for full CRUD operations. Main columns metadata is dynamically retrieved for each entity, but the schema is fixed and custom fields are not included.

Tables and Views describe a sample the tables available in the ODataV2 API.

Connecting with the ODataV1 Schema

The ODataV1 Data Model can only be used for reading data. Metadata is dynamically retrieved, including the custom fields for this schema.

Views describe a sample the views available in the ODataV1 API.

Key Features

• The driver 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 driver.