Included in SSIS PowerPack

SSIS Dynamics CRM / Dataverse / PowerApps Source

Read Dynamics 365 Online, Dataverse, PowerApps or on-premises Dynamics CRM data in Table mode or with FetchXML queries.

Pick a table, or write a FetchXML query with filters, joins, TOP, DISTINCT and GROUP BY, starting from built-in examples or a query exported from CRM Advanced Find. Make it dynamic with SSIS variable placeholders such as {{User::MyVar}}, convert dates between UTC and local time, and connect with OAuth (Azure AD app) for MFA-protected tenants.

The trial includes Dynamics CRM / Dataverse / PowerApps Source and every other PowerPack component

Dynamics CRM Source creating a new connection to Dynamics 365 (CRM Online)
Dynamics CRM Source: create a new connection to Dynamics 365 (CRM Online)

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What Dynamics CRM / Dataverse / PowerApps Source can do

Dynamics CRM / Dataverse Source reads data from Dynamics 365 Online, Dataverse / PowerApps and on-premises CRM into the SSIS data flow, using simple Table mode or a custom FetchXML query.

Table or FetchXML mode

Read Dynamics CRM / Dataverse data in simple Table mode or with a custom FetchXML query.

  • AccessMode: Entity or Fetch XML
  • Dynamics 365 Online, Dataverse, PowerApps or On-Premises CRM

Read Dynamics CRM guide

FetchXML query examples

Start from built-in FetchXML examples for common SQL-style queries.

  • Columns and aliases, WHERE with AND / OR, DISTINCT, TOP
  • GROUP BY with COUNT, SUM, MIN, MAX, AVG
  • Build a query in CRM Advanced Find and paste the downloaded FetchXML

FetchXML examples

Dynamic queries

Use SSIS variables inside the query with placeholders.

  • e.g. {{User::MyVar}}
  • Insert Variable button in the query editor

Variables with FetchXML

UTC / local date conversion

Automatically convert between UTC and local date/time.

  • OutputDateTimeConversionMode for values coming from CRM
  • InputDateTimeConversionMode for query values

Component properties

Object Browser & preview

Intuitive user interface with the Dynamics CRM Object Browser and data preview.

  • Table Info shows PrimaryIdAttribute and PrimaryNameAttribute

See the screenshots

Advanced data types

Read advanced data types such as Lookup, PartyList and Multi-Select PickList.

  • PartyList fields are output as JSON

Special data types

Max rows, batch & deleted

Control how much data is fetched.

  • MaxRows (0 = unlimited) and BatchSize
  • IncludeDeleted to read deleted records

Component properties

SQL Server 2012–2025 & ADF

Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.

  • SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
  • Azure Data Factory (SSIS IR)
  • Design packages in Visual Studio 2017, 2019, 2022, or 2026
  • Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025

Compatibility and requirements

Modern CRM authentication

Connect to Dynamics 365 Online, Dataverse, PowerApps, IFD or On-Premises CRM.

  • AuthType: OAuth Client Credentials, OAuth Delegated (MFA / 2FA), IFD or Active Directory
  • Custom TokenUrl (e.g. US GCC)
  • Retry on throttling (e.g. 429) and proxy settings

Connection Manager help

See all features
  • Table (Entity) or Query (FetchXML) mode to read from Dynamics CRM Online / Dataverse / Dynamics 365 / PowerApps or On-Premises CRM
  • FetchXML query language support with built-in examples
  • Automatic conversion between UTC and local date/time
  • Intuitive user interface with Dynamics CRM Object Browser
  • Advanced data types such as Lookup, PartyList and Multi-Select PickList
  • Data preview, max rows and batch size
  • Dynamic query with SSIS variable placeholders (e.g. {{User::MyVar}})
  • Option to read deleted records (IncludeDeleted)
  • Azure AD App (OAuth) Client Id / Secret for modern security with MFA / 2FA
  • Retry and proxy settings on the Dynamics CRM Connection Manager
  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Connect, pick a table or write FetchXML, preview, then run the data flow.

Connect to Dynamics 365, Dataverse or on-premises CRM.

Create a ZS-DYNAMICS-CRM connection from the source. For Dynamics 365 Online and Dataverse use OAuth 2.0 Client Credentials or OAuth Delegated (interactive sign-in for MFA / 2FA) with an Azure AD app Client Id and Secret; for on-premises CRM use IFD or Active Directory. Select the organization and click Test Connection.

  • Same connection works for CRM Destination
  • Custom TokenUrl (e.g. US GCC)
  • Retry on throttling and proxy settings

Connection manager help

Dynamics CRM Source creating a new connection to Dynamics 365

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Dynamics CRM / Dataverse / PowerApps Source product page. Step through them, or open any shot at full size.

Dynamics CRM Source – Create new connection to Microsoft Dynamics 365

Click New next to the connection dropdown and configure a Dynamics 365 (CRM Online) connection.

Compatibility and requirements

Designed to stay inside your SSIS runtime.

  • SQL Server 2012 through 2025, 32-bit and 64-bit
  • Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
  • Azure Data Factory SSIS Integration Runtime
  • Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
  • Fully functional 30-day trial of SSIS PowerPack

FAQ

Questions teams ask before they drop Dynamics CRM / Dataverse / PowerApps Source on the canvas.

What is Dynamics CRM / Dataverse / PowerApps Source?

It is an SSIS data flow source that reads data from Microsoft Dynamics CRM, including Dynamics 365 Online, Dataverse / PowerApps and on-premises or IFD installations, in simple Table mode or with a custom FetchXML query.

Do I have to write FetchXML by hand?

No. Start from the built-in examples in the query editor, or build the query visually with Advanced Find in the CRM portal and paste the downloaded FetchXML. See the read tutorial for WHERE, TOP, DISTINCT, GROUP BY and JOIN examples.

Can I pass SSIS variables into the query?

Yes. Use placeholders such as {{User::MyVar}} inside the FetchXML, or click Insert Variable in the query editor.

Does it work with MFA-protected Dynamics 365 tenants?

Yes. Use OAuth with an Azure AD app Client Id and Secret: OAuth 2.0 Client Credentials (application permissions) or OAuth Delegated (interactive user sign-in). The older Online Federation mode is deprecated.

Which SQL Server versions can I run it on?

SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install SSIS PowerPack and drag Dynamics CRM / Dataverse / PowerApps Source onto the Data Flow.

Read Dynamics 365, Dataverse and on-premises CRM data with Table mode or FetchXML, and load it into SQL Server or any SSIS destination.

  • Data Flow Source in SSISDynamics CRM / Dataverse / PowerApps Source appears in the toolbox after you install PowerPack.
  • Fully functional 30-day trialSSIS PowerPack, running in your environment.
  • Live supportHelp during your trial and after purchase.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 6