Overview

The CData Cmdlets PowerShell Module for Microsoft Project models Microsoft Project objects as relational tables and views. Microsoft Project objects have relationships with each other, which the cmdlet 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 cmdlet 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 cmdlet.