Von Azure Data Catalog unterstützte DatenquellenSupported data sources in Azure Data Catalog

Sie können Metadaten auf verschiedene Weisen veröffentlichen: Sie können eine öffentliche API nutzen, ein ClickOnce-Registrierungstool verwenden oder die Informationen direkt in das Azure Data Catalog-Webportal eingeben.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. In der folgenden Tabelle sind alle derzeit vom Katalog unterstützten Datenquellen zusammengefasst. Außerdem werden die jeweiligen Veröffentlichungsmöglichkeiten genannt.The following table summarizes all data sources that are supported by the catalog today, and the publishing capabilities for each. Ferner sind die externen Datentools aufgelistet, in denen die jeweiligen Datenquelle direkt im Portal geöffnet werden kann.Also listed are the external data tools that each data source can launch from our portal "open-in" experience. Die zweite Tabelle enthält weitere technische Angaben zu den Verbindungseigenschaften der einzelnen Datenquellen.The second table contains a more technical specification of each data-source connection property.

Liste der unterstützten DatenquellenList of supported data sources

DatenquellenobjektData source object APIAPI Manuelle EingabeManual entry RegistrierungstoolRegistration tool Tool für „Öffnen in“Open-in tools HinweiseNotes
Azure Data Lake Storage-Verzeichnis (nur Gen 1)Azure Data Lake Store directory (Only Gen 1)
Azure Data Lake Storage-Datei (nur Gen 1)Azure Data Lake Store file (Only Gen 1)
Azure Blob StorageAzure Blob storage Power BI DesktopPower BI Desktop
Azure Storage-VerzeichnisAzure Storage directory Power BI DesktopPower BI Desktop
Azure Storage-TabelleAzure Storage table
HDFS-VerzeichnisHDFS directory
HDFS-DateiHDFS file
Hive-TabelleHive table ExcelExcel
Struktur anzeigenHive view ExcelExcel
MySQL-TabelleMySQL table Excel, Power BI DesktopExcel, Power BI Desktop
MySQL-SichtMySQL view Excel, Power BI DesktopExcel, Power BI Desktop
Oracle Database-TabelleOracle Database table Excel, Power BI DesktopExcel, Power BI Desktop
Oracle Database-SichtOracle Database view Excel, Power BI DesktopExcel, Power BI Desktop
Anderes (generisches Objekt)Other (generic asset)
Azure SQL Data Warehouse-TabelleAzure SQL Data Warehouse table Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools
Ansicht von Azure SQL Data WarehouseAzure SQL Data Warehouse view Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools
SQL Server Analysis Services-DimensionSQL Server Analysis Services dimension Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 und neuere Versionen.SQL Server 2008 and later versions.
SQL Server Analysis Services-KPISQL Server Analysis Services KPI Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 und neuere Versionen.SQL Server 2008 and later versions.
SQL Server Analysis Services-MeasureSQL Server Analysis Services measure Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 und neuere Versionen.SQL Server 2008 and later versions.
SQL Server Analysis Services-TabelleSQL Server Analysis Services table Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 und neuere Versionen.SQL Server 2008 and later versions.
SQL Server Reporting Services-BerichtSQL Server Reporting Services report "Browser"Browser Nur Server im nativen Modus.Native mode servers only. SharePoint-Modus wird nicht unterstützt.SharePoint mode is not supported. Nur SQL Server 2008 und neuere VersionenSQL Server 2008 and later versions only
SQL Server-TabelleSQL Server table Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools SQL Server 2008 und neuere Versionen.SQL Server 2008 and later versions.
SQL Server-SichtSQL Server view Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools SQL Server 2008 und neuere Versionen.SQL Server 2008 and later versions.
Teradata-TabelleTeradata table ExcelExcel
Teradata-SichtTeradata view ExcelExcel
SAP Business WarehouseSAP Business Warehouse Funktioniert nur auf Englisch.Only works in English. Maßeinheiten werden nicht unterstützt.Measures are unsupported.
SAP HANA-SichtSAP HANA view Power BI DesktopPower BI Desktop
DB2-TabelleDB2 table
DB2-SichtDB2 view
Datei im DateisystemFile system file
FTP-VerzeichnisFTP directory
FTP-DateiFTP file
HTTP-BerichtHTTP report
HTTP-EndpunktHTTP endpoint
HTTP-DateiHTTP file
OData-EntitätenmengeOData entity set
OData-FunktionOData function
PostgreSQL-TabellePostgreSQL table
PostgreSQL-SichtPostgreSQL view
SAP HANA-SichtSAP HANA view
Salesforce-ObjektSalesforce object
SharePoint-ListeSharePoint list
Azure Cosmos DB-SammlungAzure Cosmos DB collection Es sind nur ältere Sammlungen von Azure DocumentDB und SQL-API-Sammlungen in Azure Cosmos DB kompatibel.Only legacy collections from Azure DocumentDB and SQL API collections in Azure Cosmos DB are compatible. Neuere Cosmos DB-APIs werden noch nicht unterstützt.Newer Cosmos DB APIs are not yet supported. Wählen Sie Azure DocumentDB in der Liste der Datenquellen aus.Choose Azure DocumentDB in the Data Source list.
Generische ODBC-TabelleGeneric ODBC table
Generische ODBC-SichtGeneric ODBC view
Cassandra-TabelleCassandra table Als generisches ODBC-Objekt veröffentlichenPublish as a generic ODBC asset
Cassandra-SichtCassandra view Als generisches ODBC-Objekt veröffentlichenPublish as a generic ODBC asset
Sybase-TabelleSybase table
Sybase-SichtSybase view
MongoDB-TabelleMongoDB table Als generisches ODBC-Objekt veröffentlichenPublish as a generic ODBC asset
MongoDB-SichtMongoDB view Als generisches ODBC-Objekt veröffentlichenPublish as a generic ODBC asset

Wenn Sie für eine bestimmte Datenquelle Unterstützung wünschen, können Sie diese in den Azure-Foren für Feedback zu Data Catalog vorschlagen (oder eine ggf. bereits vorhandene Anfrage unterstützen).If you want to see a specific data source supported, suggest it (or voice your support if it has already been suggested) by going to the Data Catalog on the Azure Feedback Forums.

DatenquellenreferenzData-source reference specification

Hinweis

Die Spalte DSL-Struktur in der folgenden Tabelle listet nur die Verbindungseigenschaften für den Eigenschaftenbehälter „address“ auf, die von Azure Data Catalog verwendet werden.The DSL structure column in the following table lists only the connection properties for "address" property bag that are used by Azure Data Catalog. Der Eigenschaftenbehälter „address“ kann also andere Verbindungseigenschaften der Datenquelle enthalten, die Azure Data Catalog beibehält, jedoch nicht verwendet.That is, "address" property bag can contain other connection properties of the data source which Azure Data Catalog persists, but does not use.

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