This page provides a guide to Establishing a Connection to SAP Ariba in CData Cloud, as well as information on the available resources, and a reference to the available connection properties.

Connecting to SAP Ariba

Establishing a Connection shows how to authenticate to SAP Ariba and configure any necessary connection properties to create a database in CData Cloud

Accessing Data from CData Cloud Services

Accessing data from SAP Ariba through the available standard services and CData Cloud administration is documented in further details in the CData Cloud Documentation.

Connect to SAP Ariba by selecting the corresponding icon in the Database tab. Required properties are listed under Settings. The Advanced tab lists connection properties that are not typically required.

Connecting to SAP Ariba

Set the following to connect:

• API: Specify which API you would like the Cloud to retrieve SAP Ariba data from. Select the Supplier, Sourcing Project Management, or Contract API based on your business role.
• DataCenter: The data center where your account's data is hosted.
• Realm: The name of the site you want to access.
• Environment: Indicate whether you are connecting to a test, sandbox, or production environment.

If you are connecting to the Supplier Data API or the Contract API, additionally set the following:

• User: Id of the user on whose behalf API calls are invoked.
• PasswordAdapter: The password associated with the authenticating User.

Finally, if you're connecting to the Supplier API, set ProjectId to the Id of the sourcing project you want to retrieve data from.

Authenticating to SAP Ariba

Authentication to SAP Ariba APIs is handled via OAuth. SAP Ariba's OAuth flow requires no user interaction.

OAuthClient

Set the AuthScheme to OAuthClient.

You need to register an application with the service to obtain the APIKey, OAuthClientId and OAuthClientSecret.

See Creating a Custom OAuth App for information about creating an application.

InitiateOAuth defaults to GETANDREFRESH for the OAuthClient authentication scheme.

Automatic OAuth

Get and Refresh the OAuth Access Token

After setting the following, you are ready to connect:

• APIKey: The Application key in your app settings.
• OAuthClientId: The OAuth Client Id in your app settings.
• OAuthClientSecret: The OAuth Secret in your app settings.

When you connect, the Cloud automatically completes the OAuth process:

1. The Cloud obtains an access token from SAP Ariba and uses it to request data.
2. The Cloud refreshes the access token automatically when it expires.
3. The OAuth values are saved in memory relative to the location specified in OAuthSettingsLocation.

Manual OAuth

Get an OAuth Access Token

Set the following connection properties to obtain the OAuthAccessToken:

• APIKey: The Application key in your app settings.
• OAuthClientId: The OAuth Client Id in your app settings.
• OAuthClientSecret: The OAuth Secret in your app settings.

Then call the GetOAuthAccessToken stored procedure. Set the GrantType input to client_credentials or openapi_2lo (available for legacy users). If not specified, GrantType defaults to client_credentials.

After you have obtained the access and refresh tokens, you can connect to data and refresh the OAuth access token either automatically or manually.

Automatic Refresh of the OAuth Access Token

To have the Cloud automatically refresh the OAuth access token, set the following on the first data connection.

• InitiateOAuth: REFRESH.
• APIKey: The Application key in your app settings.
• OAuthClientId: The OAuth Client Id in your app settings.
• OAuthClientSecret: The OAuth Secret in your app settings.
• OAuthAccessToken: The access token returned by GetOAuthAccessToken.
• OAuthRefreshToken: The refresh token returned by GetOAuthAccessToken.

Manual Refresh of the OAuth Access Token

The only value needed to manually refresh the OAuth access token when connecting to data is the OAuth refresh token. Use the RefreshOAuthAccessToken stored procedure to manually refresh the OAuthAccessToken after the ExpiresIn parameter value returned by GetOAuthAccessToken has elapsed, then set the following connection properties:

• APIKey: The Application key in your app settings.
• OAuthClientId: The OAuth Client Id in your app settings.
• OAuthClientSecret: The OAuth Secret in your app settings.

Then call RefreshOAuthAccessToken with OAuthRefreshToken set to the OAuth refresh token returned by GetOAuthAccessToken. After the new tokens have been retrieved, open a new connection by setting the OAuthAccessToken property to the value returned by RefreshOAuthAccessToken.

