Supported data sources in Azure Data Catalog

You can publish metadata by using a public API or a click-once registration tool, or by manually entering information directly to the Azure Data Catalog web portal. The following table summarizes all data sources that are supported by the catalog today, and the publishing capabilities for each. Also listed are the external data tools that each data source can launch from our portal "open-in" experience. The second table contains a more technical specification of each data-source connection property.

List of supported data sources

Data source object API Manual entry Registration tool Open-in tools Notes
Azure Data Lake Store directory <font size=2> <font size=2>
Azure Data Lake Store file <font size=2> <font size=2>
Azure Blob storage <font size=2>Power BI <font size=2>
Azure Storage directory <font size=2>Power BI <font size=2>
Azure Storage table
HDFS directory <font size=2> <font size=2>
HDFS file <font size=2> <font size=2>
Hive table <font size=2>Excel <font size=2>
Hive view <font size=2>Excel <font size=2>
MySQL table <font size=2>Excel, Power BI <font size=2>
MySQL view <font size=2>Excel, Power BI <font size=2>
Oracle Database table <font size=2>Excel, Power BI <font size=2>
Oracle Database view <font size=2>Excel, Power BI <font size=2>
Other (generic asset) <font size=2> <font size=2>
Azure SQL Data Warehouse table <font size=2>Excel, Power BI, SQL Server data tools <font size=2>
SQL Data Warehouse view <font size=2>Excel, Power BI, SQL Server data tools <font size=2>
SQL Server Analysis Services dimension <font size=2>Excel, Power BI <font size=2>
SQL Server Analysis Services KPI <font size=2>Excel, Power BI <font size=2>
SQL Server Analysis Services measure <font size=2>Excel, Power BI <font size=2>
SQL Server Analysis Services table <font size=2>Excel, Power BI <font size=2>
SQL Server Reporting Services report <font size=2>Browser <font size=2>Native mode servers only. SharePoint mode is not supported.
SQL Server table <font size=2>Excel, Power BI, SQL Server data tools <font size=2>
SQL Server view <font size=2>Excel, Power BI, SQL Server data tools <font size=2>
Teradata table <font size=2>Excel <font size=2>
Teradata view <font size=2>Excel <font size=2>
SAP HANA view <font size=2>Power BI <font size=2>
DB2 table <font size=2> <font size=2>
DB2 view <font size=2> <font size=2>
File system file <font size=2> <font size=2>
FTP directory <font size=2> <font size=2>
FTP file <font size=2> <font size=2>
HTTP report <font size=2> <font size=2>
HTTP endpoint <font size=2> <font size=2>
HTTP file <font size=2> <font size=2>
OData entity set <font size=2> <font size=2>
OData function <font size=2> <font size=2>
PostgreSQL table <font size=2> <font size=2>
PostgreSQL view <font size=2> <font size=2>
SAP HANA view <font size=2> <font size=2>
Salesforce object <font size=2> <font size=2>
SharePoint list <font size=2> <font size=2>
Azure Cosmos DB collection <font size=2> <font size=2>
Generic ODBC table <font size=2> <font size=2>
Generic ODBC view <font size=2> <font size=2>
Cassandra table <font size=2> <font size=2>Publish as a generic ODBC asset
Cassandra view <font size=2> <font size=2>Publish as a generic ODBC asset
Sybase table <font size=2> <font size=2>
Sybase view <font size=2> <font size=2>
MongoDB table <font size=2> <font size=2>Publish as a generic ODBC asset
MongoDB view <font size=2> <font size=2>Publish as a generic ODBC asset

If you need support for additional sources, submit a feature request to the Azure Data Catalog forum.

Data-source reference specification

Note

The DSL structure column in the following table lists only the connection properties for "address" property bag that are used by Azure Data Catalog. That is, "address" property bag can contain other connection properties of the data source which Azure Data Catalog persists, but does not use.

Source type Asset type Object types DSL structure
Azure Data Lake Store Container Data Lake <font size=2> Protocol: webhdfs
Authentication: {basic, oauth}
Address:
      url
Azure Data Lake Store Table Directory, file <font size=2> Protocol: webhdfs
Authentication: {basic, oauth}
Address:
      url
