Oracle Warehouse Builder (OWB) - Export - 7.1

Talend Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Data Catalog

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

BRIDGE INFORMATION
Export tool: Oracle Oracle Warehouse Builder (OWB) 10.2 to 11g (http://www.oracle.com/technology/products/warehouse/)
Export interface: [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 to Oracle Warehouse Builder (OWB)
Export bridge: 'OracleWarehouseBuilderOmb' 10.1.0

BRIDGE DOCUMENTATION
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

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


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 Oracle Warehouse Builder Project name to be processing. 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
Override Override the OWB project if already exists in repository BOOLEAN
False
True
False  
Dimensional modeling detection Select method the bridge will use to infer how tables are to 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
demension 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
As defined by source model
Autodetect from relational schema
Manually specified Facts and Dimensions
Disabled
Disabled  
Dimensional modeling detection Fact tables 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. This parameter manually controls how the tables are assigned the fact dimensional role. For example: dbo.Fact1; Fact2
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.

The behavior of this option can be combined with the 'Dimensional modeling detection Fact tables' option, so that some tables are handled as facts and the others as dimensions.
BOOLEAN
False
True
True  
Verbosity Specify whether the bridge should use high level verbosity during the dimensional modeling forward engineering process.
'False' - Use normal verbosity.
'True' - Additionalff information is printed in the log.
BOOLEAN
False
True
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