Finally, store the OAuth refresh token so that you can use it to manually refresh the OAuth access token after it has expired.

Create a Custom OAuth App

Complete the following procedure to obtain the APIKey, OAuthClientId, and OAuthClientSecret.

1. Go to https://developer.ariba.com and sign in.
2. Click Manage (bottom icon on the left).
3. Click the + button next to the search field.
4. Fill in Application Name > Description, then click Submit.
5. Click Actions then click Request API Access.
6. Select the API you want to retrieve data from. This corresponds to the API connection property.
7. Select your realm.
8. Click Submit.
9. Wait until the request is approved.
10. Once approved, click Actions > Generate OAuth Secret.
11. Save the values displayed for Application key, OAuth Client Id and OAuth Secret.

Customizing the SSL Configuration

By default, the Cloud attempts to negotiate TLS with the server. The server certificate is validated against the default system trusted certificate store. You can override how the certificate gets validated using the SSLServerCert connection property.

To specify another certificate, see the SSLServerCert connection property.

Connecting Through a Firewall or Proxy

HTTP Proxies

To authenticate to an HTTP proxy, set the following:

• ProxyServer: the hostname or IP address of the proxy server that you want to route HTTP traffic through.
• ProxyPort: the TCP port that the proxy server is running on.
• ProxyAuthScheme: the authentication method the Cloud uses when authenticating to the proxy server.
• ProxyUser: the username of a user account registered with the proxy server.
• ProxyPassword: the password associated with the ProxyUser.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

The CData Cloud models entities in the SAP Ariba API as views and stored procedures. These are defined in schema files, which are simple, text-based configuration files that are easy to customize.

Using Supplier Data API With Pagination V4

See Supplier Data API With Pagination V4 Data Model for the available entities in the Supplier Data API With Pagination V4.

Using Sourcing Project Management API V2

See Sourcing Project Management API V2 Data Model for the available entities in the Sourcing Project Management API V2.

Using Contract API V1

See Contract API V1 Data Model for the available entities in the Contract API V1.

Using Risk Category Information API For Supplier Risk Exposure V1

See Risk Category Information API For Supplier Risk Exposure V1 Data Model for the available procedures in the Risk Category Information API For Supplier Risk Exposure V1.

Overview

This section shows the available objects in the Supplier Data API and provides more information about using SQL with it.

Key Features

• The Cloud models SAP Ariba vendor entities such as suppliers, customers, and addresses 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 Cloud.

Views

Views are read-only tables that model SAP Ariba vendors.

Stored Procedures

Stored Procedures are function-like interfaces to the data source that perform tasks such as OAuth token management.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - SAP Ariba Source Views

Retrieve vendor address data email addresses.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM AddressEmailAddresses WHERE SMVendorId = 'S123456'

Columns

Retrieve vendor address data.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM Addresses WHERE SMVendorId = 'S123456'

Columns

Retrieve vendor address data fax numbers.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM AddressFaxNumbers WHERE SMVendorId = 'S123456'

Columns

Retrieve vendor address data phone numbers.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM AddressPhoneNumbers WHERE SMVendorId = 'S123456'

Columns

Retrieve vendor address data websites.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM AddressWebsites WHERE SMVendorId = 'S123456'

Columns

Retrieve vendor bank accounts.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM BankAccounts WHERE SMVendorId = 'S123456'

Columns

Retrieve vendor bank related data.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=,IN' comparison operators.
• ERPVendorId supports the '=,IN' comparison operators.
• VendorLastUpdateDate supports the '<=,<,=,>,>=' comparison operators.
• VendorRegistrationStatus supports the '=,IN' comparison operators.
• VendorQualificationStatus supports the '=,IN' comparison operators.
• VendorPreferredLevel supports the '=,IN' comparison operators.
• VendorBusinessUnit supports the '=,IN' comparison operators.
• VendorCategory supports the '=,IN' comparison operators.
• VendorRegion supports the '=,IN' comparison operators.

SELECT * FROM BankInfos WHERE SMVendorID = 'S123456'

SELECT * FROM BankInfos WHERE ERPVendorId = '1000003560'

