Create type mapping

Define the mapping between data sources in a connection.

About types

A type is a system asset such as an epic, issue, requirement, task, or user story. When creating a connection, you must add at least one type to synchronize between your master and target data sources. For example, you may want to map a Broadcom Rally Central Hierarchical Requirement to a Story.

The types that are available to add to a connection are limited to the types that you added to your data source. If the type that you want is not listed, return to the Data Sources tab and add the type to the data source. For details, see Create a data source.

Note: If you save the connection before adding any types, you can then edit it and select which types you want. If you do not save the connection before pressing next (to go to the Types and Fields page), Micro Focus Connect will automap a preselected list of types and fields.

Back to top

Define type mapping in a connection

You define type mapping in the Connection Wizard, as a step in creating a connection, or later when editing a connection.

To define type mapping in a connection:

  1. In the connection wizard, click Next to open the Types and Field tab.
  2. In the Default Sync Direction list, select a direction for data synchronization. Synchronization between all types and fields will be performed in this direction. You can override this setting for specific types. Possible values for synchronization direction are:

    From Master Data is only synchronized from the master to the target.
    To Master
    Data is only synchronized to master from the target.
    Bi-Directional Data is synchronized both to and from the master and target. (This is the default.)
  3. You can allow Micro Focus Connect to automatically map the data sources' types and fields. Click Auto Type Mapping. Micro Focus Connect will attempt to auto-replace and map all types exposed by the selected data sources, and their fields. If you choose Type one, Connect resets the types that you see in the mapping to the types that are available in the auto-map.

    Caution: Mapping that you may have already manually input can be overwritten.

    If you want to set the type and field mapping manually, click + Type Mapping. The Add Type Mapping window opens. For more details, see Map types manually.

Back to top

Map types manually

If Micro Focus Connect cannot map the connection's types automatically, you can map them manually.

To add a manual type mapping:

  1. In the Types and Fields tab of the connection wizard, click + Type Mapping. The Add Type Mapping dialog box opens.
  2. The Target Type and Master Type fields list all the types that you exposed in the target and master data sources. Select the types to map from the target and master data sources.
  3. In the Direction field, select a direction for data synchronization. Select the "Inherit" option to use the default direction that was set in the main Types and Fields tab. For details, see Define type mapping in a connection.
  4. After selecting the types to map, you can now map the types' fields. Click Fields.

  5. You can allow Micro Focus Connect to automatically map the types' fields. Click Auto Type Mapping. Micro Focus Connect will attempt to map all fields between both types.
  6. To define a manual field mapping, click Add Field Mapping.
  7. Select fields in the target and master data sources to map with each other.

    For details on the field types that can be mapped, see Define type mapping in a connection.

    For details on mapping relationship fields, see Relationship mapping.

  8. Select the synchronization direction in the Direction list for each field. By default, the direction is inherited from the type mapping.
  9. In the Conversion field, in most circumstances leave the default "No Conversion" value.

    Apply one of the following values only after careful consideration:

    Master is HTML If the master side of a field mapping contains HTML-formatted content and you want, or are allowed only, plain-text content in the target. This setting converts the HTML content in master to plain-text content in target.
    Target is HTML If the target side of a field mapping contains HTML-formatted content and you want, or are allowed only, plain-text content in the master. This setting converts the HTML content in target to plain-text content in master.
    Apply user map If neither side of the mapping is a user property, you can apply the user map by selecting this option.
    No Conversion The field data is not altered when synchronizing.
  10. If the fields you are synchronizing use different values, create a value map. For more details, see Create value maps.
  11. Click the OK button to save your mappings and close the Add Type Mapping dialog box.

Back to top

Relationship mapping

In addition to mapping attribute fields between types, you can also map relationship fields.

A relationship field defines the link between two types in a data source. For example, in ALM Octane, a story is linked to a feature via the story's Feature field.

