Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
Data Factory i Microsoft Fabric opretter forbindelse til mange typer datalagre ved hjælp af indbyggede connectorer. Disse connectorer hjælper dig med at hente eller transformere data med Dataflow Gen2, pipelines eller kopijob. Vælg den connector, du skal bruge for at komme i gang.
Prerequisites
Før du opretter en forbindelse, skal du sikre dig, at du har:
- En Microsoft Fabric-lejerkonto med et aktivt abonnement. Opret en konto gratis.
- Et Microsoft Fabric-aktiveret arbejdsområde. Opret et arbejdsområde.
Understøttede connectors i Fabric
Fabric understøtter disse connectorer i Dataflow Gen2, pipelines og kopijob. Vælg et datalager for at se, hvad det kan gøre, og hvordan du konfigurerer det.
| Connector | Dataflow Gen2 (kilde/destination) | Pipeline (kopi af aktivitetskilde/destination) | Kopiér job (kilde/destination) |
|---|---|---|---|
| Access | ✓/− | ||
| Acterys: Model Automation & Planning (beta) | ✓/− | ||
| Actian (beta) | ✓/− | ||
| Active Directory | ✓/− | ||
| Adobe Analytics | ✓/− | ||
| ADPAnalytics (beta) | ✓/− | ||
| Amazonas Athena | ✓/− | ||
| Amazon OpenSearch Service (beta) | ✓/− | ||
| Amazon RDS til Oracle | ✓/− | ✓/− | |
| Amazon RDS til SQL Server- | ✓/− | ✓/− | |
| Amazon Redshift | ✓/− | ✓/− | |
| Amazon S3 | ✓/✓ | ✓/✓ | |
| Amazon S3-kompatibel | ✓/✓ | ✓/✓ | |
| Anaplan | ✓/− | ||
| Asana | ✓/− | ||
| Saml visninger | ✓/− | ||
| AtScale-terninger | ✓/− | ||
| Autodesk Construction Cloud | ✓/− | ||
| Automatisering overalt | ✓/− | ||
| Automy Analytics | ✓/− | ||
| Azure AI-søgning | −/✓ | −/✓ | |
| Azure Analysis Services | ✓/− | ||
| Azure Blobs | ✓/− | ✓/✓ | ✓/✓ |
| Azure Cosmos DB til MongoDB- | ✓/✓ | ✓/✓ | |
| Azure Cosmos DB til MongoDB vCore (beta) | ✓/− | ||
| Azure Cosmos DB v2 | ✓/− | ✓/✓ | ✓/✓ |
| Azure Cost Management | ✓/− | ||
| Azure Data Explorer (Kusto) | ✓/✓ | ✓/✓ | ✓/✓ |
| Azure Data Lake Storage Gen2 | ✓/− | ✓/✓ | ✓/✓ |
| Azure Database til MySQL- | ✓/✓ | ✓/✓ | |
| Azure-database til PostgreSQL | ✓/✓ | ✓/✓ | |
| Azure Databricks- | ✓/− | ✓/✓ | |
| Azure Files | ✓/✓ | ✓/✓ | |
| Azure HDInsight (HDFS) | ✓/− | ||
| Azure HDInsight Spark | ✓/− | ||
| Azure Resource Graph- | ✓/− | ||
| Azure SQL-database | ✓/✓ | ✓/✓ | ✓/✓ |
| Azure SQL Managed Instance | ✓/✓ | ✓/✓ | |
| Azure Synapse Analytics (SQL DW) | ✓/- | ✓/✓ | ✓/✓ |
| Azure Synapse Analytics-arbejdsområde (beta) | ✓/− | ||
| Azure-tabeller | ✓/− | ✓/✓ | ✓/- |
| BI-stik | ✓/− | ||
| BitSight-sikkerhedsklassifikationer | ✓/− | ||
| Bloomberg-data og -analyse | ✓/− | ||
| BQE KERNE | ✓/− | ||
| BuildingConnected & Trade Tapp | ✓/− | ||
| Cassandra | ✓/− | ✓/− | |
| CData Connect Cloud | ✓/− | ||
| Celonis EMS | ✓/− | ||
| Cherwell (Beta) | ✓/− | ||
| ClickHouse | ✓/− | ||
| CloudBluePSA (beta) | ✓/− | ||
| Kognitiv datafusion (OData) | ✓/− | ||
| Cognite Data Fusion (Rest API) (beta) | ✓/− | ||
| Common Data Service (ældre) | ✓/− | ||
| Datavirtualitet LDW | ✓/− | ||
| Dataklodser | ✓/− | ||
| Dataflow | ✓/− | ||
| Datamarts (beta) | ✓/− | ||
| Dataverse | ✓/− | ✓/✓ | ✓/✓ |
| Delta-deling | ✓/− | ||
| Denodo | ✓/− | ||
| Dremio Cloud | ✓/− | ||
| Dremio-software | ✓/− | ||
| Dynamics 365 Business Central | ✓/− | ||
| Dynamics 365 Customer Insights (beta) | ✓/− | ||
| Dynamik AX | ✓/− | ✓/− | |
| Dynamisk CRM | ✓/✓ | ✓/✓ | |
| Dynatrace Grail DQL (beta) | ✓/− | ||
| Eduframe (Beta) | ✓/− | ||
| Emigo-datakilde | ✓/− | ||
| Entersoft Business Suite | ✓/− | ||
| EQuIS | ✓/− | ||
| eWay-CRM | ✓/− | ||
| Exact Online Premium (beta) | ✓/− | ||
| Exasol | ✓/− | ||
| Excel-projektmappe | ✓/− | ||
| Fabric Data Warehouse | ✓/✓ | ✓/✓ | ✓/✓ |
| Fabric KQL-database | ✓/✓ | ✓/✓ | |
| Stof Lakehouse | ✓/✓ | ✓/✓ | ✓/✓ |
| SQL-database til struktur (beta) | ✓/✓ | ✓/✓ | ✓/✓ |
| FactSet-analyse | ✓/− | ||
| FactSet RMS (beta) | ✓/− | ||
| FHIR | ✓/− | ||
| Folder | ✓/− | ✓/✓ | ✓/✓ |
| FTP | ✓/− | ✓/− | |
| Funnel | ✓/− | ||
| Google Analytics | ✓/− | ||
| Google BigQuery | ✓/− | ✓/− | ✓/− |
| Google BigQuery (Microsoft Entra ID) | ✓/− | ||
| Google Cloud Storage | ✓/✓ | ✓/✓ | |
| Google Sheets | ✓/− | ||
| Greenplum for rørledning | ✓/− | ✓/− | |
| Hadoop distribueret filsystem (HDFS) | ✓/− | ✓/− | |
| Interaktiv HDInsight-forespørgsel | ✓/− | ||
| Hexagon PPM Smart API | ✓/− | ||
| Hive LLAP | ✓/− | ||
| HTTP | ✓/− | ✓/− | |
| IBM Db2-database | ✓/− | ✓/− | ✓/− |
| IBM Netezza | ✓/− | ||
| Impala | ✓/− | ||
| Informix til Pipeline | ✓/✓ | ✓/✓ | |
| Indexima | ✓/− | ||
| Industriel App Store | ✓/− | ||
| InformationGrid | ✓/− | ||
| InterSystems sundhedsindsigt | ✓/− | ||
| Intune Data Warehouse (beta) | ✓/− | ||
| inwink (Beta) | ✓/− | ||
| Jamf Pro | ✓/− | ||
| Jethro (beta) | ✓/− | ||
| JSON | ✓/− | ||
| Kognitwin | ✓/− | ||
| KX kdb Insights Enterprise (beta) | ✓/− | ||
| Kyligence | ✓/− | ||
| Kyvos ODBC (beta) | ✓/− | ||
| LEAP (Beta) | ✓/− | ||
| Linkar PICK Style/MultiValue Databases (beta) | ✓/− | ||
| LinkedIn-læring | ✓/− | ||
| MariaDB | ✓/− | ✓/− | ✓/− |
| MarkLogic | ✓/− | ||
| Microsoft 365 | ✓/− | ||
| Microsoft Access | ✓/✓ | ✓/✓ | |
| Microsoft Azure Data Manager til energi | ✓/− | ||
| Microsoft Exchange Online | ✓/− | ||
| Strategi for Power BI | ✓/− | ||
| MongoDB Atlas til rørledninger | ✓/✓ | ✓/✓ | |
| MongoDB Atlas SQL | ✓/− | ||
| MongoDB til Pipeline | ✓/✓ | ✓/✓ | |
| MySQL-database | ✓/− | ✓/− | ✓/− |
| OData | ✓/− | ✓/− | ✓/− |
| Odbc | ✓/− | ✓/✓ | ✓/✓ |
| OneStream | ✓/− | ||
| OpenSearch-projekt (beta) | ✓/− | ||
| Oracle Cloud Storage | ✓/− | ✓/− | |
| Oracle-database | ✓/− | ✓/✓ | ✓/✓ |
| Palantir Foundry-datasæt | ✓/− | ||
| Parket | ✓/− | ||
| Paxata | ✓/− | ||
| ✓/− | |||
| Planview Enterprise-arkitektur | ✓/− | ||
| Planview IdeaPlace | ✓/− | ||
| Planview OKR (beta) | ✓/− | ||
| Planview Porteføljer | ✓/− | ||
| Planview ProjectPlace | ✓/− | ||
| PostgreSQL-database | ✓/− | ✓/− | ✓/− |
| Power BI-dataflow (ældre) | ✓/− | ||
| Presto | ✓/− | ✓/− | |
| Product Insights (beta) | ✓/− | ||
| Profisee | ✓/− | ||
| QubolePresto (Beta) | ✓/− | ||
| Quickbase | ✓/− | ||
| REST | ✓/✓ | ✓/✓ | |
| Roamler (Beta) | ✓/− | ||
| Salesforce-objekter | ✓/− | ✓/✓ | ✓/✓ |
| Salesforce-rapporter | ✓/− | ||
| Salesforce Service Cloud- | ✓/✓ | ✓/✓ | |
| Samsara | ✓/− | ||
| SAP BW-programserver | ✓/− | ||
| SAP BW-meddelelsesserver | ✓/− | ||
| SAP BW Open Hub Application Server | ✓/− | ✓/− | |
| SAP BW Open Hub-meddelelsesserver | ✓/− | ✓/− | |
| SAP HANA-database | ✓/− | ✓/− | ✓/− |
| SAP Table Application Server | ✓/− | ✓/− | |
| SAP-tabelmeddelelsesserver | ✓/− | ✓/− | |
| ServiceNow | ✓/− | ✓/− | |
| SFTP | ✓/✓ | ✓/✓ | |
| SharePoint-mappe | ✓/✓ | ||
| SharePoint-liste | ✓/− | ||
| SharePoint Online-liste | ✓/− | ✓/− | ✓/− |
| Genveje til Business Insights (beta) | ✓/− | ||
| SingleStore direkte forespørgselsforbindelse | ✓/− | ||
| SIS-CC SDMX (beta) | ✓/− | ||
| Siteimprove | ✓/− | ||
| Smartsheet | ✓/− | ||
| Snowflake | ✓/− | ✓/✓ | ✓/✓ |
| SoftOne BI (beta) | ✓/− | ||
| SolarWinds servicedesk | ✓/− | ||
| Solver | ✓/− | ||
| Spark | ✓/− | ||
| SQL Server-database | ✓/− | ✓/✓ | ✓/✓ |
| Starburst | ✓/− | ||
| Stjerne sikret med Ettra-id | ✓/− | ||
| SumTotal | ✓/− | ||
| Supermetrics | ✓/− | ||
| SurveryMonkey | ✓/− | ||
| Sybase-database | ✓/− | ||
| TeamDesk (Beta) | ✓/− | ||
| Tenforce (Smart)Liste | ✓/− | ||
| Teradata-database | ✓/− | ✓/✓ | |
| Text/CSV | ✓/− | ||
| TIBCO(R)-datavirtualisering | ✓/− | ||
| Topcon Aptix Indsigt | ✓/− | ||
| Usercube (beta) | ✓/− | ||
| Vena | ✓/− | ||
| Vertica | ✓/− | ✓/− | ✓/− |
| Indsigt i fartøjet | ✓/− | ||
| Viva Insights | ✓/− | ||
| Warehouse | ✓/− | ||
| Web-API | ✓/− | ||
| webside | ✓/− | ||
| Webtrends Analytics (beta) | ✓/− | ||
| Windsor | ✓/− | ||
| Witivio (beta) | ✓/− | ||
| Wolters Kluwer CCH Tagetik | ✓/− | ||
| Wrike (beta) | ✓/− | ||
| XML | ✓/− | ||
| Zendesk | ✓/− | ||
| Zoho Skaber | ✓/− | ||
| Zucchetti HR Infinity (beta) | ✓/− |
Understøttelse af TLS 1.3
Transport Layer Security (TLS) er en bredt anvendt sikkerhedsprotokol, der er designet til at sikre forbindelser og kommunikation mellem servere og klienter. Følgende stik understøtter TLS 1.3 for Data Factory:
| Connector | Dataflow Gen2 | Copy activity | Kopier job |
|---|---|---|---|
| Amazon RDS til SQL Server- | ✓ | ✓ | |
| Amazon RDS til SQL Server- | ✓ | ✓ | |
| Azure Blobs | ✓ | ✓ | |
| Azure Data Explorer (Kusto) | ✓ | ✓ | |
| Azure Database for PostgreSQL (version 2.0) | ✓ | ✓ | |
| Azure Files | ✓ | ✓ | |
| Azure SQL-database | ✓ | ✓ | |
| Azure SQL Managed Instance | ✓ | ✓ | |
| Azure Synapse Analytics (SQL DW) | ✓ | ✓ | |
| Azure-tabeller | ✓ | ✓ | |
| IBM Db2-database | ✓ | ✓ | |
| Oracle-database | ✓ | ✓ | |
| PostgreSQL-database | ✓ | ✓ | |
| Snowflake | ✓ | ✓ | |
| SQL Server-database | ✓ | ✓ |