SELECT * FROM BankInfos WHERE VendorRegistrationStatus = 'Registered'

SELECT * FROM BankInfos WHERE VendorQualificationStatus = 'Qualified'

SELECT * FROM BankInfos WHERE VendorPreferredLevel = 1

SELECT * FROM BankInfos WHERE VendorBusinessUnit = '408'

SELECT * FROM BankInfos WHERE VendorCategory = '51'

SELECT * FROM BankInfos WHERE VendorRegion = 'USA'

Columns

Retrieve vendor company code related details.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=,IN' comparison operators.
• ERPVendorId supports the '=,IN' comparison operators.
• VendorLastUpdateDate supports the '<=,<,=,>,>=' comparison operators.
• VendorRegistrationStatus supports the '=,IN' comparison operators.
• VendorQualificationStatus supports the '=,IN' comparison operators.
• VendorPreferredLevel supports the '=,IN' comparison operators.
• VendorBusinessUnit supports the '=,IN' comparison operators.
• VendorCategory supports the '=,IN' comparison operators.
• VendorRegion supports the '=,IN' comparison operators.

SELECT * FROM CompanyCodes WHERE SMVendorID = 'S123456'

SELECT * FROM CompanyCodes WHERE ERPVendorId = '1000003560'

SELECT * FROM CompanyCodes WHERE VendorRegistrationStatus = 'Registered'

SELECT * FROM CompanyCodes WHERE VendorQualificationStatus = 'Qualified'

SELECT * FROM CompanyCodes WHERE VendorPreferredLevel = 1

SELECT * FROM CompanyCodes WHERE VendorBusinessUnit = '408'

SELECT * FROM CompanyCodes WHERE VendorCategory = '51'

SELECT * FROM CompanyCodes WHERE VendorRegion = 'USA'

Columns

Fetch all the vendor contact details for the given vendors Ids.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=,IN' comparison operators.
• ERPVendorId supports the '=,IN' comparison operators.
• ACMId supports the '=,IN' comparison operators.

SELECT * FROM Contacts WHERE SMVendorId = 'S123456'

SELECT * FROM Contacts WHERE ERPVendorId = '1000005002'

SELECT * FROM Contacts WHERE ACMId = '1000005002'

Columns

Retrieve vendor customer information.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM Customers WHERE SMVendorId = 'S123456'

Columns

Retrieve vendor customer information sales arrangements.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM CustomerSalesArrangements WHERE SMVendorId = 'S123456'

Columns

Retrieve vendor identifications.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM Identifications WHERE SMVendorId = 'S123456'

Columns

Retrieve all inactive vendors.

Columns

Fetch vendor qualifications. Qualifications covers both qualifications (either supplier qualifications or process qualifications) and preferred category statuses.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=,IN' comparison operators.
• ERPVendorId supports the '=,IN' comparison operators.
• VendorLastUpdateDate supports the '<=,<,=,>,>=' comparison operators.
• VendorRegistrationStatus supports the '=,IN' comparison operators.
• VendorQualificationStatus supports the '=,IN' comparison operators.
• VendorPreferredLevel supports the '=,IN' comparison operators.
• VendorBusinessUnit supports the '=,IN' comparison operators.
• VendorCategory supports the '=,IN' comparison operators.
• VendorRegion supports the '=,IN' comparison operators.

SELECT * FROM Qualifications WHERE SMVendorID = 'S123456'

SELECT * FROM Qualifications WHERE ERPVendorId = '1000003560'

SELECT * FROM Qualifications WHERE VendorRegistrationStatus = 'Registered'

SELECT * FROM Qualifications WHERE VendorQualificationStatus = 'Qualified'

SELECT * FROM Qualifications WHERE VendorPreferredLevel = 1

SELECT * FROM Qualifications WHERE VendorBusinessUnit = '408'

SELECT * FROM Qualifications WHERE VendorCategory = '51'

SELECT * FROM Qualifications WHERE VendorRegion = 'USA'

Columns

