You can use command-line utilities with the Oracle BI Server to make programmatic changes to your repository file, run sample queries, delete unwanted repository objects, and perform other tasks.
The table describes the Oracle BI Server command-line utilities.
Important:
When using Oracle BI EE tools such as nqcmd, biserverxmlcli, and comparerpd, you must edit the input to match the format expected by SQL, for example, do not include a single quote in your XML content.
| Utility Name | Description | Where to Go for More Information |
|---|---|---|
|
|
Used to import flex object changes from ADF data sources and map them to the Business Model and Mapping layer and Presentation layer. |
Automatically Mapping Flex Object Changes Using the biserverextender Utility |
|
|
Used to compare data types of logical columns between a particular repository and a generated list of logical column types to ensure that the types match as expected. |
|
|
XML utilities ( |
Primarily used to leverage the Oracle BI Server XML API for metadata migration, programmatic metadata generation and manipulation, metadata patching, and other functions. The XML utilities include:
|
XML Schema Reference for Oracle Business Intelligence Enterprise Edition |
|
|
Used to compare two repositories and generate a CSV diff file, an XML patch file, or an MDS XML diff. |
|
|
|
Used to upload a JSON file containing a list of application roles to delete from a specific server instance. |
|
|
|
Used to upload a JSON file containing a list of users to delete from a specific server instance. |
|
|
|
Used to download the repository to work offline on diagnostics and development tasks. |
|
|
|
Used to equalize objects in two repositories that have the same name, but different Upgrade IDs. Running this utility before merging repositories prevents unintended renaming during the merge. |
|
|
|
Used to localize the names of Presentation layer subject areas, tables, hierarchies, columns and their descriptions. |
|
|
|
Used to extract projects from a given repository. |
|
|
|
Used to create a list of connection pools in JSON format for a specific server instance. |
|
|
|
Used to create a list of repository variables in JSON format for a specific service instance. |
|
|
|
Used to convert MUD history files from .mhl format to .xml format so that they can be checked in under source control. |
Checking In New Versions of the MUD Master and MUD Log File to Source Control |
|
|
Used to invoke the Oracle BI Summary Advisor to generate an aggregate specification script that is run to create aggregates. This utility is only available for Oracle Business Intelligence running on an Oracle Exalytics machine. |
Using the nqaggradvisor Utility to Run the Oracle BI Summary Advisor |
|
|
Used to run test queries against the repository. Connects using an Oracle BI Server ODBC DSN. |
|
|
|
Used to view the query log. |
System Administrator's Guide for Oracle Business Intelligence Enterprise Edition |
|
|
Used to change the Oracle BI repository password. |
Changing the Oracle BI Repository Password Using the obieerpdpwdchg Utility |
|
|
Used to apply an XML patch file. This utility is especially useful for patching repository files on Linux or UNIX systems. |
|
|
|
Used to delete unwanted repository objects from your repository file, such as databases, tables, columns, initialization blocks, and variables. |
|
|
|
Used to upload a JSON file containing information about the application roles to rename for a specific server instance. |
Rename Application Role CommandRename Application Role Command |
|
|
Used to upload a JSON file containing a list of information about users to rename for a specific server instance. |
|
|
|
Used to generate the information necessary for the Oracle Database SQL Access Advisor or IBM DB2 Cube Views tool to preaggregate relational data and improve query performance. |
Exchanging Metadata with Databases to Enhance Query Performance |
|
|
Used to upload a modified JSON file containing updated connection pool values to a specific server instance. |
|
|
|
Used to upload a JSON file or a modified JSON file containing variable information to a specific server instance. |
|
|
|
Used to upload the repository to the Oracle BI Server and include changes in the Oracle Business Intelligence archive (BAR) file. |
|
|
|
Used to check the consistency of a repository. |
Using the validaterpd Utility to Check Repository Consistency |