Intro
Microsoft SQL Server Reporting Service (SSRS) is a server-based report-generating software system from Microsoft. To learn more about the Microsoft SQL Server Reporting Service Connector, see (https://docs.microsoft.com/en-us/sql…inated-reports ). You can connect to your Microsoft SQL Server Reporting Service account in the Data Center. This topic discusses the fields and menus that are specific to the Microsoft SQL Server Reporting Service connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Data Connector.Prerequisites
To connect to SSRS and import SharePoint reports, you must have the following:- Your Active Directory username and password that provides access to SSRS.
- The Active Directory domain name that allows access to MS Reporting Services and SharePoint.
Connecting to Your Microsoft SQL Server Reporting Service
This section enumerates the options in the Credentials and Details panes in the Microsoft SQL Server Reporting Service Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Data Connector.Credentials Pane
This pane contains fields for entering credentials to connect to your Microsoft SQL Server Reporting Service account. The following table describes what is needed for each field:Field | Description |
|---|---|
Username | Enter your Active Directory username you use to connect to SSRS. |
Password | Enter your Active Directory password you use to connect to SSRS. |
Domain Name | Enter the Active Directory domain name of the SSRS server. |
Details Pane
This pane contains menus for selecting and configuring a SharePoint report.Menu | Description |
|---|---|
Document URL | Enter the URL of the SharePoint report you want to import into Domo. For example: http://myserver/mysite/Reports/myReport.rdl |
SharePoint Report Server URL | Enter the URL of the SharePoint report server. For example: http://myserver/mysite/_vti_bin/ReportServer/ReportExecution2005.asmx |
Starting Row | Enter the number of the row in the report in which the data starts. Usually this is the row with the column headers. The default starting row is 1. |