Provider Capabilities

Parent Previous Next


What features are available for each of the providers?

Best Practices

BI Compare

Documentation

Lineage

Data Dictionary

Additional Notes

Custom Metadata Import

a

b

c




Excel Spreadsheet

a

b

d

c

Excel Spreadsheet provider works against Excel 2013 and above Workbooks (*.xlsx)

Hive Server

a

c


Hive Server provider works against HDP 2.0 and above

Informatica

PowerCenter Repository

a

c


Informatica PowerCenter Repository provider works against the Informatica PowerCenter Repository 9.1.0 and above

Oracle Database

a

c


Oracle Database provider works against Oracle Databases 12c and above

SQL Server


SQL Server provider works against SQL Server 2005 and above when connecting to both SQL Server On-Premises and Azure Instances

SSAS Server


SSAS provider works against SSAS 2005 and above when connecting to a Multidimensional Instances and SSAS 2012 and above when connecting to a Tabular Instances. In order to connect to Azure Analysis Services, users will need to download and install the latest Microsoft Analysis Services Client Libraries

SSIS Package


SSIS provider works against SSIS 2005 and above when connecting to the File System, SQL Server, SSIS Package Store and SSIS 2012 and above when connecting to the SSIS Catalog


Important Note:

Pragmatic Workbench (32-bit) must be used when using the SSIS Package provider on a machine that only contains SSDT for Visual Studio 2015.


SSRS Report


SSRS provider works against SSRS 2005 and above when connecting to the File System and SSRS 2008 R2 and above when connecting to the Native or SharePoint Web Service.


Important Note:

KPIs and Mobile Reports are currently not supported when connecting to an SSRS 2016 or above Report Server


Tableau Server

a

e

c


Tableau provider works against Tableau Servers with REST API enabled with the following API Versions: 2.3, 2.2, 2.1 and 2.0


a Best Practices rules can be analyzed for the marked provider(s) once the user has created User Defined Best Practices


b Documentation sets generated from the marked provider(s) do not contain a unique structure and instead use a common layout


c Data Dictionary categories can be applied to the marked provider(s) once custom paths have been created


d Excel Spreadsheet Lineage Analysis only supports dependency scanning Data Sources from SQL Server and Analysis Services Databases and does not support PowerPivot


e Tableau Lineage Analysis only supports dependency scanning Data Sources from SQL Server Databases