Origini dati supportate in Azure Data CatalogSupported data sources in Azure Data Catalog

È possibile pubblicare metadati usando un'API pubblica o uno strumento di registrazione di tipo ClickOnce oppure immettendo manualmente le informazioni direttamente nel portale Web di 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. La tabella seguente fornisce un riepilogo di tutte le origini dati supportate attualmente dal catalogo e delle relative funzionalità di pubblicazione.The following table summarizes all data sources that are supported by the catalog today, and the publishing capabilities for each. Sono anche elencati gli strumenti dati esterni che ogni origine dati può avviare dal portale.Also listed are the external data tools that each data source can launch from our portal "open-in" experience. La seconda tabella contiene una specifica più tecnica della proprietà di connessione delle singole origini dati.The second table contains a more technical specification of each data-source connection property.

Elenco di origini dati supportateList of supported data sources

Oggetto origine datiData source object APIAPI Immissione manualeManual entry Strumento di registrazioneRegistration tool Strumenti di aperturaOpen-in tools NoteNotes
Directory di Azure Data Lake StoreAzure Data Lake Store directory
File di Azure Data Lake StoreAzure Data Lake Store file
Archivio BLOB di AzureAzure Blob storage Power BI DesktopPower BI Desktop
Directory di archiviazione di AzureAzure Storage directory Power BI DesktopPower BI Desktop
Tabella di archiviazione di AzureAzure Storage table
Directory HDFSHDFS directory
File HDFSHDFS file
Tabella HiveHive table ExcelExcel
Vista di HiveHive view ExcelExcel
Tabella MySQLMySQL table Excel, Power BI DesktopExcel, Power BI Desktop
Vista MySQLMySQL view Excel, Power BI DesktopExcel, Power BI Desktop
Tabella di Database OracleOracle Database table Excel, Power BI DesktopExcel, Power BI Desktop
Vista di Database OracleOracle Database view Excel, Power BI DesktopExcel, Power BI Desktop
Altro (asset generico)Other (generic asset)
Tabella di Azure SQL Data WarehouseAzure SQL Data Warehouse table Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools
Vista di SQL Data WarehouseSQL Data Warehouse view Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools
Dimensione di SQL Server Analysis ServicesSQL Server Analysis Services dimension Excel, Power BI DesktopExcel, Power BI Desktop
KPI di SQL Server Analysis ServicesSQL Server Analysis Services KPI Excel, Power BI DesktopExcel, Power BI Desktop
Misura di SQL Server Analysis ServicesSQL Server Analysis Services measure Excel, Power BI DesktopExcel, Power BI Desktop
Tabella di SQL Server Analysis ServicesSQL Server Analysis Services table Excel, Power BI DesktopExcel, Power BI Desktop
Report di SQL Server Reporting ServicesSQL Server Reporting Services report BrowserBrowser Solo server in modalità nativa.Native mode servers only. Modalità SharePoint non supportata.SharePoint mode is not supported.
Tabella di SQL ServerSQL Server table Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools
Visualizzazione SQL ServerSQL Server view Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools
Tabella TeradataTeradata table ExcelExcel
Visualizzazione TeradataTeradata view ExcelExcel
Vista di SAP HANASAP HANA view Power BI DesktopPower BI Desktop
Tabella di DB2DB2 table
Vista di DB2DB2 view
File del file systemFile system file
Directory FTPFTP directory
File FTPFTP file
Report HTTPHTTP report
Endpoint HTTPHTTP endpoint
File HTTPHTTP file
Set di entità ODataOData entity set
Funzione ODataOData function
Tabella di PostgreSQLPostgreSQL table
Vista di PostgreSQLPostgreSQL view
Vista di SAP HANASAP HANA view
Oggetto SalesforceSalesforce object
Elenco SharePointSharePoint list
Raccolta di Azure Cosmos DBAzure Cosmos DB collection
Tabella ODBC genericaGeneric ODBC table
Visualizzazione ODBC genericaGeneric ODBC view
Tabella CassandraCassandra table Pubblicare come asset ODBC genericoPublish as a generic ODBC asset
Vista CassandraCassandra view Pubblicare come asset ODBC genericoPublish as a generic ODBC asset
Tabella SybaseSybase table
Vista SybaseSybase view
Tabella MongoDBMongoDB table Pubblicare come asset ODBC genericoPublish as a generic ODBC asset
Vista MongoDBMongoDB view Pubblicare come asset ODBC genericoPublish as a generic ODBC asset

Se si è interessati al supporto di un'origine dati specifica, scrivere un suggerimento in proposito (o esprimere il proprio sostegno se già suggerito) andando su Data Catalog in Azure Feedback Forums.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.

Specifica di riferimento per l'origine datiData-source reference specification

Nota

La colonna Struttura DSL nella tabella seguente elenca solo le proprietà di connessione per il contenitore di proprietà "indirizzo" usate da Azure Data Catalog.The DSL structure column in the following table lists only the connection properties for "address" property bag that are used by Azure Data Catalog. Ovvero, l'elenco di proprietà "indirizzo" può contenere altre proprietà di connessione dell'origine dati che Azure Data Catalog mantiene ma non usa.That is, "address" property bag can contain other connection properties of the data source which Azure Data Catalog persists, but does not use.

Tipo di origineSource type Tipo di assetAsset type Tipi di oggettiObject types Struttura DSLDSL structure
Archivio Azure Data LakeAzure Data Lake Store ContenitoreContainer 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
Cosmos Container Virtual cluster Protocol: cosmos
Authentication: {basic, windows}
Address:
      url
Cosmos Table Stream, stream set, view Protocol: cosmos
Authentication: {basic, windows}
Address:
      url
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