Skip to main content Skip to complementary content

Oracle Business Intelligence (OBI) Publisher Report (XDOZ file) - Beta - Import


Bridge Requirements

This bridge:
  • requires Internet access to and/or other tool sites to download drivers into <TDC_HOME>/data/download/MIMB/.

Bridge Specifications

Vendor Oracle
Tool Name Oracle Business Intelligence (OBI) Publisher Report (XDOZ file)
Tool Version 11.0 to 12c
Tool Web Site
Supported Methodology [Business Intelligence] BI Report (Dimensional Source, Report Structure) via XDOZ File
Data Profiling
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection

Tool: Oracle / Oracle Business Intelligence (OBI) Publisher Report (XDOZ file) version 11.0 to 12c via XDOZ File
Metadata: [Business Intelligence] BI Report (Dimensional Source, Report Structure)
Component: OracleBIPublisherReport version 11.2.0

This import bridge requires internet access to download third-party libraries:
- such as to download open source third-party libraries,
- and more sites for other third-party software such as database specific JDBC drivers.

The downloaded third-party libraries are stored into $HOME/data/download/MIMB/
- If HTTPS fails, the import bridge then tries with HTTP.
- If a proxy is used to access internet, you must configure that proxy in the JRE (see the -j option in the Miscellaneous parameter).
- If the import bridge does not have full access to internet, that $HOME/data/download/MIMB/ directory can be copied from another server with internet access where the command $HOME/bin/ (or .bat) -d can be used to download all third-party libraries used by all bridges at once.

By running this import bridge, you hereby acknowledge responsibility for the license terms and any potential security vulnerabilities from these downloaded third-party software libraries.

Imports an Oracle Business Intelligence Publisher report.



Refer to the current general known limitations at or bundled in Documentation/ReadMe/MIMBKnownLimitations.html

Provide a troubleshooting package with debug log. Debug log can be set in the UI or in conf/ with MIR_LOG_LEVEL=6

Bridge Parameters

Parameter Name Description Type Values Default Scope
Report file Specify the Oracle BI Publisher report file to import with .XDOZ extension.
The .XDOZ file is a zip archive and contains all related report files (XDO, RTF, CFG, XPT, ...)

You can use the BI Publisher web UI to download such .XDOZ file, for example:
* connect with a web browser to URL like: http://hostname:9502/xmlpserver/
* navigate through the catalog folders and select a report
* the UI offers a download action for the report in XDOZ format

You can also use the BI Publisher catalog command line utility (BIPCatalogUtil) to download such .XDOZ 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/The+Report.xdo target=/path/TheReport.xdoz extract=false

Please refer to Oracle documentation for details:

FILE *.xdoz   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:

For versions 11.x, it may be at:

For versions 12.x, it may be at:
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



Bridge Mapping

Mapping information is not available

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!