SSRS

Learn how to set up and manage SSRS metadata sources using Cloudera Data Lineage (formerly Octopai).

Tool Permissions Prerequisites

User and password with permissions to the SSRS API (Azure Active Directory authentication not supported)

  • The user needs to have “Content Manager” permissions on the report’s folder or the report itself.
    • http://<ServerName>/Reportserver/ReportService2010.asmx * Native Mode Min Permission: Content Manager
    • http://<sp server name>/_vti_bin/ReportServer/ReportService2010.asmx * Sharepoint Integrated Mode Min Permission: Owners

Setting up SSRS Metadata Source

Metadata Sources are set on the Octopai Client



Verify extraction results

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

Troubleshoot

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