Configuration Details for Adding IDM Items

An example SBM Item configuration is provided for associating Sample DB IDM items with Release Control requests.

Note: The example configuration requires the Sample DB IDM process app.

Field Descriptions

The field descriptions are included in the UI. While creating or editing a base or configuration, point to a field name to view its description.

A few fields that may need additional explanation are described in the following table.

Field Description Example Values
SBM Web Services

URL for the SBM application web services

http://<serverName>:80/gsoap/gsoap_ssl.dll?sbmappservices72
Use Single Sign-On (SSO)

Select single sign-on to allow the provider service to log in to the SBM system using the authentication token of the user.

Note: If you are logging into a separate SBM system that doesn't share the same SSO server, you will receive the following message "An error occurred while getting collection details" when trying to find an item on the other system.
true
Open in Work Center Select to open the item in Work Center.
SBM Table (DBNAME)

The database table name of the SBM table in which you want to submit or transition execution items

TRM_RLM_BUSINESS_REQ
Extended Fields

A comma-separated list of fields to populate with data when submitting or transitioning items. The values are the database names for the fields. See Using Extended Fields to Format Request Data.

Query Where Clause

A SQL query where clause that is used to search fields to return the list of possible requests to relate. See the SBM documentation about the GetItemsByQuery call for more information.

TS_PROJECTID=@<PROJECTID> AND (TS_TITLE LIKE N'%@<SEARCHTERMS>%' OR TS_DESCRIPTION LIKE N'%@<SEARCHTERMS>%')
Order By Clause

A SQL statement to order the results of the query. Use this statement to place newest items first in the list or to divide them up based on projects. See the SBM documentation about the GetItemsByQuery call for more information.

TS_SUBMITDATE ASC