SSRS

Version Supported: up to SQL 2022

Tool Permissions Prerequisites

Warning: Missing permissions could end up in broken lineages.

User and password with permissions to the SSRS API

(Azure Active Directory authentication not supported)

• The user need 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 (OC) 

Video - Extraction Guide

Watch the following video to learn about the SSRS Extraction process

How to verify the extracted Metadata File

Access the Octopai Target Folder (TGT)

1. Go to the TGT Folder located on the Server where the Octopai Client is installed.
   By default: C:\Program Files (x86)\Octopai\Service\TGT
2. Open the zip file having the Connector Name
   Example:
3. Verify its content
   Quantity & Quality of inner files

Troubleshoot

Error during the extraction:

• Check the permissions
• Send the log with the connector number and name to Octopai Support - C:\Program Files (x86)\Octopai\Service\log
  

  

IMPORTANT: Columns are displayed up to the Presentation Level, not to the Report Level