Meta Integration® Model Bridge (MIMB)
"Metadata Integration" Solution

MIMB Bridge Documentation

MIMB Import Bridge from Oracle Warehouse Builder (OWB)

Bridge Specifications

Vendor Oracle
Tool Name Oracle Warehouse Builder (OWB)
Tool Version 10.2 to 11g
Tool Web Site http://www.oracle.com/technology/products/warehouse/
Supported Methodology [Data Integration] Multi-Model, Metadata Repository, Data Store (Physical Data Model, OLAP Dimensional Model), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion) via OMB API

Import tool: Oracle Oracle Warehouse Builder (OWB) 10.2 to 11g (http://www.oracle.com/technology/products/warehouse/)
Import interface: [Data Integration] Multi-Model, Metadata Repository, Data Store (Physical Data Model, OLAP Dimensional Model), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion) via OMB API from Oracle Warehouse Builder (OWB)
Import bridge: 'OracleWarehouseBuilderOmb' 9.1.1

This bridge requires a working installation of Oracle Warehouse Builder in order to interface with its API. Please ensure that you are able to open OWB and view the metadata objects you are trying to import.

For OWB v. 11.3, please be sure to follow these steps:

1. Copy the following .JAR files from: ${MODEL_BRIDGE_HOME}\java\ to %OWB_HOME%\owb\lib\ext\
jsr173_1.0_api.jar
MIR.jar
MIRBridgeConstants.jar
MIREtlBridgeLib.jar
MIRExpressionLib.jar
MIRModelBridge.jar
OracleWarehouseBuilderOmb.jar
MIRStitchingUtil.jar
MIRSummaryUtil.jar
MIRUtil.jar
stax-1.1.1-dev.jar

2. Copy the ${MODEL_BRIDGE_HOME}\conf\MIRModelBridgeTemplate\OracleWarehouseBuilderOmb\mimbexec.bat file into the same OWB directory.


SUPPORT
Q: How do I provide metadata to the support team in order to reproduce an issue?
A: In order to reproduce an issue, an export of the source metadata must be provided. Please see http://docs.oracle.com/cd/E11882_01/owb.112/e17130/change_mgmt.htm#WBINS12000 for details.


Bridge Parameters

Parameter Name Description Type Values Default Scope
Host Enter the host name or IP address where the Oracle Warehouse Builder repository server is running. STRING   localhost Mandatory
Port Enter the Oracle Warehouse Builder service port number. The defult value is 1521. NUMERIC   1521 Mandatory
Service Enter the Oracle Warehouse Builder service name. STRING   orcl Mandatory
Repository Enter the Oracle Warehouse Builder Repository name. If this value is omitted the default repository will be used. STRING      
Project Enter the Oracle Warehouse Builder Project name you wish to import. REPOSITORY_MODEL     Mandatory
User Enter the database user name on whose behalf the connection is being made. Please ensure that you are able to open OWB and view the metadata objects you are trying to import with this username. STRING     Mandatory
Password Enter the password associated with the database username on whose behalf the connection is being made. PASSWORD     Mandatory
OWB Version Specifies the version of OWB. ENUMERATED
Auto detect
10g* up to 11gR1
11gR2
OWB_AUTO  
OWB Home Path Enter the path to the Oracle Warehouse Builder home directory.
Attention !!!
The directories are different for OWB 10g and OWB 11g.
As usual it is:
For OWB 10g: C:\OraHome_1
For OWB 11g: C:\product\11.1.0\db_1
DIRECTORY     Mandatory

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Oracle Warehouse Builder (OWB)"
Metamodel
OracleWarehouseBuilderOmb
Mapping Comments
     
Association Foreign Key  
AssociationRole Foreign Key  
Multiplicity zero or one/ zero or more  
AssociationRoleNameMap Foreign Key, Primary Key  
Attribute Column  
Description Column.Description  
InitialValue Column.DefaultValue  
Name Column.Name  
Optional !Column.NotNull  
BaseType OracleType  
CandidateKey Primary Key, Index  
Name Name  
Class Table  
Description Table.Description  
Name Table.Name  
ClassifierMap Operator  
Description Operator.Description  
Name Operator.Name  
Cube Cube  
Description Cube.Description  
Name Cube.Name  
CubeDimensionAssociation Cube.Dimension  
DataAttribute Attribute  
Description Attribut.Description  
Name Attribute.Name  
DataSet Group  
Description Group.Description  
Name Group.Name  
DatabaseSchema OWB Module  
DerivedType ColumnType  
Name DataType  
DesignPackage Module  
Description Module.Description  
Name Module.Name  
Dimension Dimension  
Description Dimension.Description  
Name Dimension.Name  
DimensionAttribute DimensionAttribute  
Description DimensionAttribute.Description  
Name DimensionAttribute.Name  
FeatureMap Line  
Name Group.Name+Attribute.Name  
Hierarchy DimensionHierarchy  
Description DimensionHierarchy.Description  
Name DimensionHierarchy.Name  
Index Index  
Generate Index.type  
Name Index.Name  
IndexMember Index.Column  
Name Index.Column.Name  
Level Level  
Description Level.Description  
Name Level.Name  
LevelAttribute Level Attribute Ref  
Description Level Attribute Ref.Description  
Name Level Attribute Ref.Name  
LevelKey Level Attribute Ref  
Measure CubeMeasure  
DefaultAggregation Agregation function  
Description CubeMeasure.Description  
Name CubeMeasure.Name  
Name Project.Name  
SQLViewAssociation View (selected Tables)  
Name Table.Name+View.Name  
SQLViewAttribute View.Column  
Description View.Column.Description  
Name View.Column.Name  
SQLViewEntity View  
Description View.Description  
Name View.Name  
WhereClause View. ViewQuery  
StoreModel Project  

[an error occurred while processing this directive]

Copyright © Meta Integration Technology, Inc. 1997-2016 All Rights Reserved.

Meta Integration® is a registered trademark of Meta Integration Technology, Inc.
All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.