Orígenes de datos compatibles en Azure Data CatalogSupported data sources in Azure Data Catalog

Pueden publicarse metadatos mediante una API pública o una herramienta de registro con un solo clic, o mediante la especificación manual de información directamente en el portal web de 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. En la siguiente tabla se resumen todos los orígenes que admite el catálogo actualmente y las funcionalidades de publicación de cada uno de ellos.The following table summarizes all data sources that are supported by the catalog today, and the publishing capabilities for each. También se enumeran las herramientas de datos externas que cada origen puede iniciar desde nuestra experiencia "abierta" del portal.Also listed are the external data tools that each data source can launch from our portal "open-in" experience. La segunda tabla contiene una especificación más técnica de las propiedades de conexión de cada propiedad de la conexión del origen de datos.The second table contains a more technical specification of each data-source connection property.

Lista de orígenes de datos que se admitenList of supported data sources

Objeto de origen de datosData source object APIAPI Entrada manualManual entry Herramienta de registroRegistration tool Herramientas abiertasOpen-in tools NotasNotes
Directorio de Azure Data Lake Store (solo Gen 1)Azure Data Lake Store directory (Only Gen 1)
Archivo de Azure Data Lake Store (solo Gen 1)Azure Data Lake Store file (Only Gen 1)
Azure Blob StorageAzure Blob storage Power BI DesktopPower BI Desktop
Directorio de Azure StorageAzure Storage directory Power BI DesktopPower BI Desktop
Tabla de Azure StorageAzure Storage table
Directorio de HDFSHDFS directory
Archivo de HDFSHDFS file
Tabla de HiveHive table ExcelExcel
Vista de HiveHive view ExcelExcel
Tabla de MySQLMySQL table Excel, Power BI DesktopExcel, Power BI Desktop
Vista de MySQLMySQL view Excel, Power BI DesktopExcel, Power BI Desktop
Tabla de Oracle DatabaseOracle Database table Excel, Power BI DesktopExcel, Power BI Desktop Oracle 10 y versiones posteriores.Oracle 10 and later versions.
Vista de Oracle DatabaseOracle Database view Excel, Power BI DesktopExcel, Power BI Desktop Oracle 10 y versiones posteriores.Oracle 10 and later versions.
Otro (recurso genérico)Other (generic asset)
Tabla de Azure SQL Data WarehouseAzure SQL Data Warehouse table Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools
Vista de Azure SQL Data WarehouseAzure SQL Data Warehouse view Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools
Dimensión de SQL Server Analysis ServicesSQL Server Analysis Services dimension Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 y versiones posteriores.SQL Server 2008 and later versions.
KPI de SQL Server Analysis ServicesSQL Server Analysis Services KPI Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 y versiones posteriores.SQL Server 2008 and later versions.
Medida de SQL Server Analysis ServicesSQL Server Analysis Services measure Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 y versiones posteriores.SQL Server 2008 and later versions.
Tabla de SQL Server Analysis ServicesSQL Server Analysis Services table Excel, Power BI DesktopExcel, Power BI Desktop SQL Server 2008 y versiones posteriores.SQL Server 2008 and later versions.
Informe de SQL Server Reporting ServicesSQL Server Reporting Services report BrowserBrowser Solo servidores de modo nativo.Native mode servers only. No se admite el modo de SharePoint.SharePoint mode is not supported. Solo SQL Server 2008 y versiones posterioresSQL Server 2008 and later versions only
Tabla de SQL ServerSQL Server table Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools SQL Server 2008 y versiones posteriores.SQL Server 2008 and later versions.
Vista de SQL ServerSQL Server view Excel, Power BI Desktop, SQL Server Data ToolsExcel, Power BI Desktop, SQL Server data tools SQL Server 2008 y versiones posteriores.SQL Server 2008 and later versions.
Tabla de TeradataTeradata table ExcelExcel
Vista de TeradataTeradata view ExcelExcel
SAP Business WarehouseSAP Business Warehouse Funciona solo en inglés.Only works in English. No se admiten las medidas.Measures are unsupported.
Vista de SAP HANASAP HANA view Power BI DesktopPower BI Desktop
Tabla de DB2DB2 table
Vista de DB2DB2 view
Archivo de sistema de archivosFile system file
Directorio FTPFTP directory
Archivo FTPFTP file
Informe HTTPHTTP report
Punto de conexión HTTPHTTP endpoint
Archivo HTTPHTTP file
Conjunto de entidades de ODataOData entity set
Función de ODataOData function
Tabla de PostgreSQLPostgreSQL table
Vista de PostgreSQLPostgreSQL view
Vista de SAP HANASAP HANA view
Objeto de SalesforceSalesforce object
Lista de SharePointSharePoint list
Colección de Azure Cosmos DBAzure Cosmos DB collection Solo son compatibles las colecciones heredadas de Azure DocumentDB y las colecciones de SQL API de Azure Cosmos DB.Only legacy collections from Azure DocumentDB and SQL API collections in Azure Cosmos DB are compatible. Aún no se admiten las API de Cosmos DB más recientes.Newer Cosmos DB APIs are not yet supported. Elija Azure DocumentDB en la lista Origen de datos.Choose Azure DocumentDB in the Data Source list.
Tabla ODBC genéricaGeneric ODBC table
Vista de ODBC genéricaGeneric ODBC view
Tabla de CassandraCassandra table Publicar como un recurso ODBC genéricoPublish as a generic ODBC asset
Vista de CassandraCassandra view Publicar como un recurso ODBC genéricoPublish as a generic ODBC asset
Tabla de SybaseSybase table
Vista de SybaseSybase view
Tabla de MongoDBMongoDB table Publicar como un recurso ODBC genéricoPublish as a generic ODBC asset
Vista de MongoDBMongoDB view Publicar como un recurso ODBC genéricoPublish as a generic ODBC asset

Si desea que un origen de datos concreto sea compatible, sugiéralo (o indique que está de acuerdo con esta sugerencia si ya se ha planteado) en el foro de comentarios de Azure Data Catalog.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.

Especificación de referencia de origen de datosData-source reference specification

Nota

La columna Estructura de DSL de la tabla siguiente solo enumera las propiedades de conexión del contenedor de propiedades "dirección" que usa 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. Es decir, el contenedor de propiedades "dirección" puede contener otras propiedades de conexión del origen de datos que Azure Data Catalog conserva, pero no utiliza.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 origenSource type Tipo de recursoAsset type Tipos de objetoObject types Estructura de DSLDSL structure
Azure Data Lake StoreAzure Data Lake Store ContenedorContainer 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