Retrieve vendor questionnaires.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=,IN' comparison operators.
• ERPVendorId supports the '=,IN' comparison operators.
• VendorLastUpdateDate supports the '<=,<,=,>,>=' comparison operators.
• VendorRegistrationStatus supports the '=,IN' comparison operators.
• VendorQualificationStatus supports the '=,IN' comparison operators.
• VendorPreferredLevel supports the '=,IN' comparison operators.
• VendorBusinessUnit supports the '=,IN' comparison operators.
• VendorCategory supports the '=,IN' comparison operators.
• VendorRegion supports the '=,IN' comparison operators.

SELECT * FROM Questionnaires WHERE SMVendorID = 'S123456'

SELECT * FROM Questionnaires WHERE ERPVendorId = '1000003560'

SELECT * FROM Questionnaires WHERE VendorRegistrationStatus = 'Registered'

SELECT * FROM Questionnaires WHERE VendorQualificationStatus = 'Qualified'

SELECT * FROM Questionnaires WHERE VendorPreferredLevel = 1

SELECT * FROM Questionnaires WHERE VendorBusinessUnit = '408'

SELECT * FROM Questionnaires WHERE VendorCategory = '51'

SELECT * FROM Questionnaires WHERE VendorRegion = 'USA'

Columns

Retrieve vendor supplier accounting information.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM SupplierAccounting WHERE SMVendorID = 'S123456'

Columns

Retrieve vendor supplier information purchasing arrangements.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM SupplierPurchasingArrangements WHERE SMVendorId = 'S123456'

Columns

Retrieve vendor supplier information.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM Suppliers WHERE SMVendorId = 'S123456'

Columns

Retrieve all vendors contacts.

Columns

Retrieve vendor details.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=' comparison operator.

SELECT * FROM VendorDetails WHERE SMVendorId = 'S123456'

Columns

Retrieve all vendors.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• SMVendorId supports the '=,IN' comparison operators.
• ERPVendorId supports the '=,IN' comparison operators.
• RegistrationStatus supports the '=,IN' comparison operators.
• QualificationStatus supports the '=,IN' comparison operators.
• LastUpdateDate supports the '<=,<,=,>,>=' comparison operators.
• PreferredLevel supports the '=,IN' comparison operators.
• BusinessUnit supports the '=,IN' comparison operators.
• Category supports the '=,IN' comparison operators.
• Region supports the '=,IN' comparison operators.

SELECT * FROM Vendors WHERE SMVendorId = 'S123456'

SELECT * FROM Vendors WHERE RegistrationStatus = 'Registered'

SELECT * FROM Vendors WHERE QualificationStatus = 'Qualified'

SELECT * FROM Vendors WHERE LastUpdateDate > '2018-09-29T12:20:51Z' AND LastUpdateDate < '2019-10-04T12:20:51Z' 

SELECT * FROM Vendors WHERE PreferredLevel = 1

SELECT * FROM Vendors WHERE BusinessUnit = '408'

SELECT * FROM Vendors WHERE Category = '51'

SELECT * FROM Vendors WHERE Region = 'USA'

Columns

Stored procedures are function-like interfaces that extend the functionality of the Cloud beyond simple SELECT/INSERT/UPDATE/DELETE operations with SAP Ariba.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from SAP Ariba, along with an indication of whether the procedure succeeded or failed.

CData Cloud - SAP Ariba Source Stored Procedures

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 Cloud 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 Cloud.

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

The Cloud models the data in SAP Ariba as a list of tables in a relational database that can be queried using standard SQL statements.

CData Cloud - SAP Ariba Source Tables

Retrieve details about the specified sourcing project.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• ProjectId supports the '=' comparison operator.

SELECT * FROM Projects WHERE ProjectId = 'WS12345'

Update

You can update projects by executing UPDATE statements with a Project Id. For example:

UPDATE Projects SET Title='Sourcing Project',Status='Gray',State='Active',Currency='USD',Description='Sourcing Project' WHERE ProjectId = 'WS12345'

Columns

Retrieve teams information specified in a sourcing project.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• Id supports the '=' comparison operator.
• ProjectId supports the '=' comparison operator.

SELECT * FROM Teams WHERE Id = 'PG17371157'

SELECT * FROM Teams WHERE ProjectId = 'WS12345'

Update

The list of users and groups in a project team can be updated by executing UPDATE statements. Note that this Replaces all users or groups in the team with the users or groups specified in the request body.

