Oracle Business Intelligence (OBI) Publisher Data Model (XDMZ file) - Beta - Import
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 |
|
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