You can use a variety of 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.
OBIEE have several executables files which permit you to automate some actions.
In 11g, before running any of the Oracle BI Server command-line utilities, you must first run bi-init.cmd (or bi-init.sh on UNIX)
| Utility | 11G | Description | Note |
|---|---|---|---|
| nqcmd.exe | nQcmd.exe | - | To run queries against other ODBC data sources than the Oracle BI Server. |
| OBIEE 11G/10g - Connection Pool Password Change | 10G/11G | Utility to change the passwords | - |
| nqsecudmlgen.exe | nQSecUDMLGen.exe | - | - |
| nqsshutdown.exe | nQSShutDown.exe | Utility to shut down the Oracle BI Server | - |
| nqudmlcli.exe | nQUDMLCli.exe | - | - |
| nqudmlexec.exe | nQUDMLExec.exe | udml Executor | This command line tool can modify the RPD file by combining the fragment you define in the UDML file with the input repository and generate a output repository. |
| nqudmlgen.exe | nQUDMLGen.exe | udml Generator | can generate the entire repository in a text format |
| SchConfig.exe | SchConfig.exe | - | You may use the schconfig utility to configure Oracle BI Scheduler. |
| schshutdown.exe | SchShutdown.exe | - | - |
| - | SASchInvoke.exe | - | - |
| admintool.exe | admintool.exe | - | - |
| nqlogviewer | - | - | - |
| patchrpd | 11G | Used to generate and apply an XML patch file. This utility is especially useful for patching repository files on Linux or UNIX systems | |
| prunerpd | 11G | Used to delete unwanted repository objects from your repository file, such as databases, tables, columns, initialization blocks, and variables. | |
| sametaexport | 11G | Used to exchange metadata (dimension, hierachy) with the Oracle Database and DB2 | |
| extractprojects | 11G | Used to extract projects from a given repository. | |
| equalizerpds | 10G/11G | Used to equalize objects | |
| nqgenoldverrpd | 11G | Repository Downgrade utility | |
| XML utilities (11G) Used to leverage the Oracle BI Server XML API | |||
| biserverxmlgen | 11g | generates XML from an existing RPD | |
| biserverxmlexec | 11g | executes the XML in offline mode to create or modify a repository file | |
| biserverxmlcli | 11g | executes the XML against the Oracle BI Server | |
Where are they located ?
| OS | Directory 10G | Directory 11G |
|---|---|---|
| Windows | OracleBI_HOME\server\Bin | ORACLE_HOME\bifoundation\server\bin |
| Unix | $INSTALLDIR/Bin |
-Asifkhan P.
No comments:
Post a Comment