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.
The connector capabilities are shown below:
Supported objects for Crawling are:
- Report Columns
Please see this article Crawling Data for more details on crawling.
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
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.
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
- 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
- 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.
- How much does the driver cost?
The Microsoft JDBC Driver for SQL Server is available at no additional charge.
- 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).
- Which authentication types are supported by the Microsoft JDBC Driver for SQL Server?
The table below lists available authentication options.
SQL Server, NTLM, Azure Active Directory Authentication, Pure Java Kerberos
SQL Server, Kerberos with NTLM backup, NTLM, Azure Active Directory Authentication, Pure Java Kerberos