Micro Focus Connect provides the ability to synchronize those relationships between data sources. For example you can map and synchronize the ALM Octane story-to-feature relationship with a similar story-to-epic relationship in Jira.

Considerations for relationship mapping

  • The relationships in either data source may not be the same type. For example, ALM Octane's story-feature relationship is a parent–child relationship. Whereas most relationships in Jira are many–many relationships.
  • Where there can be an ambiguity between relationship and attribute fields, Micro Focus Connect represents the relationship as a field with the prefix “link”.

    For example, in the list of Jira story fields, there is a fixVersions field. This is a regular attribute field that is populated in Jira by a plain string. Micro Focus Connect adds a link.fixVersions field that represents the story's relationship to a virtual fixVersion entity. This allows you to treat Jira's fixVersions like an ALM Octane release.

Back to top

Mapping children links

Micro Focus Connect supports mapping links (relationships) between items from one endpoint type to another provided that the item types are mapped. For example, to synchronize ALM/QC defect Release and Release Cycle links with Jira Release and Sprint links, you must map the Release to Release and the Release Cycle to Sprint types in that connection.

In most cases , the default behavior of this mapping updates or creates the desired fields. Make sure to consider the architectural differences of the endpoint types. For example, unlike ALM/QC, Jira sprints are not linked to Jira releases. In addition, unlike ALM/QC, in Jira, start and end dates are not mandatory fields.

If you do not want to synchronize the parent types, such as sprint, release, release cycles, and iterations, but you want to synchronize the links for child types, such as defects, bugs, or requirements, use one of the following methods:

Map by name

Map by name incorporates Micro Focus Connect's custom utilities. Micro Focus Connect provide utilities to map ALM/QC to Jira, ALM to Azure DevOps, ALM Octane to Jira, ALM Octane to Azure DevOps, and ALM/QC to ALM/QC by name.

For this method, you must create the fields, such as sprints, releases, release cycles, and so forth, on the endpoint systems, in the relevant projects. You must also make sure that the field names are identical as they are case-sensitive.

These utilities run directly on the endpoint systems and perform the following steps:

  1. Query the Micro Focus Connect database and find the supported types in all projects in all of the running connections.

  2. Match the entities of these types by name.

  3. Retrieve the IDs and write them into the Micro Focus Connect database as cross references.

These utilities can be integrated into a nightly purge script, so that they run when the Micro Focus Connect service is down. This serves as a scheduled catch-up for changes made to the matching artifacts. For information about the utilities, contact support.

Manually map

Manual mapping is an alternative method that the Micro Focus Connect configuration engineer can deploy. With this strategy, names are not used.

The Micro Focus Connect administrator should:

  1. Determine the matching values, for example the Jira release corresponding to the ALM/QC Release, the Jira sprint that matches the ALM/Octane release cycle, and so forth.

  2. Import or insert the cross references as <adds> pairs directly into the Micro Focus Connect database. For details, see Manage cross references.

Additional guidelines

To ensure the success of the above methods, Micro Focus Connect must be prevented from synchronizing while mapping the types. For example, your admin should only map the ALM/QC Release type to the Jira Release type and the Release Cycle type to the Jira Sprint type, but explicitly exclude all of these types' properties.

This approach, mapping types without properties, allows Micro Focus Connect to load the cross references into memory from its database without creating or updating the artifacts on either side. This approach also allows control at the connection level.

An alternative approach is to set the type to ReadOnly at the data source level. This approach however, will affect all connections associated with the data source.

Note: When mapping links using calculated values, you must use the FindFirst function. For details, see Functions.

For example, you cannot set a calculated value using this syntax:

set Release = 123456

Instead, use the following syntax:

set Release = FindFirst(Release) where ID equals 123456

Back to top

Create value maps

If you have mapped two select-list fields, you need to make sure that the fields' values are also mapped.

A value map defines how a field value in Product A maps to a field value in Product B.

