SSIS Components for Microsoft Project

Build 21.0.7867

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard. To find out more about tables and stored procedures, please navigate to their corresponding entries in this help document.

CData SSIS Components for Microsoft Project Views

Name Description
AssignmentBaselines Retrieve assignment baselines.
AssignmentBaselineTimephasedDataSet Retrieve assignment baseline timephased dataset.
Assignments Retrieve assignments.
AssignmentTimephasedDataSet Retrieve assignment timephased dataset.
BusinessDriverDepartments Retrieve business driver departments.
BusinessDrivers Retrieve business drivers.
CostConstraintScenarios Retrieve cost constraint scenarios.
CostScenarioProjects Retrieve cost scenario projects.
Deliverables Retrieve deliverables.
Engagements Retrieve engagements.
EngagementsComments Retrieve engagements comments.
EngagementsTimephasedDataSet Retrieve engagements timephased dataset.
FiscalPeriods Retrieve fiscal periods.
Issues Retrieve issues.
IssueTaskAssociations Retrieve issue-task associations.
PortfolioAnalyses Retrieve portfolio analyses.
PortfolioAnalysisProjects Retrieve portfolio analysis projects.
PrioritizationDriverRelations Retrieve prioritization driver relations.
PrioritizationDrivers Retrieve prioritization drivers.
Prioritizations Retrieve prioritizations.
ProjectBaselines Retrieve project baselines.
Projects Retrieve projects.
ProjectWorkflowStageDataSet Retrieve project workflow stage dataset.
ResourceConstraintScenarios Retrieve resource constraint scenarios.
ResourceDemandTimephasedDataSet Retrieve resource demand timephased dataset.
Resources Retrieve resources.
ResourceScenarioProjects Retrieve resource scenario projects.
ResourceTimephasedDataSet Retrieve resource timephased dataset.
Risks Retrieve risks.
RiskTaskAssociations Retrieve risk task associations.
TaskBaselines Retrieve task baselines.
TaskBaselineTimephasedDataSet Retrieve task baseline timephased dataset.
Tasks Retrieve tasks.
TaskTimephasedDataSet Retrieve task timephased dataset.
TimeSet Retrieve timeset.
TimesheetClasses Retrieve timesheet classes.
TimesheetLineActualDataSet Retrieve timesheet line actual dataset.
TimesheetLines Retrieve timesheet lines.
TimesheetPeriods Retrieve timesheet periods.
Timesheets Retrieve timesheets.

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