webMethods, OneData, and Terracotta  10.2 | Managing Master Data with webMethods OneData | Implementing webMethods OneData | Objects in OneData | Creating A Data Object | OneData XML And ARIS AML Mapping
 
OneData XML And ARIS AML Mapping
The mapping between the values specified for Object Type in the common OneData XML for Import Model and the corresponding information source in the ARIS AML file is given below.
ObjectType In Common OneData XML
Corresponding Information in ARIS AML file
Table
TypeNum=”OT_ENT_TYPE”
Column
TypeNum=”'OT_ERM_ATTR”
Mapping between the values specified for the table, column, and constraint level properties in the common OneData XML for Import Model and the corresponding information source in the ARIS AML file is listed in the following table.
Value In Common OneData XML
Corresponding Value in ARIS AML file
<ID>
Element within <TABLE> or <COLUMN> or <CONSTRAINT>
ObjDef.ID
Unique Identifier specified in the ARIS file
<NAME>
Element within <TABLE> or <COLUMN> or <CONSTRAINT>
AttrDef.Type=”AT_NAME
Mandatory Attribute link to Logical Name and Physical Name of Table, Column and Constraint
<DESCRIPTION>
Element within <TABLE> or <COLUMN>
For <TABLE>: AttrDef.Type=”AT_DESC”
For <COLUMN>: AttrDef.Type=”AT_DESC_VALUE”
Optional Attribute linked to Data Object Definition or Column Description.
<DATA_TYPE>
Element within <COLUMN>
AttrDef.Type=”AT_SQL_DATA_TYPE”
Mandatory Attribute linked to the OneData Column Property: Datatype.
<LENGTH>
Element within <COLUMN>
AttrDef.Type=”AT_LEN_1”
Attribute linked to the OneData column property: Length. Mandatory for columns of datatype Varchar and Char
<DECIMAL_ DIGIT>
Element within <COLUMN>
AttrDef.Type="AT_DEC_DIGIT"
Optional attribute linked to the OneData column property, precision
<DEFAULT_ VALUE>
Element within <COLUMN>
AttrDef.Type="AT_DEFAULT_VALUE”
Optional Attribute linked to the OneData Column Property: Default Value
<IS_ NULLABLE>
Element within <COLUMN>
AttrDef.Type="AT_OPT_ATTR"
Optional Attribute linked to the OneData Column Property: Is Database Required?
<LINKED_ OBJECT>
Element within <COLUMN> or <CONSTRAINT>
ToObjDef.IdRef
Unique Identifier specified in the ARIS AML file that links column or constraint to the table. Is Mandatory for Column and Constraints
Copyright © 2011-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release