Azure Storage Container Container <font size=2> Protocol: azure-blobs
Authentication: {azure-access-key}
Address:
      domain
      account
      container
Azure Storage Table Blob, directory <font size=2> Protocol: azure-blobs
Authentication: {azure-access-key}
Address:
      domain
      account
      container
      name
Azure Storage Container Container <font size=2> Protocol: azure-tables
Authentication: {azure-access-key}
Address:
      domain
      account
Azure Storage Table Table <font size=2> Protocol: azure-tables
Authentication: {azure-access-key}
Address:
      domain
      account
      name
Cosmos Container Virtual cluster <font size=2> Protocol: cosmos
Authentication: {basic, windows}
Address:
      url
Cosmos Table Stream, stream set, view <font size=2> Protocol: cosmos
Authentication: {basic, windows}
Address:
      url
Datazen Container Site <font size=2> Protocol: http
Authentication: {none, basic, windows, oauth}
Address:
      url
Datazen Report Report, dashboard <font size=2> Protocol: http
Authentication: {none, basic, windows, oauth}
Address:
      url
DB2 Container Database <font size=2> Protocol: db2
Authentication: {basic, windows}
Address:
      server
      database
DB2 Table Table, view <font size=2> Protocol: db2
Authentication: {basic, windows}
Address:
      server
      database
      object
      schema
File system Table File <font size=2> Protocol: file
Authentication: {none, basic, windows}
Address:
      path
FTP Table Directory, file <font size=2> Protocol: ftp
Authentication: {none, basic, windows}
Address:
      url
Hadoop Distributed File System Container Cluster <font size=2> Protocol: webhdfs
Authentication: {basic, oauth}
Address:
      url
Hadoop Distributed File System Table Directory, file <font size=2> Protocol: webhdfs
Authentication: {basic, oauth}
Address:
      url
Hive Container Database <font size=2> Protocol: hive
Authentication: {HDInsight, basic, username, none}
Address:
      server
      database
connectionProperties:
      serverProtocol: {hive2}
Hive Table Table, view <font size=2> Protocol: hive
Authentication: {HDInsight, basic, username, none}
Address:
      server
      database
      object
connectionProperties:
      serverProtocol: {hive2}
HTTP Container Site <font size=2> Protocol: http
Authentication: {none, basic, windows, oauth}
Address:
      url
HTTP Report Report, dashboard <font size=2> Protocol: http
Authentication: {none, basic, windows, oauth}
Address:
      url
HTTP Table Endpoint, file <font size=2> Protocol: http
Authentication: {none, basic, windows, oauth}
Address:
      url
MySQL Container Database <font size=2> Protocol: mysql
Authentication: {protocol, windows}
Address:
      server
      database
MySQL Table Table, view <font size=2> Protocol: mysql
Authentication: {protocol, windows}
Address:
      server
      database
      object
OData Container Entity container <font size=2> Protocol: odata
Authentication: {none, basic, windows}
Address:
      url
OData Table Entity set, function <font size=2> Protocol: odata
Authentication: {none, basic, windows}
Address:
      url
      resource
Oracle Database Container Database <font size=2> Protocol: oracle
Authentication: {protocol, windows}
Address:
      server
      database
Oracle Database Table Table, view <font size=2> Protocol: oracle
Authentication: {protocol, windows}
Address:
      server
      database
      schema
      object
PostgreSQL Container Database <font size=2> Protocol: postgresql
Authentication: {basic, windows}
Address:
      server
      database
PostgreSQL Table Table, view <font size=2> Protocol: postgresql
Authentication: {basic, windows}
Address:
      server
      database
      schema
      object
Power BI Container Site <font size=2> Protocol: http
Authentication: {none, basic, windows, oauth}
Address:
      url
Power BI Report Report, dashboard <font size=2> Protocol: http
Authentication: {none, basic, windows, oauth}
Address:
      url
Power Query Table Data mashup <font size=2> Protocol: power-query
Authentication: {oauth}
Address:
      url
Salesforce Table Object <font size=2> Protocol: salesforce-com
Authentication: {basic, windows}
Address:
      loginServer
      class
      itemName
SAP HANA Container Server <font size=2> Protocol: sap-hana-sql
Authentication: {protocol, windows}
Address:
      server
