SQL Server Reporting Services
An overview of the SQL Server Reporting Services integration with Secoda
Getting Started with SQL Server Reporting Services
There are 3 steps to connect SQL Server Reporting Services with Secoda:
Retrieve the host domain for your SQL Server Reporting Services workspace
Retrieve an account username and password with access to the workspace
Connect SSRS to Secoda
Retrieve the host domain
To retrieve the host domain, navigate to the home page of your report services workspace. Take the part of the URL that does not change when navigating around the workspace as your host domain.
For example, if the page is on the 'browse' tab and the link is https://example.secoda/reports/browse, then the host domain is https://example.secoda/reports in this case.
Retrieve account credentials
Your username and password is required to connect SQL Server Reporting Services to Secoda. Note that the display name in the top right of the home page may not be the username for your account. If you unsure of your username, it can be found by following these steps:
Enter your host domain into your browser, and add the following to the end of the url,
/api/v2.0/me?%24select=UsernameTo the right of the “username” field, your account username is found
Connect SQL Server Reporting Services
After retrieving the host domain and user credentials, the next step is to connect to Secoda:
In the Secoda App, select "Connect Integration" on the Integrations page
Search for and select SQL Server Report Services
Enter your host, username and password you retrieved
Click connect
Last updated