Overview

This section shows the available objects in the Sourcing Project Management API and provides more information about using SQL with it.

Key Features

• The add-in models SAP Ariba entities like teams, projects, and documents as relational views, allowing you to write SQL to query SAP Ariba data.
• Stored procedures allow you to execute operations to SAP Ariba.
• Live connectivity to these objects means any changes to your account are immediately reflected when using the add-in.

Tables

Tables describes the available tables. Tables are statically defined to model resources like Projects, Teams, and TeamUsers.

Views

Views are read-only tables that model resources such as Documents, Tasks, and TeamGroups.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to download documents, download task comment attachments, and perform OAuth token management