SSIS Components for Microsoft Planner

Build 24.0.8963

Data Model

Overview

This section shows the available API objects and provides more information on executing SQL to Microsoft Planner APIs.

Key Features

  • The component models Microsoft Planner entities like tasks, plans, and buckets as relational tables, allowing you to write SQL to query and modify Microsoft Planner data.
  • Stored procedures allow you to execute operations to Microsoft Planner, including retrieving the access token and keeping it refreshed in OAuth 2.0.
  • Live connectivity to these objects means any changes to your Microsoft Planner account are immediately reflected when using the component.

Tables

Views describes the available tables. Table are dynamically defined to model Tasks, Plans, Buckets, and more.

Views

Views describes the available views. Views are dynamically defined to model Groups and Users. Views may not be modified, but can be used to supplement queries to the tables.

Stored Procedures

Stored Procedures are function-like interfaces to Microsoft Planner. Stored procedures allow you to execute operations to Microsoft Planner, including updating task board format and retrieving oauth credentials.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963