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 Data Warehouse 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.