Oracle Business Intelligence (OBI) Publisher Report (XDOZ file) - Beta - Import
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 MIMB Known Limitations 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