Connectors

Connectors

A connector is the kind of system a source or target talks to. Every project uses one connector for its source and any mix of connectors for its targets.

	Dataverse / Dynamics 365	SQL Server	CSV file
Source	FetchXML query	SQL query	Every row of the file
Insert	✓	✓	✓ (appends a row)
Update, upsert, delete	✓	✓	—
Execute	On-demand workflow	Stored procedure	—
`LOOKUP()`	✓	✓	✓
Connection in XrmToolBox	XrmToolBox connection	Connection dialog	File and format
Connection outside XrmToolBox	ServiceClient connection string	SQL connection string	File path

Dataverse / Dynamics 365

FetchXML, lookups, choices, party lists, workflows and write options.

Queries, tables, stored procedures, types and identities.

Delimiters, encodings, headers, quoting and append or replace.

Last updated on October 29, 2026