Oracle Cloud Infrastructure Documentation

Configure Oracle Analytics Client Tools (Oracle BI Administration Tool)

The Oracle BI Administration Tool, a component of Oracle Analytics Client Tools, enables you to manage semantic models that define how data is presented in Oracle Analytics Cloud.

The Oracle BI Administration Tool provides capabilities to import your custom database objects or merge existing semantic model metadata into the Fusion Data Intelligence semantic model template. Within the Oracle BI Administration Tool, you can model custom objects and extend supported prebuilt objects.
  1. Download Client Tools.
  2. Download the wallet of Oracle Autonomous AI Lakehouse associated with the Oracle Fusion Data Intelligence instance.
  3. Configure the wallet that you downloaded as follows:
    1. Extract the wallet zip file and copy all the wallet files to: C:\Oracle\Middleware\Oracle_Home\domains\bi\config\fmwconfig\bienv\core
    2. Edit the "sqlnet.ora" file, setting DIRECTORY path to C:\Oracle\Middleware\Oracle_Home\domains\bi\config\fmwconfig\bienv\core. For example, the DIRECTORY path must be as follows:
      WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="C:\Oracle\Middleware\Oracle_Home\domains\bi\config\fmwconfig\bienv\core")))
SSL_SERVER_DN_MATCH=yes
      Note

      Ensure that there isn't a backslash after \core to avoid failure.
  4. Download Oracle Instant Client.
  5. Configure Oracle Instant Client as follows:
    1. Copy: C:\Users\<your username>\Downloads\instantclient-basic-windows.x64-23.6.0.24.10\instantclient_XX_X to: C:\Oracle\Middleware\Oracle_Home\bi. Replace "XX_X" with the applicable numbers.
    2. Navigate to C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\bin and edit nqinit.cmd to set %EXTRA_PATH%;%BI_PRODUCT_HOME%\instantclient_XX_X as the value for EXTRA_PATH. Replace "XX_X" with the applicable numbers.