SSRS

Connectivity Summary

An out of the box connector is available for SSRS. It provides support for Crawling and Lineage building .

The connectivity to SSRS via JDBC, which is included in the platform.

Connector Capabilities

The connector capabilities are shown below:

Crawling

Supported objects for Crawling are:

  • Reports
  • Report Columns

Please see this article Crawling Data for more details on crawling. 

Lineage Building

Lineage Entities Details

Table lineage

Supported

Column lineage

Supported

Lineage Sources

Source Code

Pre-requisites

To use the connector, we need the following:

  • Connection details as specified in the following section should be available.
  • A service account, for Crawling and Profiling. The minimum privileges required are:
    • Connection validate
    • Crawl domains
    • Crawl reports

Connection Details

The following connection settings should be added for connecting to a SSRS:

 

  • Database Type: SSRS
  • Connection Name: Select a Connection name for the SSRS. The name that you specify is a reference name to easily identify your SSRS connection in OvalEdge.
  • Authentication:

    Windows Authentication Account name and password is authenticated using the Windows principal token in the operating system. Username and password need not be specified.
    SQL Server Authentication Must provide SA account credentials (Username / Password)
  • Hostname / IP Address: Database instance ip address
    Example: ssrs.ovaledge.net
  • Username: SSRS login username
  • Password: SSRS login password
  • Port number: SSRS Port - 1433
  • SID / Database: Database name
  • Web port: SSRS webport - 443
  • Web URL: SSRS webUrl
    Example: https://ssrs.ovaledge.net/ReportServer
  • isWebServiceURL: If URL is web service based give Y or else N
  • Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
  • Connection String: SSRS connection string - set the connection string toggle button to automatic, to get the details automatically from the credentials provided. Alternatively, you can manually enter the string.
    Format: jdbc:sqlserver://{server}:{port};database={sid}

Once connectivity is established, additional configurations for Crawling and Profiling can be specified.

FAQs

  1. How much does the driver cost?
    The Microsoft JDBC Driver for SQL Server is available at no additional charge.
  2. Can I use the driver to access Microsoft SQL Server from a Linux computer?
    Yes, you can use the driver to access SQL Server from Linux, Unix, and other Non-Windows platforms. For having SQL Server JDBC Authentication on Linux environment, we use jtds 1.3.1 driver (NTLM).
  3.  Which authentication types are supported by the Microsoft JDBC Driver for SQL Server?
    The table below lists available authentication options.

Platform

Authentication

Non-Windows

SQL Server, NTLM, Azure Active Directory Authentication, Pure Java Kerberos 

Windows

SQL Server, Kerberos with NTLM backup, NTLM, Azure Active Directory Authentication, Pure Java Kerberos