The SSIS Integration Toolkit for Microsoft Dynamics 365 makes data integration for Microsoft Dynamics 365, CRM, AX, or NAV easy.

With components that work with all applications found within Dynamics 365, the SSIS Integration Toolkit for Microsoft Dynamics 365 offers the greatest flexibility for your Microsoft Dynamics 365, CRM, AX, or NAV integration projects.

  • Data integration for Microsoft Dynamics 365 Customer Engagement, Finance & Operations, and Business Central as well as Microsoft Dynamics CRM, AX and NAV
  • Powered by the powerful SSIS ETL engine, developers can quickly integrate Microsoft Dynamics 365 with virtually any other application or data system.
  • Full support for Dynamics 365, CRM, AX and NAV means easy integration between applications and versions as well as a simple data migration path for application upgrades.
  • An extremely simplified ETL development experience within a familiar development environment (Microsoft Visual Studio) provides developers the best possible development productivity.
  • Available on its own or as part of a package with our other enterprise data integration solutions in our Ultimate Edition including SharePoint, HubSpot, Active Directory and the SSIS Productivity Pack to enhance development productivity.

Accomplish more with your data

Integrate.  Automate.  Report.  Analyze.  Replicate.

What is included in the SSIS Integration Toolkit for Microsoft Dynamics 365?

Microsoft Dynamics 365 FO/AX Data Integration Components

Microsoft Dynamics AX


Microsoft Dynamics 365 Finance and Operations

Supports connecting to and integration with:

  • Microsoft Dynamics 365 Finance and Operations
  • Microsoft Dynamics AX (4.0 - 2012 R3)

Microsoft Dynamics 365 CE/CRM Data Integration Components

Microsoft Dynamics CRM


Microsoft Dynamics 365 Customer Engagement

Supports connecting to and integration with:

  • Microsoft Dynamics 365 Customer Engagement:
    • Sales
    • Customer Service
    • Field Service
    • Project Service Automation
    • Marketing
  • Microsoft Dynamics CRM (3.0 - 2016)

Microsoft Dynamics 365 BC/NAV Data Integration Components

Microsoft Dynamics NAV


Microsoft Dynamics 365 Business Central

Supports connecting to and integration with:

  • Microsoft Dynamics 365 Business Central
  • Microsoft Dynamics NAV (2009 - 2018)

  • fill

    Codeless Integration

    You do not have to write a single line of code
    to make data integration happen; your development
    can be done in a matter of minutes, which would
    otherwise take weeks or even months


    Unparalleled Performance

    Our software offers many specifically designed
    features that help you achieve the best possible
    data integration performance, while rescuing your
    IT budget


    Flexible and Easy to Use

    We make the most flexible integration solution
    on the market. Our software offers intuitive user
    interfaces that are flexible and easy to use


    Cost Effective

    With a streamlined development experience,
    and a simplified licensing model, our solution
    offers the best value for your investment

  • fill

    Since deployment to our production environment, the run-time
    of the regular daily processing (which was scheduled to
    begin every 15 minutes) has reduced from 15-20 minutes
    to now just 90 seconds using SSIS and KingswaySoft.


    Rob Dawson, Dynamics CRM Consultant, Andrew Sykes Group

Microsoft Dynamics 365 CE/CRM Data Integration Featured Highlights

  • Read data from Microsoft Dynamics 365 CE/CRM server through CRM entity, FetchXML query, EntityChanges, or AuditLogs options.
  • Nine different write actions for writing to 365 CE/CRM server: Create, Update, Delete, Upsert, Merge, Convert, Send, BulkDelete, and ExecuteWorkflow.
  • Four Update and Upsert matching options for the most robust solution to write incremental changes to 365 CE/CRM (Primary Key, CRM Duplicate Detection, Manually Specified Fields, and Alternate Key).
  • Text Lookup feature to perform a lookup to CRM records using either text or integer values as the input.
  • Write to CRM many-to-many relationship without a single line of code.
  • Support for multithreaded writing using one single configuration.

Microsoft Dynamics 365 CRM data integration

Microsoft Dynamics 365 FO/AX Data Integration Featured Highlights

  • Read from AX server using Dynamics AX query statement or through Dynamics 365 for Finance & Operations entity with advanced filtering capabilities.
  • Query Statement supports the use of User and System Variables.
  • Use the AX Next Sequence Number component to retrieve the next sequence number from the AX server.
  • Advanced filtering capabilities for AX field mappings.
  • Write to the 365 FO/AX server through 4 write options: Create, Update, Upsert or Delete.
  • Automatic field mapping to AX fields based on a name-match.
  • Upsert action is based on manually selected matching field(s) with the option to ‘Ignore Unchanged Fields.’
  • Support for multithreaded writing using one single configuration.

Microsoft Dynamics 365 AX data integration

Microsoft Dynamics 365 BC/NAV Data Integration Featured Highlights

  • Built in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.
  • Support for multitenant deployment.
  • Supplementary Parameters support when reading or writing to specific objects.
  • Retrieve data from 365 BC/NAV server using Page Filtering with support for User and System Variables.
  • Optional timeout and proxy server settings.
  • Advanced filtering capabilities to retrieve only the necessary data.
  • Write to Microsoft Dynamics 365 BC/NAV through either Create, Update, Delete or Upsert write actions.
  • Upsert Setting allows developers to choose how to handle multiple matches: Update All Records, Update One Record, Ignore All Records or Raise and Error.
  • Support for multithreaded writing using one single configuration.

Microsoft Dynamics 365 NAV data integration

Technical Requirements

  • SQL Server Integration Services: Azure-SSIS Integration Runtime, Microsoft SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008 or 2005
    • (Microsoft Dynamics 365 CE Online requires SQL Server 2012 or above)
  • Microsoft Dynamics 365/CRM
    • Microsoft Dynamics 365 Customer Engagement (Sales, Customer Service, Field Service, Project Service Automation, and Marketing)
    • Microsoft Dynamics CRM Server 2016, 2015, 2013, 2011, 4.0, or 3.0
  • Microsoft Dynamics 365/NAV
    • Microsoft Dynamics 365 Business Central
    • Microsoft Dynamics NAV 2018, 2017, 2016, 2015, 2013 R2, 2013, 2009 R2, or 2009
  • Microsoft Dynamics 365/AX
    • Microsoft Dynamics 365 Finance and Operations
    • Microsoft Dynamics AX 2012 R3, 2012 R2, 2012, 2009, or 4.0

Featured Case Studies

Center for Health Affairs - logo
The Center for Health Affairs needed to streamline their data integration development.
Sound Technologies - logo
Sound Technologies needed to migrate their CRM data and automate their CRM/ERP processes.
Genbil - logo
How Genbil uses the SSIS Integration Toolkit for their AutoMerge tool.
SMS Technology - logo
SMS Management & Technology needed to migrate records from two different systems into CRM.

View more Case Studies