Microsoft SQL Server Reporting Services (SSRS) connection

To access your data in Microsoft SQL Server Reporting Services, create a connection asset for it.

Microsoft SQL Server Reporting Services (SSRS) provides a set of provides a set of tools for creating and managing business intelligence reports.

Supported versions

Microsoft SQL Server 2022.

Only paginated reports are supported.

Create a connection to Microsoft SQL Server Reporting Services

To create the connection asset, you need these connection details:

Hostname or IP address
Name of the database where the reports are stored
Port number
If the Microsoft SQL Server has been set up in a domain that uses NTLM (New Technology LAN Manager) authentication, select Use Active Directory Then enter the name of the domain associated with the username and password
SSL certificate (if required by the database server)
Username and password for accessing the database

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Choose the method for creating a connection based on where you are in the platform

In a project: Click Assets > New asset > Prepare data > Connect to a data source. See Adding a connection to a project.

In a catalog: Click Add to catalog > Connection. See Adding a connection asset to a catalog.
In the Platform assets catalog: Click New connection. See Adding platform connections.

Next step: Add assets from the connection

In a project, create and run a metadata import with the Import BI report or the Get BI report lineage goal to add assets to a catalog. See Importing business intelligence reports and Getting lineage for business intelligence reports.

Federal Information Processing Standards (FIPS) compliance

The Microsoft SQL Server Reporting Services connection cannot be created in a FIPS environment.

Microsoft SQL Server Reporting Services setup

Install SQL Server Reporting Services

Restrictions

You can use this connection only for source data. You cannot write to data or export data with this connection.

Supported file types

The Microsoft SQL Server Reporting Services connection supports these file types: paginated reports.

Learn more

What is SQL Server Reporting Services (SSRS)?

Parent topic: Supported connections