Skip to content

Symbio Reporting

Requirements

Reporting Connector is already set up.

Short Overview of Configuration steps

  1. Create and configure a report pool if it does not exist. You may reuse an existing report pool for different storages.
  2. Assign a report pool to a storage. After successful assignment, you can find the authorization token on the admin page's 'Automation' tile.
  3. Activate those reports from the report set you want to use in your connected storage.

Explanation

Report Pool

In Symbio follow these steps to create and configure a report pool:

  1. Login as an admin user to the sysadmin collection
  2. Switch to External systems
  3. Select type Report pool and name your new report pool appropriately
  4. Edit the settings of the new report pool as described below

Setting Meaning
Service endpoint url Enter the URL of the connector service as noted during its setup.
Authentication token Enter the security:authToken that was defined in the connector service's settings.
Administrative connection string Enter a connection string to the ODS database that allows full access to the database. e.g. Server=localhost;Database=ODS;User ID=ODSWriter;Password=ODSWriterPwd
Read-only connection string Enter a connection string the the ODS database that allows read-only access to the database. e.g. Server=localhost;Database=ODS;User ID=ODSReader;Password=ODSReaderPwd
SSRS root folder path The SSRS root folder path for this connector instance as noted during SSRS worksapce template setup, e.g. SymbioReporting.
Report template folder The name of the template folder in the root path given above as noted during SSRS workspace template setup, e.g. Template.
SSRS enabled check this option

Connecting a storage to a report pool

In Symbio follow these steps to connect a storage to a report pool:

  1. Login as an admin user to the Collection where the storage is located
  2. Switch to Storages
  3. Select the storage to connect to a Report pool
  4. Select the desired Report pool from the drop down

This will trigger the creation of reports in Symbio (if SSRS has been enabled on the pool, and the workspace contains reports to link to).

IsPermittedEverywhere

Please keep in mind that you can set the Symbio authorization token to be permitted everywhere, with end end date until this permission set is valid. This permission set may be valid for operations or objects it was not intended for, and may have an impact on Symbio's behaviour.

screen

Activating reports in a storage

In Symbio follow these steps to activate reports in a storage:

  1. Login as an admin user to the storage
  2. Switch to the admin area of the storage
  3. Select Reporting under Configure
  4. Select the report that should be activated and the mark the Activated checkbox

The report is now available in the reporting dropdown: