Cloudera Docs

Oracle OBIEE / Oracle Analytics Server (OAS)

Learn how to extract and configure Oracle OBIEE metadata files for analysis by Cloudera Octopai Data Lineage.

  • Supported version: up to 12c / 2023

  • Read the Permission for Cloudera Octopai Windows NT User to the OBIEE RDP and Catalog files folder.

  1. Retrieve the repository rpd file
    1. Log in to Oracle OBIEE enterprise manager (em) at http://obiee12c:9500/em/.
    2. Go to Business Intelligence > coreapplication > Repository.
      The rpd file can be found at D:\Oracle\Middleware\ user_projects\domains\bi\bidata\service_instances\ssi\metadata\datamodel\customizations.
    3. Extract the OBIEE reports that is the catalog file.
      1. Log in to OBIEE analytics at http://<Server Name>:9502/analytics/saw.dll?bieehome.
      2. Click on Catalog at the top right corner.
      3. Select the folder you want to archive, and then click on the Archive button.
    4. In the task box select archive to zip the files.
    5. Deselect the Keep Permissions and Keep Timestamps checkboxes.
    6. Click OK.
    7. Save the file.
  2. Set up the Oracle OBIEE metadata source on the Cloudera Octopai Client.


  3. Verify the extracted metadata file by accessing the Cloudera Octopai Target Folder (TGT).
    1. Go to the TGT Folder located on the server where the Cloudera Octopai Client is installed.
      The default location is C:\Program Files (x86)\Octopai\Service\TGT.
    2. Open the zip file with the connector name.
      Example
    3. Verify the file content by checking the quantity and quality of the included files.

If an error occurred during the extraction, perform the following troubleshooting steps:

  1. Check the permissions.
  2. Send the log with the connector number and name to Cloudera Support.
    You can find the log files at C:\Program Files (x86)\Octopai\Service\log.