# Oracle Business Intelligence (OBI) Publisher Data Model (XDMZ file) - Beta - Import Availability-note[AWS](https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-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 Specifications | **Vendor** | **Oracle** | | --- | --- | | **Tool Name** | **Oracle Business Intelligence (OBI) Publisher Data Model (XDMZ file)** | | **Tool Version** | **11.0 to 12c** | | **Tool Web Site** | http://www.oracle.com/technetwork/middleware/bi-foundation/overview/index.html | | **Supported Methodology** | [Business Intelligence] BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Parsing) via XDMZ File | | **Data Profiling** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | | **Incremental Harvesting** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | | **Multi-Model Harvesting** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | | **Remote Repository Browsing for Model Selection** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | **SPECIFICATIONS** **Tool:** Oracle / Oracle Business Intelligence (OBI) Publisher Data Model (XDMZ file) version 11.0 to 12c via XDMZ File See http://www.oracle.com/technetwork/middleware/bi-foundation/overview/index.html **Metadata:** [Business Intelligence] BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Parsing) **Component:** OracleBIPublisherDataModel version 11.2.0 **OVERVIEW** Imports an Oracle Business Intelligence Publisher data model. **REQUIREMENTS** n/a **FREQUENTLY ASKED QUESTIONS** n/a **LIMITATIONS** Refer to the current general known limitations at [MIMB Known Limitations](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Subsystems/ModelBridgeGuide/Content/MIMB-Known-Limitations.htm) or bundled in Documentation/ReadMe/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** | | --- | --- | --- | --- | --- | --- | | **Data Model file** | Specify the Oracle BI Publisher data model to import with .XDMZ or .XDM extension.

The .XDMZ file is a zip archive and contains all related data model files (XDM, ...)



You can use the BI Publisher web UI to download such .XDMZ file, for example:

\* connect with a web browser to URL like: http://hostname:9502/xmlpserver/

\* navigate through the catalog folders and select a datamodel

\* the UI offers a download action for the datamodel in XDMZ format



You can also use the BI Publisher catalog command line utility (BIPCatalogUtil) to download such .XDMZ file, for example:

\* The BI Publisher catalog utility installation location depends on your version.

For version 11.x it may be in ORACLE\_HOME/clients/bipublisher/BIPCatalogUtil/bin

For version 12.x it may be in ORACLE\_HOME/clients/bip/bin

\* You may need to edit the following XML configuration file with a text editor: config/xmlp-client-config.xml

Specify the URL to connect to the Publisher server, e.g. http://hostname:9502/xmlpserver/

Specify the username and password to connect

\* start a command prompt window (CMD)

\* run the BIPCatalogUtil command line utility with such parameters:

BIPCatalogUtil.cmd -export catalogpath=/path/TheDataModel.xdm target=/path/TheDataModel.xdmz extract=false



Please refer to Oracle documentation for details:

https://docs.oracle.com/en/middleware/bi/analytics-server/administer-publisher-oas/overview.html | FILE |
*.xdmz
*.xdm
| | Mandatory | | **Data Sources file** | Specify the datasources.xml file which defines Oracle BI Publisher data source connections.

This file is stored in your Oracle BI Publisher installation directory at: /Admin/DataSource/datasources.xml

The exact location of the file depends on your version and configuration, see examples below.



For versions 10.x, it may be at:

Oracle\_Home/xmlpserver/Admin/DataSource/datasources.xml

Oracle\_Home/xmlp/XMLP/Admin/DataSource/datasources.xml



For versions 11.x, it may be at:

Oracle\_Home/user\_projects/domains/bifoundation\_domain/config/bipublisher/repository/Admin/DataSource/datasources.xml



For versions 12.x, it may be at:

Oracle\_Home/user\_projects/domains/bi/bidata/components/bipublisher/repository/Admin/DataSource/datasources.xml

Oracle\_Home/user\_projects/domains/bi/config/fmwconfig/biconfig/bipublisher/Admin/DataSource/datasources.xml | FILE | \*.xml | | | | **Miscellaneous** | Specify miscellaneous options identified with a -letter and, if applicable, a value.

**-r to remove the report pages and their graphical structure** | STRING | | | | ## Bridge Mapping Mapping information is not available