SSIS Components for SAP Ariba Source

Build 24.0.9060

TeamUsers

Retrieve team user information specified in a sourcing project.

View-Specific Information

Select

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

  • TeamId supports the '=' comparison operator.
  • ProjectId supports the '=' comparison operator.
For example, the following queries are processed server side:
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

Name Type ReadOnly References Description
TeamId [KEY] String False

Teams.Id

Specifies the unique identifier of the project group.

TeamName String False

Specifies the name of the project group.

TeamType String False

Specifies the type of the project group. Possible values- ProjectGroup, GlobalGroup.

Type String False

Specifies the user type.

Name String False

Specifies the full name of the user.

UniqueName [KEY] String False

Specifies the unique name of the user.

PasswordAdapter String False

Specifies the password adapter of the user.

EmailAddress String False

Specifies the email address of the user.

TimeZoneId String False

Specifies time zone for the user. Example: Asia/Kolkata.

Organization String False

Specifies the organization name of the user.

ProjectId [KEY] String False

Projects.InternalId

Specify the unique identifier of the sourcing project for which you want to fetch task details. Example, Try it out with: WS17371155.

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