SSIS Components for Microsoft Project

Build 21.0.7867

ODataV2 Data Model

The ODataV2 schema implements the ProjectServer service endpoints, which has support for full CRUD operations.

Tables

Tables are retrieved dynamically from the authenticated Microsoft Project account.

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.

ODataV2 advantages compared to ODataV1

  • Supports write operations (INSERT, UPDATE and DELETE) on the exposed tables.

ODataV2 limitations

  • In order to query some tables and views, such as Assignments, ProjectResources, TaskLinks and Tasks, the ProjectId must be specified either in the query's WHERE clause criteria or via the ProjectId connection property.
  • The custom fields are not exposed.

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