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: OmgCwmXmiImport.OracleWarehouseBuilder version 11.2.0
OVERVIEW
REQUIREMENTS
To generate an XMI file from Oracle Warehouse Builder v9.2:
1. Start the 'Warehouse Builder' design client application and log on to the design repository.
2. Click on the Project > Export MetaData > Bridge menu.
3. Follow the wizard to the 'Source and Target Metadata' page.
4. Select 'OMG CWM 1.0' in the To: option.
5. Select the 'Collection of objects' to be exported.
6. Complete the export wizard to generate 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 | Imports an XML file compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format. | FILE |
|
Mandatory | ||||||
| Target Tool | Specify which tool was used to generate the model you want to import. Allows this bridge to fine tune the its behavior to match the way the source tool saved the model. 'Auto Detect' This bridge will auto-detect which tool generated the file. 'OMG CWM' Specifies that the file conforms to the OMG CWM standard DTDs. 'IBM DB2 Warehouse Manager' Specifies that the file was generated by IBM DB2 Warehouse Manager. 'Oracle Warehouse Builder' Specifies that the file was generated by Oracle Warehouse Builder. 'SAS ETL Studio' Specifies that the file was generated by SAS ETLStudio. |
ENUMERATED |
|
Auto Detect | ||||||
| Auto Correct | The CWM file produced by some source tools may contain a slightly incomplete or incorrect model. Allows you to specify whether this bridge should attempt to fix the model or not. 'True' Attempt to fix the model. This may involve deleting some model elements. This bridge will log warnings informing you about the changes. 'False' Do not modify the model. If the model is invalid this bridge will reject it. |
BOOLEAN | True | |||||||
| Top Package | The metamodel requires that all model elements (Classes, Associations...) belong to a package. Whenever any element is not explicitly associated to a package it is stored in a special package. This option specifies the name of that package. If there is a single top level package by that name in the model, package is considered optional so that it will not appear in the destination model if the destination tool does not require all objects to be in the package. | STRING | Logical View | |||||||
| Import UUIDs | The CWM file may contain UUIDs. This option allows you to specify whether this bridge should import them: 'True' The attribute xmi.uuid is saved in the NativeId property. 'False' The attribute xmi.uuid is ignored. |
BOOLEAN | True | |||||||
| Data model table design level | Controls the design level of the imported tables. Relevant when exporting metadata to a target tool which supports two views of the model, a logical view and a physical view. Some Data Modeling tools support this concept, where you can decide if a table appears both as a physical table and as a logical entity. Some Business Intelligence tools also support this concept, where you can decide if a table appears both in the physical model and in the business view of the model. Set the option to: 'Logical and physical' Tables to appear both in the logical view and in the physical view of the model. 'Physical' Tables to appear only in the physical view of the model. |
ENUMERATED |
|
Physical |
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 | UML:ModelElement.name / name | |
| Argument | UML:Parameter | |
| DefaultValue | defaultValue | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Kind | kind | |
| Name | UML:ModelElement.name / name | |
| PhysicalName | UML:ModelElement.name / name | |
| Position | Order in the CWMRDB file | |
| Association | CWMRDB:ForeignKey | The association is deduced from the foreign key/unique constraint relationship |
| Aggregation | deduced from the unicity of the attributes in the foreign key | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| PhysicalName | UML:ModelElement.name / name | |
| AssociationRole | CWMRDB:ForeignKey | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| ExtraConstraint | deleteRule, updateRule | |
| Multiplicity | 1' for the UniqueConstraint role if all the Attributes in the ForeignKey are mandatory and '0..1' otherwise. '0..*' for the ForeignKey role | |
| PhysicalName | UML:ModelElement.name / name | |
| Source | Set to 'true' for the UniqueConstraint role | |
| Attribute | CWMRDB:Column | |
| CppScope | visibility | |
| CppStatic | ownerScope | |
| InitialValue | UML:Attribute.initialValue | |
| Name | collationName | |
| Optional | isNullable | |
| Position | Order in the file | |
| Stereotype | UML:Stereotype | |
| BaseType | CWMRDB:SQLSimpleType | |
| DataType | See the DataType Mapping section | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Length | length, precision | From the Column's properties |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Scale | scale | From the Column's properties |
| CandidateKey | CWMRDB:UniqueConstraint,CWMRDB:PrimaryKey | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| UniqueKey | Set to 'true' | |
| Class | CWMRDB:BaseTable | |
| CppAbstract | isAbstract | |
| CppClassType | Set to 'Entity' | |
| CppConcurrency | isActive | |
| CppPersistent | isTemporary | |
| CppScope | visibility | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Stereotype | UML:Stereotype | |
| ClassDiagram | A class diagram is created each package that contains elements | |
| ClassifierMap | CWMTFM:ClassifierMap | |
| Description | functionDescription | |
| Operation | function | |
| Cube | CWMOLAP:Cube | One CubeRegion per Cube only |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| CubeDimensionAssociation | CWMOLAP:CubeDimensionAssociation | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| PhysicalName | UML:ModelElement.name / name | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| DerivedType | CWMRDB:SQLDistinctType | |
| DataType | See the DataType Mapping section | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Length | length, precision | This value can also be set from the Column's properties |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Scale | scale | This value can also be set from the Column's properties |
| UserDefined | Set to 'true' | |
| Dimension | CWMOLAP:Dimension | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Type | isTime or isMeasure | |
| UserDefined | Create the object only if the flag is set to "true" | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| FeatureMap | CWMTFM:FeatureMap | |
| Description | functionDescription | |
| Name | name | |
| Operation | function | |
| ForeignKey | CWMRDB:ForeignKey | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / 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 | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| PhysicalName | UML:ModelElement.name / name | |
| Position | Order in the file | |
| Index | CWMRDB:SQLIndex | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Level | CWMOLAP:Level | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| LevelAttribute | CWM:Attribute | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| LevelKey | CWM:UniqueKey | |
| Name | name | |
| Measure | CWMOLAP:Measure | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| SQLViewAttribute | CWMRDB:Column | |
| SQLViewEntity | CWMRDB:View | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| WhereClause | CWMRDB:View.queryExpression | |
| StoreModel | CWMRDB:Catalog | If there are several catalogs in the file, they are saved as Packages |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| StoredProcedure | CWMRDB:StoredProcedure | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | UML:ModelElement.name / name | |
| PhysicalName | UML:ModelElement.name / name | |
| Trigger | CWMRDB:Trigger |