Skip to main content Skip to complementary content

Oracle Business Intelligence (OBI) Publisher Data Model (XDMZ file) - Beta - Import

Availability-note AWS

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
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection

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

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!