Bridge Specifications
| Vendor | Oracle |
| Tool Name | Oracle Warehouse Builder (OWB) |
| Tool Version | 9i |
| Tool Web Site | http://www.oracle.com/technology/products/warehouse/ |
| Supported Methodology | [Data Integration] ETL (Source and Target Data Stores) via CWM XMI File |
SPECIFICATIONS
Tool: Oracle / Oracle Warehouse Builder (OWB) version 9i via CWM XMI File
See http://www.oracle.com/technology/products/warehouse/
Metadata: [Data Integration] ETL (Source and Target Data Stores)
Component: OmgCwmXmiExport.OracleWarehouseBuilder version 11.2.0
OVERVIEW
This bridge generates a Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file to be imported into Oracle Warehouse Builder.
REQUIREMENTS
To load generated XMI file into Oracle Warehouse Builder v9.2:
1. Start the Warehouse Builder design client.
2. Click on the Project > Import MetaData > Bridge menu.
3. Follow the wizard to the Source and Target Metadata page.
4. Select 'OMG CWM 1.0' in the From' option.
5. Complete the import wizard to import the CWM file.
FREQUENTLY ASKED QUESTIONS
n/a
LIMITATIONS
Refer to the current general known limitations at https://www.metaintegration.com/Products/MIMB/Help/#!Documents/mimbknownlimitations.html
SUPPORT
Provide a troubleshooting package with debug log. Debug log can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope | ||||
| File | Generates an XML file compliant to the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format. | FILE |
|
Mandatory | |||||
| Model | The target model type: 'UML' Export the logical model only as an instance of the metamodel for the CWM Object resource package (e.g. an entity/table is an instance of CWM: Class with the logical/business name as name). Note: the CWM Object Metamodel a subset of the UML Class Diagram Metamodel. 'RDB' Export the physical model only as an instance of the metamodel for the CWM 'Relational' resource package (e.g. an entity/table is an instance of CWMRDB: Table with the physical table name as name. 'UML and RDB' Export both logical and physical models as separate instances of the metamodels for CWM Object and Relational resource packages respectively. Note that no dependency relationships are established between both logical and physical models. 'OLAP' Export your model as OLAP only model. Use when exporting to OLAP objects to Oracle OWB. |
ENUMERATED |
|
RDB | |||||
| CWM version | The CWM version to write in the header when generating the file. | ENUMERATED |
|
CWM 1.0 | |||||
| Schema mapping | How to export a Table when it is not connected to any MIRSchema: 'Use Packages names' Create a CWM's RDBMS Schema for the Package the Table belongs to. 'Use default name' Create only one default RDBMS: Schema and put all the tables that are not connected to a MIRSchema in it. Use the option 'Default Schema name' to specify the name of this the default Schema. |
ENUMERATED |
|
Use Packages names | |||||
| Default Schema name | The name to use for the default RDBMS schema. This option is ignored if 'Schema mapping' is not set to 'Use default name'. | STRING | |||||||
| Export Index of Key | Determines whether to export the Index associated to a Primary Key or a Foreign Key: 'True' Export the Index. 'False' Don't export the associated Index. |
BOOLEAN | True | ||||||
| UUIDs | Determines whether to export the object's 'Universally Unique Identifier' when known. The UUIDs of the source model may not be compatible with the target tool: 'True' Export the UUIDs. 'False' Don't export the necessary tags. |
BOOLEAN | False | ||||||
| xmlns:CWM | There is currently no standard for URIs. This option allows you to change the URI for the CWM namespace if the destination tool expects a special URI that is different from the default URI. | STRING | org.omg.CWM1.0 | ||||||
| xmlns:CWMRDB | There is currently no standard for the URIs. This option allows you to change the URI for the CWMRDB namespace if the destination tool expects a special URI that is different from the default URI. | STRING | org.omg.CWM1.0/Relational | ||||||
| xmlns:CWMOLAP | There is currently no standard for URIs. This option allows you to change the URI for the CWM namespace if the destination tool expects a special URI that is different from the default URI. | STRING | org.omg.CWM1.0/OLAP | ||||||
| xmlns:CWMTFM | There is currently no standard for the URIs. This allows you to change the URI for the CWMRDB namespace if the destination tool expects a special URI that is different from the default URI. | STRING | org.omg.CWM1.0/Transformation | ||||||
| Verbosity | How verbose is the output. 'False' Normal verbosity. 'True' Additional information is printed in the log. |
BOOLEAN | True | ||||||
| XML Indentation (pretty printing) | Controls the pretty printing of XML, for the purpose of opening the generated file in a text editor. E.g. 'space characters' Several space characters as indentation. 'tab key' Tab character as indentation. 'empty' No indentation which leads to a more compact file |
STRING | |||||||
| Print DTD reference | Some XML viewers, like Microsoft IE, refuse to display an XML file if it includes a reference to a DTD file that is missing. This bridge normally does not provide the 'cwm.dtd' file. If you need the DTD file please find and copy it to the same directory where the XML file is. 'True' Print a DTD reference to 'cwm.dtd'. 'False' |
BOOLEAN | True |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Oracle Warehouse Builder (OWB) (via CWM XMI)" Metamodel OmgCwmXmi |
Mapping Comments |
| Name | name | If 'physicalName' is not set |
| Argument | UML:Parameter | |
| DefaultValue | defaultValue | |
| Description | 'documentation' tagged value | |
| Kind | kind | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Position | Order in the CWMRDB file | |
| AssociationRole | CWMRDB:ForeignKey | |
| Description | 'documentation' tagged value | |
| ExtraConstraint | deleteRule, updateRule | |
| PhysicalName | name | |
| Source | Source Association roles are not mapped | |
| AssociationRoleNameMap | Order in the CWM RDB file | |
| Attribute | CWMRDB:Column | |
| Description | 'documentation' tagged value | |
| ExtraConstraint | CWMRDB:CheckConstraint | The constraint is associated to the BaseClass |
| InitialValue | UML:Attribute.initialValue | |
| Name | name | If 'physicalName' is not set |
| Optional | isNullable | |
| PhysicalName | name | |
| Position | Order in CWM RDB file | |
| BaseType | CWMRDB:SQLSimpleType | |
| DataType | typeNumber | See the DataType Mapping section. |
| Description | 'documentation' tagged value | |
| Length | characterMaximumLength, numericPrecision, dateTimePrecision | Also saved as a property of the Column |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Scale | numericScale | Also saved as a property of the Column |
| CandidateKey | CWMRDB:UniqueConstraint,CWMRDB:PrimaryKey | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| UniqueKey | Non unique keys are not exported | |
| Class | CWMRDB:BaseTable | |
| CppPersistent | isTemporary | |
| CppScope | visibility | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| ClassifierMap | CWMTFM:ClassifierMap | |
| Description | functionDescription | |
| Operation | function | |
| Cube | CWMOLAP:Cube | One CubeRegion per Cube only |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| CubeDimensionAssociation | CWMOLAP:CubeDimensionAssociation | |
| Description | 'documentation' tagged value | |
| PhysicalName | name | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| DerivedType | CWMRDB:SimpleType,CWMRDB:DistinctType | The hierarchy of types is not reproduced. See BaseType mapping for the mapping of Derived types to Simple types |
| DataType | typeNumber | See the DataType Mapping section. |
| Description | 'documentation' tagged value | |
| InitialValue | initialValue | Saved as a property of the Column |
| Length | length, precision | Also saved as a property of the Column |
| Name | If 'physicalName' is not set | |
| PhysicalName | name | |
| Scale | scale | Also saved as a property of the Column |
| UserDefined | Generate a DistinctType if the property is set to true. | |
| DesignPackage | CWMRDB:Schema | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Dimension | CWMOLAP:Dimension | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| Type | isTime or isMeasure | |
| UserDefined | Create the object only if the flag is set to "true" | |
| DimensionAttribute | CWMOLAP:MemberSelection | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| FeatureMap | CWMTFM:FeatureMap | |
| Description | functionDescription | |
| Name | name | |
| Operation | function | |
| ForeignKey | CWMRDB:ForeignKey | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Hierarchy | CWMOLAP:Hierarchy | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| HierarchyLevelAssociation | CWMOLAP:HierarchyLevelAssociation | |
| Description | 'documentation' tagged value | |
| PhysicalName | name | |
| Position | Order in the file | |
| Index | CWMRDB:SQLIndex | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Unique | isUnique | If the index is associated to a candidated key |
| IndexMember | CWMRDB:SQLIndexColumn | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Position | Order in the CWM RDB file | |
| SortOrder | isAscending | |
| Level | CWMOLAP:Level | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| LevelAttribute | CWM:Attribute | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| LevelKey | CWM:UniqueKey | |
| Name | name | |
| Measure | CWMOLAP:Measure | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| SQLViewAttribute | CWMRDB:Column | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Position | Order in CWM RDB file | |
| SQLViewEntity | CWMRDB:View | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| WhereClause | CWMRDB:View.queryExpression | |
| StoreModel | CWMRDB:Catalog | If there are several catalogs in the file, they are saved as Packages |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| StoredProcedure | CWMRDB:StoredProcedure | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Semantics | body | |
| Trigger | CWMRDB:Trigger | |
| Description | 'documentation' tagged value | |
| FireOnDelete | eventManipulation | |
| FireOnInsert | eventManipulation | |
| FireOnUpdate | eventManipulation | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Semantics | actionStatement | |
| TriggerType | conditionTiming |