Skip to main content Skip to complementary content

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

Availability-noteAWS

Bridge Requirements

This bridge:
  • requires Internet access to https://repo.maven.apache.org/maven2/ 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 http://www.oracle.com/technetwork/middleware/bi-foundation/overview/index.html
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

SPECIFICATIONS
Tool: Oracle / Oracle Business Intelligence (OBI) Publisher Report (XDOZ file) version 11.0 to 12c via XDOZ File
See http://www.oracle.com/technetwork/middleware/bi-foundation/overview/index.html
Metadata: [Business Intelligence] BI Report (Dimensional Source, Report Structure)
Component: OracleBIPublisherReport version 11.2.0

DISCLAIMER
This import bridge requires internet access to download third-party libraries:
- such as https://repo.maven.apache.org/maven2/ 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/MIMB.sh (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.

OVERVIEW
Imports an Oracle Business Intelligence Publisher report.

REQUIREMENTS
n/a

FREQUENTLY ASKED QUESTIONS
n/a

LIMITATIONS
Refer to the current general known limitations at http://metaintegration.com/Products/MIMB/MIMBKnownLimitations.html 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
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:
https://docs.oracle.com/en/middleware/bi/analytics-server/administer-publisher-oas/overview.html

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:
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

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!