To define value maps:

  1. In the connection wizard's Types and Fields tab, expand a type mapping. The types' fields are listed.
  2. Click the Edit value map button . The Value Maps dialog box opens.
  3. Click Auto Value Mapping to allow Micro Focus Connect to map the field values automatically, or + Value Map to map the values manually.
  4. On each row, select a value in the master's field to map to the corresponding value in the target's field.

It is possible that the field in Product A has more values than the equivalent field in Product B. In this case, you need to map more than one value in Product A to the same value in Product B.

Example:

Product A Product B
New Open
In Progress Open
Done Closed

The last value in Product A that is mapped to the same value in Product B will appear in bold (see above). This indicates that, when changes are synchronized from Product B to Product A, the "Open" in Product B will translate to "In Progress" in Product A, and not to "New".

Back to top

Supported field type mappings

The following table lists the supported field type mappings:

Field type Maps to types
datetime datetime, richtext, string, date
boolean boolean, richtext, string, enum
item item, string
long long, richtext, float, int, double, string, long
richtext richtext, datetime, float, boolean, int, double, enum, date, string, user, long
float float, richtext, int, double, string, long
int int, richtext, float, double, string, long
double double, richtext, float, int, double, string, long
attachment attachment
comment comment
enum enum, richtext, enum, string, boolean
date date, richtext, datetime, date, string
string string, richtext, datetime, float, boolean, int, double, enum, date, string, user, long
user user, string, richtext

string - date/time conversion

A string containing a datetime value should follow the syntax below:

"yyyy-MM-dd" + optional("'T'HH:mm:ss" + optional(".nnnnnnnnn")) + optional("+2:00" + optional('[Region/Zone]'))

Using this format, the string will be converted to an ISO date/time format.

Back to top

Mapping multiple types to a single type

When mapping two or more types from one endpoint to a single type endpoint, the receiving endpoint must be able to distinguish between the types in the syncsets.

For example, consider a case where a Jira Story and a custom type called "Jira Support" are both mapped to an ALM Octane story type. The Jira Support type is mapped uni-directionally to the ALM Octane story, while the Jira Story is mapped bi-directionally to the ALM Octane story.

In this case, the receiving endpoint, ALM Octane, must be able to distinguish between stories syncing from the Jira Support type and stories syncing to/from the Jira Story type.

To enable the receiving endpoint to make this distinction:

  1. Add a custom field to the target endpoint type, the ALM Octane story. The field can be a Boolean type, for up to two cases, or a string/list for three or more type cases.
  2. When mapping to the ALM Octane story, make sure that the Master Calculated Value is set to the correct value:

    • False: for the Jira Support type
    • True: for the Jira Story type
  3. When reading the ALM Octane stories, set the Master Sync Criteria to accept only stories with the value set in the following way:

    • False: for the Jira Support – Jira Story syncset
    • True: for the Jira Story – Jira Story syncset

These steps ensure that only relevant ALM Octane stories are considered when processing each syncset, and the ALM Octane stories do not overlap across the two syncsets: the Jira Story–ALM Octane syncset and the Jira Support–ALM Octane story syncset.

Back to top

Additional type mapping guidelines

This section lists several guidelines that apply when mapping types.

  • You can maintain relationships between types. Micro Focus Connect surfaces the relationships as fields in the mapping for a type in a connection. First you choose the relationship field in one product, and then choose the relationship in the other product.
  • Micro Focus Connect will not reflect changes in types. Therefore it will not convert a story to a defect or vice versa. Most products do not support changes in types. Micro Focus Connect will create a parallel item in the new type, provided the new type is configured in a connection.
  • You can map any type, such as a story, defect, and so forth, in one product to any type in another product.
  • For any given type mapped for a connection, the required fields for that type are displayed in red. An error message will indicate that the synchronization may fail if an artifact is being created on the type without the required field. You can ignore this warning if the synchronization direction is uni-directional, with data flowing out from the type whose fields are displayed in red. In this case, none of the required fields of the type should appear in the mapping, and the warning message can safely be ignored.

Back to top

Next steps: