Oversigt over connector

Data Factory forbinder til mange typer datalagre ved hjælp af indbyggede forbindelser. Disse connectors hjælper dig med at indbringe eller transformere data ved at bruge dataflow Gen2, pipelines eller copy jobs. 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:

Understøttede connectors i Fabric

Fabric understøtter disse connectors i dataflow Gen2, pipelines og copy jobs. Vælg et datalager for at se, hvad det kan gøre, og hvordan du konfigurerer det.

Tips

For mere detaljeret tilgængelighed af copy job-funktioner, se understøttede funktioner by connector for Copy job.

Connector Dataflow Gen2 (kilde/destination) Pipeline (kopi af aktivitetskilde/destination) Kopieringsjob (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 ✓/−
Dataverse ✓/− ✓/✓ ✓/✓
Delta-deling ✓/−
Denodo ✓/−
Dremio Cloud ✓/−
Dremio-software ✓/−
Dynamics 365 Business Central ✓/−
Dynamics 365 Customer Insights (beta) ✓/−
Dynamics 365 ✓/✓ ✓/✓
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 ✓/✓ ✓/✓ ✓/✓
KQL-database i Fabric ✓/✓ ✓/✓
Lakehouse in Fabric ✓/✓ ✓/✓ ✓/✓
SQL-database i Fabric (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 ✓/−
MicroStrategy 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 ✓/−
PDF ✓/−
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 DirectQuery-connector ✓/−
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 ✓/−
SurveyMonkey ✓/−
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) ✓/−

TLS 1.3-support

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- ✓ ✓
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 ✓ ✓

Relateret indhold

  • Sidst opdateret den