Oracle OBIEE / Oracle Analytics Server (OAS)

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

  • Supported version: up to 12c / 2023
  • Read the Permission for Cloudera Data Lineage 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 Octopai Client.


  3. Verify extraction results.

    After a successful run, confirm the metadata archive in the target folder. See Verify extracted metadata files.

If an error occurred during the extraction, see Troubleshoot connector extraction failures.