SAP HANA Table View <font size=2> Protocol: sap-hana-sql
Authentication: {protocol, windows}
Address:
      server
      schema
      object
SharePoint Table List <font size=2> Protocol: sharepoint-list
Authentication: {basic, windows}
Address:
      url
SQL Data Warehouse Command Stored procedure <font size=2> Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
      schema
      object
SQL Data Warehouse TableValuedFunction Table-valued function <font size=2> Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
      schema
      object
SQL Data Warehouse Container Database <font size=2> Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
SQL Data Warehouse Table Table, view <font size=2> Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
      schema
      object
SQL Server Command Stored procedure <font size=2> Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
      schema
      object
SQL Server TableValuedFunction Table-valued function <font size=2> Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
      schema
      object
SQL Server Container Database <font size=2> Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
SQL Server Table Table, view <font size=2> Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
      schema
      object
SQL Server Analysis Services multidimensional Container Model <font size=2> Protocol: analysis-services
Authentication: {windows, basic, anonymous, none}
Address:
      server
      database
      model
SQL Server Analysis Services multidimensional KPI KPI <font size=2> Protocol: analysis-services
Authentication: {windows, basic, anonymous, none}
Address:
      server
      database
      model
      object
      objectType: {KPI}
SQL Server Analysis Services multidimensional Measure Measure <font size=2> Protocol: analysis-services
Authentication: {windows, basic, anonymous, none}
Address:
      server
      database
      model
      object
      objectType: {Measure}
SQL Server Analysis Services multidimensional Table Dimension <font size=2> Protocol: analysis-services
Authentication: {windows, basic, anonymous, none}
Address:
      server
      database
      model
      object
      objectType: {Dimension}
SQL Server Analysis Services tabular Container Model <font size=2> Protocol: analysis-services
Authentication: {windows, basic, anonymous, none}
Address:
      server
      database
      model
SQL Server Analysis Services tabular KPI KPI <font size=2> Protocol: analysis-services
Authentication: {windows, basic, anonymous, none}
Address:
      server
      database
      model
      object
      objectType: {KPI}
SQL Server Analysis Services tabular Measure Measure <font size=2> Protocol: analysis-services
Authentication: {windows, basic, anonymous, none}
Address:
      server
      database
      model
      object
      objectType: {Measure}
SQL Server Analysis Services tabular Table Table <font size=2> Protocol: analysis-services
Authentication: {windows, basic, anonymous, none}
Address:
      server
      database
      model
      object
      objectType: {Table}
SQL Server Reporting Services Container Server <font size=2> Protocol: reporting-services
Authentication: {windows}
Address:
      server
      version: {ReportingService2010}
SQL Server Reporting Services Report Report <font size=2> Protocol: reporting-services
Authentication: {windows}
Address:
      server
      path
      version: {ReportingService2010}
Teradata Container Database <font size=2> Protocol: teradata
Authentication: {protocol, windows}
Address:
      server
      database
Teradata Table Table, view <font size=2> Protocol: teradata
Authentication: {protocol, windows}
Address:
      server
      database
      object
SQL Server Master Data Services Container Model Protocol: mssql-mds
Authentication: {windows}
Address:
      url
      model
      version
SQL Server Master Data Services Table Entity Protocol: mssql-mds
Authentication: {windows}
Address:
      url
      model
      version
      entity
Azure Cosmos DB Container Database <font size=2> Protocol: document-db
Authentication: {azure-access-key}
Address:
      url
      database
Azure Cosmos DB Collection Collection <font size=2> Protocol: document-db
Authentication: {azure-access-key}
Address:
      url
      database
      collection
Generic ODBC Container Database <font size=2> Protocol: odbc
Authentication: {basic, windows}
Address:
      options
      database
Generic ODBC Table Table, View <font size=2> Protocol: odbc
Authentication: {basic, windows}
Address:
      options
      database
      object
      schema
Sybase Container Database <font size=2> protocol: sybase
authentication: {basic, windows}
address:
      server
      database
Sybase Table Table, View <font size=2> protocol: sybase
authentication: {basic, windows}
address:
      server
      database
      schema
      object
Other (none of the above) * * <font size=2> Protocol: generic-asset
Address:
      assetId