Azure Data Catalog에서 지원되는 데이터 원본Supported data sources in Azure Data Catalog

사용자는 공용 API를 사용하거나 등록 도구 클릭 한 번으로 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 APIAPI 수동 입력Manual entry 등록 도구Registration tool 열기 도구Open-in tools 참고Notes
Azure Data Lake Store directory (Gen 1만 해당)Azure Data Lake Store directory (Only Gen 1)
Azure Data Lake Store 파일 (Gen 1만 해당)Azure Data Lake Store file (Only Gen 1)
Azure Blob 스토리지Azure Blob storage Power BI DesktopPower BI Desktop
Azure Storage 디렉터리Azure Storage directory Power BI DesktopPower BI Desktop
Azure Storage 테이블Azure Storage table
HDFS 디렉터리HDFS directory
HDFS 파일HDFS file
Hive 테이블Hive table ExcelExcel
Hive 보기Hive view ExcelExcel
MySQL 테이블MySQL table Excel, Power BI DesktopExcel, Power BI Desktop
MySQL 뷰MySQL view Excel, Power BI DesktopExcel, Power BI Desktop
Oracle 데이터베이스 테이블Oracle Database table Excel, Power BI DesktopExcel, Power BI Desktop Oracle 10 이상 버전.Oracle 10 and later versions.
Oracle 데이터베이스 뷰Oracle Database view Excel, Power BI DesktopExcel, Power BI Desktop Oracle 10 이상 버전.Oracle 10 and later versions.
기타(일반 자산)Other (generic asset)
Azure SQL Data Warehouse 테이블Azure SQL Data Warehouse table Excel, Power BI Desktop, SQL Server 데이터 도구Excel, Power BI Desktop, SQL Server data tools
Azure SQL Data Warehouse 뷰Azure SQL Data Warehouse view Excel, Power BI Desktop, SQL Server 데이터 도구Excel, Power BI Desktop, SQL Server data tools
SQL Server Analysis Services 차원SQL Server Analysis Services dimension Excel, Power BI DesktopExcel, Power BI Desktop 2008 이상 버전을 SQL Server 합니다.SQL Server 2008 and later versions.
SQL Server Analysis Services KPISQL Server Analysis Services KPI Excel, Power BI DesktopExcel, Power BI Desktop 2008 이상 버전을 SQL Server 합니다.SQL Server 2008 and later versions.
SQL Server Analysis Services 측정값SQL Server Analysis Services measure Excel, Power BI DesktopExcel, Power BI Desktop 2008 이상 버전을 SQL Server 합니다.SQL Server 2008 and later versions.
SQL Server Analysis Services 테이블SQL Server Analysis Services table Excel, Power BI DesktopExcel, Power BI Desktop 2008 이상 버전을 SQL Server 합니다.SQL Server 2008 and later versions.
SQL Server Reporting Services 보고서SQL Server Reporting Services report 브라우저Browser 기본 모드 서버에만 해당.Native mode servers only. SharePoint 모드는 지원되지 않음.SharePoint mode is not supported. SQL Server 2008 이상 버전에만 해당SQL Server 2008 and later versions only
SQL Server 테이블SQL Server table Excel, Power BI Desktop, SQL Server 데이터 도구Excel, Power BI Desktop, SQL Server data tools 2008 이상 버전을 SQL Server 합니다.SQL Server 2008 and later versions.
SQL Server 뷰SQL Server view Excel, Power BI Desktop, SQL Server 데이터 도구Excel, Power BI Desktop, SQL Server data tools 2008 이상 버전을 SQL Server 합니다.SQL Server 2008 and later versions.
Teradata 테이블Teradata table ExcelExcel
Teradata 뷰Teradata view ExcelExcel
SAP Business WarehouseSAP Business Warehouse 영어로만 작동 합니다.Only works in English. 측정값이 지원 되지 않습니다.Measures are unsupported.
SAP HANA 뷰SAP HANA view Power BI DesktopPower BI Desktop
DB2 테이블DB2 table
DB2 뷰DB2 view
파일 시스템 파일File system file
FTP 디렉터리FTP directory
FTP 파일FTP file
HTTP 보고서HTTP report
HTTP 엔드포인트HTTP endpoint
HTTP 파일HTTP file
OData 엔터티 집합OData entity set
OData 함수OData function
PostgreSQL 테이블PostgreSQL table
PostgreSQL 뷰PostgreSQL view
SAP HANA 뷰SAP HANA view
Salesforce 개체Salesforce object
SharePoint 목록SharePoint list
Azure Cosmos DB 컬렉션Azure Cosmos DB collection Azure DocumentDB의 레거시 컬렉션과 Azure Cosmos DB의 SQL API 컬렉션만 호환됩니다.Only legacy collections from Azure DocumentDB and SQL API collections in Azure Cosmos DB are compatible. 최신 Cosmos DB API는 아직 지원되지 않습니다.Newer Cosmos DB APIs are not yet supported. 데이터 원본 목록에서 Azure DocumentDB를 선택하세요.Choose Azure DocumentDB in the Data Source list.
일반 ODBC 테이블Generic ODBC table
일반 ODBC 뷰Generic ODBC view
Cassandra 테이블Cassandra table 일반 ODBC 자산으로 게시Publish as a generic ODBC asset
Cassandra 뷰Cassandra view 일반 ODBC 자산으로 게시Publish as a generic ODBC asset
Sybase 테이블Sybase table
Sybase 뷰Sybase view
MongoDB 테이블MongoDB table 일반 ODBC 자산으로 게시Publish as a generic ODBC asset
MongoDB 뷰MongoDB view 일반 ODBC 자산으로 게시Publish as a generic ODBC asset

특정 데이터 원본이 지원되는지 확인하려는 경우 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.

데이터 원본 참조 사양Data-source reference specification

참고

다음 테이블의 DSL 구조 열에서는 Azure Data Catalog에서 사용되는 "address" 속성 모음에 대한 연결 속성을 나열합니다.The DSL structure column in the following table lists only the connection properties for "address" property bag that are used by Azure Data Catalog. 즉, "address" 속성 모음에는 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 구조DSL structure
Azure Data Lake StoreAzure Data Lake Store 컨테이너Container 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