To enable real-time cross-team collaboration, you need to connect Solutions Business Manager (formerly known as Serena Business Manager) to other ALM systems. Planview Hub makes it happen by taking information once trapped in software delivery silos and synchronizing it into SBM. This provides unified reporting and governance from within SBM, and extensive visibility and traceability across the lifecycle. These integrations allow for a dramatic increase in productivity through cross-team collaboration across diverse ALM tools, and unified reporting, traceability and centralized governance from within SBM.
Organizations can also extend the reach of SBM into artifacts within other tools. Hub enables system administrators to define how SBM artifacts are mapped to third party fields, by describing workflow transitions and field transformations.
Planview Hub: 18.3 and later
Tasktop Sync: 4.15 and later
Repository Version: Any supported version of SBM 11.2 and later, with Release Control Plug-in (RLC) 6.2.1
The Solutions Business Manager connector supports Release Packages and Release Trains in the Release Control Plug-In (RLC).
Note: In order to support Deployment Path for Release Packages and Release Trains, users will require permission to Run Guest-Level Reports.
This section describes the basic steps needed to prepare your Solutions Business Manager instance for use with Hub. Note that additional fields for synchronization or configuration of queries may be required depending on the requirements of your integration.
We recommend that you create a new user within your external tool, to be used only for your Hub integration. This is the user information you will enter when setting up your repository connection within Planview Hub. By creating a new user, you will ensure that the correct permissions are granted, and allow for traceability of the modifications that are made by the synchronization.
In general, your user account should have sufficient permissions to create, read, and update artifacts in your repository. However, depending on the use case, your user may need different permissions. For example, if you are only interested in flowing data out of your repository, your user may not need to have full CRUD access, as the 'create' and 'update' permissions may not be needed.
Your user should have a secure password or token. Please be aware that Hub will not allow you to save a repository connection utilizing a weak password/token, such as 'tasktop.'
Before creating a connection to the Solutions Business Manager repository, a user with the necessary permissions must be created if one does not exist already. Follow the steps below to create a user with the necessary permissions for use with the connector:
Note: Additionally for the Release Control Plug-In (RLC), in order to support Deployment Path for Release Packages and Release Trains, users will require permission to Run Guest-Level Reports.
Standard Authentication
Required Fields:
Optional Fields:
Learn more about how to set up your repository in Planview Hub here.
What is Proxy Association Attribute?
A custom string attribute is recommended to be used as the proxy association storage. Tasktop Sync needs to keep track of the association between a task and its proxy task. The association is persisted in a proxy store allowing the synchronization to be restored if there is any catastrophic failure of Tasktop Sync.
A proxy association attribute must be created for each artifact type to be synchronized.
The Proxy Association Attribute field must be a text/string type field in your ALM repository. We recommend creating this field with the name "Tasktop Sync Proxy."
A proxy association attribute must be created for each artifact type to be synchronized. The Proxy Association Attribute field must be of type Text SBM. Usually the custom field is created with the name Tasktop Sync Proxy.
To create a custom field within a SBM project:
The new attribute will not be visible in the UI by default. It is not necessary for it to be visible for the Solutions Business Manager connector to work correctly. However, if you wish to make this attribute visible, you may do so by switching to the Visual Design view and adding it to the appropriate form.
Tasktop Sync uses queries in the ALM systems to determine the artifacts to synchronize and detect changes in the system.
The initialization query represents the full set of artifacts to synchronize and is only run on initial configuration or manually.
The changes query should be defined the same as the initialization query but include some time scoping information (e.g. last 7 days) as this is the query that is executed on the defined schedule to detect changes. In many cases, these queries can be defined in the ALM system, providing the power of the built-in filters to properly scope the synchronization. If this is not possible, Tasktop Sync provides other mechanisms for filtering items in scope.
The Solutions Business Manager connector has two available types of queries. Report queries search for artifacts based on a predefined report. Only reports that the user has access to can be used in a Report query. Project queries search for artifacts of the specified type in a project.
Query |
Instruction |
---|---|
Initialization Query |
You can choose to use a project based query if you want to retrieve all items in a particular project. For more defined, precise filtering, you can choose to use report based queries. Note that:
Once you have saved the report in SBM repository, you can retrieve it via Tasktop Sync. |
Changes Query |
For changes query, you can use the same report that you created above or create a new one and add a "last modified" filter in the UI. You can add this by editing a report and adding a search filter.
|
In Solutions Business Manager, all attached content is regarded as an "attachment". Therefore, attachments of type "Note" will be treated as comments, and incoming comments will be recorded as "Note" type attachments.
Learn more about how to configure comment flow in Planview Hub here.
In Solutions Business Manager, attachments are just another type of attached content. Two types of attachments are supported and synchronized as attachments:
File
Learn more about how to configure attachment flow in Planview Hub here.
With the Solutions Business Manager connector, you can integrate links among various systems.
More specifically:
Note: Sub-Relational is not a simple ARM case. By adding a sub-relational field, Hub will retrieve additional values from an artifact that is linked through single or multi-relational link. Hub does not support retrieving of more than just a name and the URL of a linked artifact.
All customizations happen in the "SBM Composer" application. For any addition/changes to the data schema, you must deploy the application to see the changes in Hub.
For person reconciliation, the following fields are available:
Fields Used for Hub’s Default Person Reconciliation Algorithm |
Field Names for Person Reconciliation Extensions (Note that these are case sensitive) |
Label in Solutions Business Manager |
---|---|---|
ID |
person-id |
ID |
Username |
person-username |
User Name |
|
person-email |
Email Address |
N/A |
phoneNumber |
Phone Number |
N/A |
person-display-name |
Display Name |
Learn more about how to configure person reconciliation in Planview Hub here.
Due to third party API limitations, updates to the following fields may not trigger change detection or cause a synchronization immediately. To ensure these updates synchronize, a high fidelity full scan must occur or another qualifying change must be made to the artifact:
Learn more about how to configure change detection and full scan intervals in Planview Hub here.
You can learn more about special features in Planview Hub here.
Feature |
Custom Type Supported? |
Applicable Hub Versions |
Applicable Repository Versions |
---|---|---|---|
Time Worked (Worklogs) Impersonation |
|
|
|
Comments Impersonation Public/Private |
N/A |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Attachments Impersonation |
N/A |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
State Transitions |
N/A |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Learn about the difference between containers and work items in Planview Hub here.
Supported Work Item Type |
Applicable Hub Versions |
Applicable Repository Versions |
Unique URL? |
---|---|---|---|
Issue |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Yes |
Change |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Yes |
Any custom made artifact that is based on the primary table (Does not apply to SBM Release Control Plug-in) |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Yes |
Release Packages (SBM Release Control Plug-in) |
Planview Hub: 18.3 and later Tasktop Sync: 4.15 and later |
Any supported version of SBM 11.2 and later, with Release Control Plug-in (RLC) 6.2.1 and later |
Yes |
Release Trains (SBM Release Control Plug-in) |
Planview Hub: 18.3 and later Tasktop Sync: 4.15 and later |
Any supported version of SBM 11.2 and later, with Release Control Plug-in (RLC) 6.2.1 and later |
Yes |
Auxiliary Item: SCM Associations - only available for Gateway scenarios |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
|
Learn more about containment in Planview Hub here.
Containers that can synchronize between repositories |
Applicable Hub Versions |
Applicable Repository Versions |
Unique URL? |
---|---|---|---|
N/A |
|
|
|
Containers used to define the boundary of a collection (When clicking 'Manage Projects' on a Collection) |
|
|
|
Projects |
Planview Hub: All |
Any supported repository version: |
N/A |
Containers used for artifact routing |
|
|
|
Projects |
Planview Hub: All |
Any supported repository version: |
N/A |
Note: If one field of a given type is supported, others that are also that type in theory should also work. However, sometimes there are instances in which this is not the case due to the repository. So, while we can claim support for fields at the type level, there is a chance that some specific fields of a given type will not synchronize properly.
Standard Field Type |
Does Hub support custom fields of this type? |
How is field type referenced in the repository? |
Sample Repository Fields Supported |
Particular Repository Fields NOT Supported |
---|---|---|---|---|
String |
|
Text (Fixed length string option) |
Item ID Found in Version Revision Formatted ID |
|
Single Select |
|
Selection and Binary (List box and radio button) |
Severity Resolution Reproductible Priority Type How found Project |
Current Scheduled Item |
Multi Select |
|
Multiple Selection |
|
|
Boolean |
|
Binary (checkbox) |
Regression Active/Inactive |
|
Date |
|
Date/Time (Date only option) |
Submit Date Est Date to Fix |
|
Date Time |
|
Date/Time (Date and time option) |
Close Date Last Modified Date |
|
Duration |
|
Date/Time (Elapsed time option) |
|
|
Double |
|
Numeric (Floating point, Fixed precision) |
Est Time to Fix Actual Time to Fix |
|
Long |
|
Numeric (Integer), Summation |
|
|
Person |
|
User |
Modifier Owner Developer |
|
Persons |
|
Multi-User |
|
|
Relationship(s) Learn how to configure relationships in Planview Hub here. |
|
|
Single Relational Fields Multi-Relational Fields Subtask Links (read-only) Item Links |
|
Rich Text |
|
Memo field |
Description |
|
Web Links |
N/A |
Web link/Link |
Web Links |
|
Other |
|
|
|
|
Category |
Limitation |
Applicable Hub Versions |
Applicable Repository Versions |
---|---|---|---|
Good to Know |
Dates The minimum value for dates and datetimes in SBM is January 1st 1970. |
Planview Hub: 21.1 and later Tasktop Sync: 4.25 and later |
11.7 |
Configuration Requirement |
Repository Queries When using repository queries, you will need to ensure that the query is sorted by 'Last Modified Date' in descending order. If you do not do this, Planview Tasktop Hub will not function properly. |
Planview Hub: All |
Any supported repository version: |
Third Party API Limitation |
Relational Fields The Relational Field, 'Current Scheduled Item', is a read-only text field. |
Planview Hub: 19.1 and later Tasktop Sync: 4.17 and later |
Any supported version of SBM 11.1 and later |
Third Party API Limitation |
Sub-Relational Fields Sub-Relational fields are read-only. In addition, Sub-Relational fields with a data type that would normally be considered 'single select' are instead supported by the connector as text fields |
Planview Hub: 19.1 and later Tasktop Sync: 4.17 and later |
Any supported version of SBM 11.1 and later |
Third Party API Limitation |
Release Train Projects Hub supports the Release Train projects that come pre-configured with RLC: Deployable Release Trains and Planning Release Trains. SBM workflow scripts differ between these projects and cause differing changes to the work item fields. Therefore it is recommended that users ensure that each Tasktop collection for Release Trains uses only one project to ensure that the fields for each collection are valid. If necessary, a Release Train collection can include both projects. Note that the Release Type and Deployment Path fields are required on Deployable Release Trains, but not Planning Release Trains, and the options for the State field differ between the projects. |
Planview Hub: 18.3 and later Tasktop Sync: 4.15 and later |
Any supported version of SBM 11.2 and later, with Release Control Plug-in (RLC) 6.2.1 and later |
Third Party Functional Limitation |
Release Train / Release Package Relationship SBM restricts Release Packages from having both a parent package relationship and a release train relationship. Because Tasktop cannot enforce this restriction, the Release Train relationship for the Release Package work item and the Release Packages relationships for the Release Train work item are both read-only. |
Planview Hub: 18.3 and later Tasktop Sync: 4.15 and later |
Any supported version of SBM 11.2 and later, with Release Control Plug-in (RLC) 6.2.1 and later |
Configuration Requirement |
Parent/Child Packages The parent/child package relationship is only editable via the Parent Package field on Release Packages |
Planview Hub: 18.3 and later Tasktop Sync: 4.15 and later |
Any supported version of SBM 11.2 and later, with Release Control Plug-in (RLC) 6.2.1 and later |
Configuration Requirement |
State Transitions The Message Log field is available only for submitting updates to state transitions. |
Planview Hub: 18.3 and later Tasktop Sync: 4.15 and later |
Any supported version of SBM 11.2 and later, with Release Control Plug-in (RLC) 6.2.1 and later |
Good to Know |
Auto-Generated Message Logs Hub submits an auto-generated message log entry which reads 'Parent package removed' any time the Parent Package value is removed or changed (because RLC requires a message log to be submitted). |
Planview Hub: 18.3 and later Tasktop Sync: 4.15 and later |
Any supported version of SBM 11.2 and later, with Release Control Plug-in (RLC) 6.2.1 and later |
Configuration Requirement |
Single Select / Multi Select Relational fields which reference auxiliary tables are implemented as single- or multi-select fields for SBM versions 11.1 and later. For SBM versions earlier than 11.1, no support exists for these fields. Privileges to view the referenced table are required in order for the field to appear in the list of available fields for a work item. |
Planview Hub: 18.3 and later
|
Supported Versions 11.1 and later |
Third Party API Limitation |
State Transitions Some transitions are not supported. For transitions that require field values, Hub can only support transitions with field values that can be mapped. For example, SBM 10.1.2 cannot map single selects because it cannot look up options for single selects, so many IDM transitions are not supported: Evaluating Issue to Fixing Issue requires Severity and Priority single select values, and Fixing Issue to Testing Issue requires a Resolution single select value. Most field values are supported in 4.1 and 10.1.5, but there are a still a small number that are not. |
Planview Hub: All Tasktop Sync: 4.1 and later
|
Any supported repository version: |
Third Party API Limitation |
Selection Options Selection options are not available and only one way sync can be done with single select and multi select. SBM does not have API for retrieving list of selection options until version 10.1.5. This means that value mapping can not be set up when syncrhonizing a single select or multi select field. Only one way syncing (from SBM to another repository) is possible for version before 10.1.5 since single select and multi select fields are only readable and not writable and value mapping would not be possible. |
Planview Hub: All Tasktop Sync: 4.1 and later |
10.1.2, 10.1.3, 10.1.4 |
Third Party API Limitation |
Empty Values Setting an empty value is silently ignored for a binary field. SBM does not allow empty value for binary/trinary fields. Update to an empty value silently fails and the value remains the same as before the update. |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Third Party API Limitation |
Maximum Length Value silently truncated when too long for a fixed length string, but less than 255 characters. SBM does not return an error message when a value is too long for the field it's being set to. Instead, the value is just truncated. Since 255 is known to be the maximum length that can be given to a fixed length field, the connector validates that the string is less than that and throws an error if not. However, the field may have a maximum length less than 255 and that information is not available in the API. When a value is set in that's longer than the field max, but shorter than 255, no error will occur and the value will be truncated. |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Third Party API Limitation |
Mid-Air Collision Support Limited mid-air collision support. SBM does not detect mid-air collisions. Generally, we will retrieve the artifact before updating to check for collisions, but there's still a window in which an overwrite may occur |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Third Party API Limitation |
Deletion Deleting a non-existent artifact fails silently. SBM API does not return an error when attempting to delete an artifact that doesn't exist. This limitation is not exposed currently in the product, but listed here in case that changes as we move to Tasktop Platform. |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Configuration Requirement |
Reports Reports must be listings, must not require input when run and must return 'Last Modified Date' and 'Title' columns. SBM reports are customizable. In order for reports to work in Hub, they must be of type 'Listing'. They should also not require the user to enter parameters at run-time, since Hub will be automatically running the query. The reports must also display information needed by Hub, found in the 'Last Modified Date' and 'Title' columns. |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Configuration Requirement |
Reports Reports must sort results by 'Last Modified Date' descending. For Hub data support, queries must be sorted by modification date. |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Third Party API Limitation |
Relationships Subtask links (both parent and child links) are read-only. SBM only has API support for adding subtask links, but is missing API support for removing subtask links. Without that, full support for subtask links can't be implemented. Instead, subtask links are exposed from SBM and can be propagated to the other repository, but no changes can be synchronized into SBM from another repository. |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Third Party API Limitation |
Duration Fields Hub cannot update a non-empty duration field to an empty value. Values cannot be updated to be empty, but can be updated to 0 |
Planview Hub: All Tasktop Sync: 4.1 and later |
Any supported repository version: |
Configuration Requirement |
Display Names Administrator privileges are necessary to retrieve the display name for users. There is a bug in 10.1.2 where display names are not returned in the artifact data. In order to retrieve display names from the user list, the user must be an administrator with Global Administration and Add/Edit/Delete User privileges. Lack of a display name will not affect the functioning of Sync, but may mean the login id is used in place of the display name in the task editor and potentially in Data/Link (if the display name is used in either) |
Planview Hub: All Tasktop Sync: 4.1 and later |
10.1.2 |
Configuration Requirement |
Calculated Field Columns Default calculated field columns must not be included when creating a new listing report. SBM shows 7 default calculated field columns as possible display items to the user when creating a new listings report - if included these will generate unknown SOAP errors. However, user defined calculated columns do not generate any issues. |
Planview Hub: All Tasktop Sync: 4.1 and later |
10.1.5, 11.0, 11.0.1.1, 11.1, 11.2 |