SSIS Components for Microsoft Project

Build 21.0.7867

ODataV1 Data Model

The ODataV1 schema implement the ProjectData service endpoints, which is read-only and can only be used for reporting.

Views

Read-only Views are retrieved dynamically from the authenticated Microsoft Project account.

Stored Procedures

Stored Procedures are function-like interfaces to Microsoft Project. Stored procedures allow you to execute operations to Microsoft Project.

ODataV1 advantages compared to ODataV2

  • The custom fields are exposed as view columns.
  • The ProjectId is not required to query any of the exposed views, since the ProjectData endpoints return data for all the available projects.

ODataV1 limitations

  • No write operation is supported as this schema is read-only.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7867