Provisioning Tool Guide

10.4 HotFix 2
- 10.5 HotFix 3
- 10.5
- 10.4 HotFix 3
- 10.4 HotFix 1
- 10.4
- 10.3 HotFix 3
- 10.3 HotFix 2
- 10.3 HotFix 1
- 10.3

Back Next

Transforming XML Data to Business Entity

To use the DaaS services, you must define the mappings for the response that the service returns. Map the fields in the response to the business entity fields. Specify which fields from the XML output of the service you would like to store in your business entity.

Click

Business Entity

Transformations

, and then select

XML to Business Entity

Click

Create

In the properties panel, specify the following properties:

Property	Description
Name	Name for the transformation.
URL	Identifies the namespace where the SOAP operation is defined.
Type	Select the namespace.
Business Entity	Business entity you want to transform.
Expose As Service	If set to true, the transformation is exposed as two business entity services, Import and Update. These services accept XML data, transform it into business entity data, and save it as a business entity record.
Source	Element in the response object. Click the Browse button to search for the element.

Click

Apply

The following image shows a sample XML data to business entity transformation: A screenshot showing sample XML data to business entity transformation.

A screenshot showing sample XML data to business entity transformation.

To configure the transformation for the root node, select

Transformations

in the tree view panel, and then click

Create

In the properties panel, specify the following properties:

Property	Description
Name	Name for the transformation. For example, transformation for root.
Status Output	Name of the cleanse output parameter. Used in cleanse transformations. Not applicable to transformations for DaaS.
Status Success	A regular expression. When the cleanse operation successfully completes, it returns a value in the cleanse output parameter that matches the regular expression. Not applicable to transformations for DaaS.
Type	Type of transformation to directly map data from a business entity field to the XML. Direct transformations keep the data unchanged.

Map the XML elements in the service response to the business entity fields:

In the

Input Fields

column, click the

Browse

button.

Select the field, and then click

Select

In the

Output Fields

column, click the

Browse

button.

Select the business entity field to which you want to map, and then click

Select

To map additional information, click the

Add

icon, and then follow steps

Click

Apply

The following image shows a sample mapping of fields for the root node:

A screenshot showing the mapping of XML and business entity fields.

To configure the transformation for child nodes of the business entity, add the node to a group, and then configure the transformations:

Select the

Groups

folder, and then click

Create

In the properties panel, enter a name for the node as you want it to appear in the group folder.

In the

Source

field, select a field, and in the

Target

field, select the child node in the business entity. Repeat for each child node.

Click

Apply

Expand a

child node

, select

Transformations

, then click

Create

In the properties panel, enter a name for the transformation.

From the

Type

list, select

Direct

In the

Input Fields

column, click the

Browse

button.

Select the field, and then click

Select

In the

Output Fields

column, click the

Browse

button.

Select the business entity field to which you want to map, and then click

Select

You can specify Service Data Object (SDO) XML path directly in a

field

attribute. When a field contains

, it indicates the XPath of the SDO. If you use a cleanse transformation before you populate the business entity with the XML data, you might require some parent XML elements in the child node mappings. However, parent XML elements are not available for selection in the transformation of child nodes. You must manually type the path to the required parent XML element in the

Field Name

. Use the Service Data Object (SDO) XPath expression to access a parent element, where

represents the root element. For example, when you configure the transformation of the address child node, you might concatenate the

dunsNumber

element with the

city

element. Because the

dunsNumber

element is a parent element, it is not available for selection. To access the

dunsNumber

element, use the path

/OrderCompanyProfileResult[1]/ServiceResult[1]/OrderProductResponseDetail[1]/InquiryDetail[1]/DUNSNumber[1]

Repeat Steps

for other fields.

Click

Apply

Repeat Step

for each child node.

The following image shows a sample transformation and mapping of fields for a child node:

A screenshot showing the mapping of XML fields to business entity fields for the child addr.

Rename Saved Search

Table of Contents

Provisioning Tool Guide

Provisioning Tool Guide

Transforming XML Data to Business Entity

Transforming XML Data to Business Entity