Fontes de dados com suporte no Catálogo de Dados do AzureSupported data sources in Azure Data Catalog

Você pode publicar os metadados usando uma API pública, uma ferramenta de registro com um clique ou inserindo manualmente as informações de forma direta no portal da Web do Catálogo de Dados do Azure.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. A tabela a seguir resume todas as fontes de dados com suporte hoje pelo catálogo e os recursos de publicação para cada uma.The following table summarizes all data sources that are supported by the catalog today, and the publishing capabilities for each. Também estão listadas as ferramentas de dados externos que cada fonte de dados pode inicializar na nossa experiência "aberta" do portal.Also listed are the external data tools that each data source can launch from our portal "open-in" experience. A segunda tabela contém uma especificação mais técnica de cada propriedade de conexão das fontes de dados.The second table contains a more technical specification of each data-source connection property.

Lista das fontes de dados com suporteList of supported data sources

Objeto de fonte de dadosData source object APIAPI Entrada manualManual entry Ferramenta de registroRegistration tool Ferramentas abertasOpen-in tools ObservaçõesNotes
Azure Data Lake Store Directory (somente Gen 1)Azure Data Lake Store directory (Only Gen 1)
Arquivo de Azure Data Lake Store (somente Gen 1)Azure Data Lake Store file (Only Gen 1)
Armazenamento de Blobs do AzureAzure Blob storage Power BI DesktopPower BI Desktop
Diretório de Armazenamento do AzureAzure Storage directory Power BI DesktopPower BI Desktop
Tabela do Armazenamento do AzureAzure Storage table
Diretório do HDFSHDFS directory
Arquivo do HDFSHDFS file
Tabela do HiveHive table ExcelExcel
Exibição de HiveHive view ExcelExcel
Tabela do MySQLMySQL table Excel, Power BI DesktopExcel, Power BI Desktop
Exibição do MySQLMySQL view Excel, Power BI DesktopExcel, Power BI Desktop
Tabela do Oracle DatabaseOracle Database table Excel, Power BI DesktopExcel, Power BI Desktop Oracle 10 e versões posteriores.Oracle 10 and later versions.
Exibição do Oracle DatabaseOracle Database view Excel, Power BI DesktopExcel, Power BI Desktop Oracle 10 e versões posteriores.Oracle 10 and later versions.
Outros (ativo genérico)Other (generic asset)
Tabela do Azure Synapse AnalyticsAzure Synapse Analytics table Excel, Power BI Desktop, ferramentas de dados do SQL ServerExcel, Power BI Desktop, SQL Server data tools
Exibição do Azure Synapse AnalyticsAzure Synapse Analytics view Excel, Power BI Desktop, ferramentas de dados do SQL ServerExcel, Power BI Desktop, SQL Server data tools
Dimensão do SQL Server Analysis ServicesSQL Server Analysis Services dimension Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 e versões posteriores.SQL Server 2008 and later versions.
KPI do SQL Server Analysis ServicesSQL Server Analysis Services KPI Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 e versões posteriores.SQL Server 2008 and later versions.
Medida do SQL Server Analysis ServicesSQL Server Analysis Services measure Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 e versões posteriores.SQL Server 2008 and later versions.
Tabela do SQL Server Analysis ServicesSQL Server Analysis Services table Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 e versões posteriores.SQL Server 2008 and later versions.
Relatório do SQL Server Reporting ServicesSQL Server Reporting Services report NavegadorBrowser Somente os servidores de modo nativo.Native mode servers only. Não há suporte para o modo do SharePoint.SharePoint mode is not supported. Somente SQL Server 2008 e versões posterioresSQL Server 2008 and later versions only
Tabela do SQL ServerSQL Server table Excel, Power BI Desktop, ferramentas de dados do SQL ServerExcel, Power BI Desktop, SQL Server data tools SQL Server 2008 e versões posteriores.SQL Server 2008 and later versions.
Exibição do SQL ServerSQL Server view Excel, Power BI Desktop, ferramentas de dados do SQL ServerExcel, Power BI Desktop, SQL Server data tools SQL Server 2008 e versões posteriores.SQL Server 2008 and later versions.
Tabela do TeradataTeradata table ExcelExcel
Exibição do TeradataTeradata view ExcelExcel
SAP Business WarehouseSAP Business Warehouse Funciona apenas em inglês.Only works in English. Não há suporte para medidas.Measures are unsupported.
Exibição do SAP HANASAP HANA view Power BI DesktopPower BI Desktop
Tabela do DB2DB2 table
Exibição do DB2DB2 view
Arquivo do sistema de arquivosFile system file
Diretório do FTPFTP directory
Arquivo do FTPFTP file
Relatório HTTPHTTP report
Ponto de extremidade HTTPHTTP endpoint
Arquivo HTTPHTTP file
Conjunto de entidades do ODataOData entity set
Função do ODataOData function
Tabela do PostgreSQLPostgreSQL table
Exibição do PostgreSQLPostgreSQL view
Exibição do SAP HANASAP HANA view
Objeto do SalesForceSalesforce object
Lista do SharePointSharePoint list
Coleção do Azure Cosmos DBAzure Cosmos DB collection Somente coleções herdadas do Azure DocumentDB e coleções de API do SQL no Azure Cosmos DB são compatíveis.Only legacy collections from Azure DocumentDB and SQL API collections in Azure Cosmos DB are compatible. APIs do Cosmos DB mais recentes ainda não são compatíveis.Newer Cosmos DB APIs are not yet supported. Escolha o Azure DocumentDB na lista de fontes de dados.Choose Azure DocumentDB in the Data Source list.
Tabela ODBC GenéricaGeneric ODBC table
Exibição ODBC GenéricaGeneric ODBC view
Tabela do CassandraCassandra table Publicar como um ativo ODBC genéricoPublish as a generic ODBC asset
Exibição do CassandraCassandra view Publicar como um ativo ODBC genéricoPublish as a generic ODBC asset
Tabela do SybaseSybase table
Exibição do SybaseSybase view
Tabela do MongoDBMongoDB table Publicar como um ativo ODBC genéricoPublish as a generic ODBC asset
Exibição do MongoDBMongoDB view Publicar como um ativo ODBC genéricoPublish as a generic ODBC asset

Se você quiser ver uma fonte de dados específica com suporte, sugira-a (ou manifeste seu apoio, se ela já tiver sido sugerida) acessando o Fóruns de Comentários do Catálogo de Dados do Azure.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.

Especificação de referência da fonte de dadosData-source reference specification

Observação

A coluna Estrutura de DSL na tabela a seguir lista apenas as propriedades de conexão do recipiente de propriedades "address" que são usadas pelo Catálogo de Dados do Azure.The DSL structure column in the following table lists only the connection properties for "address" property bag that are used by Azure Data Catalog. Ou seja, o recipiente de propriedades "address" pode conter outras propriedades de conexão da fonte de dados que o Catálogo de Dados do Azure persiste, mas não 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 de fonteSource type Tipo de ativoAsset type Tipos de objetoObject types Estrutura de DSLDSL structure
Repositório Azure Data LakeAzure Data Lake Store ContêinerContainer 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
Azure Synapse Analytics Command Stored procedure Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
      schema
      object
Azure Synapse Analytics TableValuedFunction Table-valued function Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
      schema
      object
Azure Synapse Analytics Container Database Protocol: tds
Authentication: {protocol, windows}
Address:
      server
      database
Azure Synapse Analytics 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