Users and groups cannot be updated in the same statement.

For example:

UPDATE Teams SET Users='[{"uniqueName":"test","passwordAdapter":"pass"}]' WHERE ProjectId='WS12345' AND Id='PG14510'
UPDATE Teams SET ChildGroups='[{"uniqueName":"testGroup"}]' WHERE ProjectId='WS12345' AND Id='PG14510'

Columns

Retrieve team user information specified in a sourcing project.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• TeamId supports the '=' comparison operator.
• ProjectId supports the '=' comparison operator.

SELECT * FROM TeamUsers WHERE TeamId = 'PG17371157'

SELECT * FROM TeamUsers WHERE ProjectId = 'WS12345'

Insert

Users can be added to a specific project team by executing INSERT statements. A user is uniquely identified by a combination of uniqueName and passwordAdapter. For example:

INSERT INTO TeamUsers (UniqueName,PasswordAdapter, TeamId) VALUES ('testName','1234','100')

Columns

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - SAP Ariba Source Views

Gets IDs and header information for all documents in a specified sourcing project.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• InternalId supports the '=' comparison operator.
• ProjectId supports the '=' comparison operator.

SELECT * FROM Documents WHERE InternalId = 'Doc17975275'

SELECT * FROM Documents WHERE ProjectId = 'WS12345'

Columns

Gets all history specified in a sourcing project.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• ProjectId supports the '=' comparison operator.

SELECT * FROM History WHERE ProjectId = 'WS12345'

Columns

Retrieve task active approver users.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• ProjectId supports the '=' comparison operator.

SELECT * FROM TaskActiveApproverUsers WHERE ProjectId = 'WS12345'

Columns

Retrieve task approval requests.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• ProjectId supports the '=' comparison operator.

SELECT * FROM TaskApprovalRequests WHERE ProjectId = 'WS12345'

Columns

Retrieve task approver groups.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• ProjectId supports the '=' comparison operator.

SELECT * FROM TaskApproverGroups WHERE ProjectId = 'WS12345'

Columns

Retrieve all task approvers.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• ProjectId supports the '=' comparison operator.

SELECT * FROM TaskApprovers WHERE ProjectId = 'WS12345'

Columns

Retrieve all task comments attachments.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• TaskId supports the '=' comparison operator.
• ProjectId supports the '=' comparison operator.

SELECT * FROM TaskCommentAttachments WHERE TaskId = 'TSK17371161'

SELECT * FROM TaskCommentAttachments WHERE ProjectId = 'WS12345'

Columns

Retrieve all tasks comments of a specified task.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• TaskId supports the '=' comparison operator.
• IncludePreviousRounds supports the '=' comparison operator.
• ProjectId supports the '=' comparison operator.

SELECT * FROM TaskComments WHERE TaskId = 'TSK17371161'

SELECT * FROM TaskComments WHERE IncludePreviousRounds = 'true'

SELECT * FROM TaskComments WHERE ProjectId = 'WS12345'

Columns

Retrieve all tasks specified in a sourcing project.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• ProjectId supports the '=' comparison operator.

SELECT * FROM Tasks WHERE ProjectId = 'WS12345'

Columns

Retrieve team group information specified in a sourcing project.

View-Specific Information

Select

The Cloud uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The Cloud processes other filters client-side within the Cloud.

• TeamId supports the '=' comparison operator.
• ProjectId supports the '=' comparison operator.

SELECT * FROM TeamGroups WHERE TeamId = 'PG17371157'

SELECT * FROM TeamGroups WHERE ProjectId = 'WS12345'

Columns

Stored procedures are function-like interfaces that extend the functionality of the Cloud beyond simple SELECT/INSERT/UPDATE/DELETE operations with SAP Ariba.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from SAP Ariba, along with an indication of whether the procedure succeeded or failed.

CData Cloud - SAP Ariba Source Stored Procedures

Overview

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

Key Features

• The Cloud models SAP Ariba contract entities like terms, workspaces, and document properties 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 Cloud.

Views

Views are read-only tables that model SAP Ariba contracts.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - SAP Ariba Source Views