Oracle Warehouse Builder (OWB) - Export
Availability-note
AWS
AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com
Bridge Requirements
This bridge:is only supported on Microsoft Windows.
requires the tool to be installed to access its SDK.
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] 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 |
SPECIFICATIONS
Tool: Oracle / Oracle Warehouse Builder (OWB) version 10.2 to 11g via OMB API
See http://www.oracle.com/technology/products/warehouse/
Metadata: [Data Integration] Metadata Repository, Data Store (Physical Data Model, OLAP Dimensional Model), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion)
Component: OracleWarehouseBuilderOmb version 11.2.0
OVERVIEW
REQUIREMENTS
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\
MIR.jar
MIRBridgeConstants.jar
MIREtlBridgeLib.jar
MIRExpressionLib.jar
MIRModelBridge.jar
OracleWarehouseBuilderOmb.jar
MIRStitchingUtil.jar
MIRSummaryUtil.jar
MIRUtil.jar
MIRProfiler.jar
MIRStatisticsUtil.jar
2. Copy the ${MODEL_BRIDGE_HOME}\java\Yaml\snakeyaml-1.26.jar to %OWB_HOME%\owb\lib\ext\
3. Copy the ${MODEL_BRIDGE_HOME}\conf\MIRModelBridgeTemplate\OracleWarehouseBuilderOmb\mimbexec.bat file into the same OWB directory.
FREQUENTLY ASKED QUESTIONS
n/a
LIMITATIONS
Refer to the current general known limitations at MIMB Known Limitations or bundled in Documentation/ReadMe/MIMBKnownLimitations.html
SUPPORT
Provide a troubleshooting package with:
- the debug log (can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6)
- the metadata backup if available (can be set in the Miscellaneous parameter with -backup option, although this common option is not implemented on all bridges for technical reasons).
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. | 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 | Oracle Warehouse Builder Project name to be processed. | 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 |
|
OWB_AUTO | |||||
| OWB home path | The path to the Oracle Warehouse Builder home directory. The directories are different for OWB 10g and OWB 11g. - OWB 10g C:\OraHome_1 - OWB 11g C:\product\11.1.0\db_1 |
DIRECTORY | Mandatory | ||||||
| Override | Override the OWB project if already exists in repository. | BOOLEAN |
|
False | |||||
| Dimensional modeling detection | Select the method for the bridge will use to infer how tables are to be converted into BI facts and dimensions. Select the method to infer how tables will be converted into BI facts and dimensions. This bridge can use the dimensional role that has been specified for each table (fact, dimension, outrigger) to infer how those tables are converted into BI facts and dimensions when forward-engineering a data model created in a data modeling, or ETL tool, and forward-engineer to an OLAP/BI model. This parameter controls how the table's dimensional role (fact, dimension, outrigger) is to be determined. The bridge may make such a determination, even if the source model did not specify tables dimensional role. 'As defined by source model' Determine dimensional role only as defined in the source model. 'Autodetect from relational schema' Determine dimensional role of fact and dimension tables based on foreign keys. This algorithm determines a table to be a: fact table - if the table has only incoming foreign keys dimension table - if the table has with no foreign key relationships to any other tables dimension table or outrigger table - if the table has outgoing foreign keys and depending on the minimum distance (number of foreign key relationships) to a fact table 'Manually specified Facts and Dimensions' Manually specify the fact and dimension tables. 'Disabled' No forward engineering to OLAP occurs. |
ENUMERATED |
|
Disabled | |||||
| Dimensional modeling detection Fact tables | Manually controls how the tables are assigned the fact dimensional role, e.g. dbo.Fact1; Fact2 Enter a semi-colon separated list of tables to be represented as fact tables. This bridge can use the dimensional role that has been specified for each table (fact, dimension) to infer how those tables are converted into BI facts and dimensions when forward-engineering a data model created in a data modeling, or ETL tool, and forward-engineer to an OLAP/BI model. |
STRING | |||||||
| Dimensional modeling detection Dimension tables | Specify whether the bridge should assume that all tables are dimensions. 'True' Assume that all tables are dimensions. 'False' Use the dimensional role specified on each table, if any. This parameter can be combined with the 'Dimensional modeling detection Fact tables' parameter, so that some tables are handled as facts and the others as dimensions. |
BOOLEAN |
|
True | |||||
| Verbosity | Specify whether the bridge should use high level verbosity during the dimensional modeling forward engineering process. 'False' Use normal verbosity. 'True' Additional information is printed in the log. |
BOOLEAN |
|
True |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Oracle Warehouse Builder (OWB)" Metamodel OracleWarehouseBuilderOmb |
Mapping Comments |
| Attribute | Column | |
| Description | Column.Description | Illegal and new line chars (\n) will be replaced with " " space. |
| InitialValue | Column.DefaultValue | |
| Name | Column.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| Optional | !Column.NotNull | |
| CandidateKey | Primary Key, Index | |
| Name | Name | |
| Description | Table.Description | Illegal and new line chars (\n) will be replaced with " " space. |
| Name | Table.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| Cube | Cube | |
| Description | Cube.Description | Illegal and new line chars (\n) will be replaced with " " space. |
| Name | Cube.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| CubeDimensionAssociation | Cube.Dimension | |
| DatabaseSchema | OWB Module | |
| DerivedType | ColumnType | |
| Name | DataType | |
| DesignPackage | Module | |
| Description | Module.Description | Illegal and new line chars (\n) will be replaced with " " space. |
| Name | Module.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| Dimension | Dimension | |
| Description | Dimension.Description | Illegal and new line chars (\n) will be replaced with " " space. |
| Name | Dimension.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| DimensionAttribute | DimensionAttribute | |
| Description | DimensionAttribute.Description | Illegal and new line chars (\n) will be replaced with " " space. |
| Name | DimensionAttribute.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| Hierarchy | DimensionHierarchy | |
| Description | DimensionHierarchy.Description | Illegal and new line chars (\n) will be replaced with " " space. |
| Name | DimensionHierarchy.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| Index | Index | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. Index name must be unique within module. |
| Generate | Index.type | |
| Name | Index.Name | Illegal and new line chars (\n) will be replaced with " " space. |
| IndexMember | Index.Column | |
| Name | Index.Column.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| 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 | Illegal and new line chars (\n) will be replaced with " " space. |
| Name | CubeMeasure.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| Name | Project.Name | |
| SQLViewAssociation | View (selected Tables) | |
| Name | Name | |
| SQLViewAttribute | View.Column | |
| Description | View.Column.Description | Illegal and new line chars (\n) will be replaced with " " space. |
| Name | View.Column.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| SQLViewEntity | View | |
| Description | View.Description | Illegal and new line chars (\n) will be replaced with " " space. |
| Name | View.Name | Only alphabetic and digital chars are allowed. Illegal chars will be replacesd with '_'. If name is OWB reserved word the sufix "_RES" will be added. If name is not unique the sufix "_NNN" will be added. The NNN is a number like 123. |
| WhereClause | View. ViewQuery | |
| StoreModel | Project |