Databases Reference
In-Depth Information
Testing XML to Data Object mappings
The purpose of this testing is to verify the functionality of XML to Data Object
mappings. In many cases, business field definitions in upstream data sources
are different than BAM Data Object field definitions. So you should always keep
the data accuracy and validation in mind, when testing XML to Data Object map-
ping.
Consider the following rules when preparing test data:
•
Data constraints:
Follow the data constraints in the upstream data source.
For example, the
unique
constraint, and the
Nullable
constraint
•
Data field format:
The
data
field format should comply with the upstream
data source format definition
•
Data precision:
Use the data precision defined in the upstream data source
To verify the test result, you can either review the newly-updated records in the
BAM Architect web application, or you can build an SQL query to query the BAM
Data Object underlying database table (called
dataset
in BAM). Using the
SQL approach is more realistic, especially when the Data Object contains thou-
sands of records.
You can find a Data Object's dataset name in the BAM Architect Web applica-
tion. As shown in the following screenshot,
_Order1
is the dataset name for
the
Order
Data Object:
