uCosminexus Service Platform, Basic Development Guide
To transform the formats of data acquired using the database adapter:
The following is a description of each of the steps:
To transform the formats of the data acquired using the database adapter, use the data transformation definition.
In the Data Transformation Definition screen, set up the data acquired using the database adapter in the transformation source schema tree viewer and the XML schema with the post-transformation format in the transformation destination schema tree viewer.
In the DBA_ResultSetName element of the response message, the column name and the ID (cid attribute) are stored in pairs. Use the trim node function to acquire the cid attribute corresponding to the column name specified in the node conditions.
To acquire the cid attribute value of the column name:
Map the loop node function from the DBA_ResultSet element of the transformation source to the record element of the transformation destination. For details about how to define the loop node function, see 6.5.16 Mapping Looping.
Assign a value to each row name element at the transformation destination. In this case, set up the conditions such that the trim node function defined in (2) Acquiring the cid attribute value of the column name matches the cid attribute under the DBA_ResultColumn element.
To assign a value to each row name element of the transformation destination:
Validate whether the defined mapping is consistent. For details about the validation method, see 5.10.2 Validation Method.
All Rights Reserved. Copyright (C) 2015, Hitachi, Ltd.