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 for Sales, Customer Service, Field Service, Project Service Automation, and Financials 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/AX Data Integration Components

Microsoft Dynamics AX


Microsoft Dynamics 365 for Operations

Supports connecting to and integration with:

  • Microsoft Dynamics 365 for Operations (coming spring 2017)
  • Microsoft Dynamics AX (4.0 - 2012 R3)

Microsoft Dynamics 365/CRM Data Integration Components

Microsoft Dynamics CRM


Microsoft Dynamics 365 for Sales

Supports connecting to and integration with:

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

Microsoft Dynamics 365/NAV Data Integration Components

Microsoft Dynamics NAV


Microsoft Dynamics 365 for Financials

Supports connecting to and integration with:

  • Microsoft Dynamics 365 for Financials
  • Microsoft Dynamics NAV (2009 - 2017)

  • 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/CRM Data Integration Featured Highlights

  • "Retry on intermittent errors" to deal with transient network or server problems in a robust fashion.
  • Read data from Microsoft Dynamics 365/CRM server through CRM entity, FetchXML query, EntityChanges, or AuditLogs options.
  • Seven different write actions for writing to 365/CRM server: Create, Update, Delete, Upsert, Merge, Convert and ExecuteWorkflow.
  • Four Update and Upsert matching options for the most robust solution to write incremental changes to 365/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.

Microsoft Dynamics 365 CRM data integration

Microsoft Dynamics 365/AX Data Integration Featured Highlights

  • Read from AX server using Dynamics AX query statement.
  • 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 to use as the input for one of the input columns within the AX Destination component.
  • Advanced filtering capabilities for AX field mappings.
  • Write to the 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.’

Microsoft Dynamics 365 AX data integration

Microsoft Dynamics 365/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 NAV/Financials 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 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.

Microsoft Dynamics 365 NAV data integration

Technique Requirements

  • Microsoft SQL Server 2016, 2014, 2012, 2008 R2, 2008 or 2005
    • (Microsoft Dynamics 365/CRM Online requires SQL Server 2012 or above)
  • Microsoft Dynamics 365/CRM
    • Dynamics 365 for Sales, Customer Service, Field Service, or Project Service Automation
    • Microsoft Dynamics CRM Server 2016, 2015, 2013, 2011, 4.0, or 3.0
  • Microsoft Dynamics 365/NAV
    • Microsoft Dynamics for Financials
    • Microsoft Dynamics NAV 2017, 2016, 2015, 2013 R2, 2013, 2009 R2, or 2009
  • Microsoft Dynamics 365/AX
    • Microsoft Dynamics AX 2012 R2, 2012 R2, 2012, 2009, or 4.0

Case Studies

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.
Andrew Sykes - logo
Andrew Sykes Group needed a more reliable and performant solution for their daily integration.
SMS Technology - logo
SMS Management & Technology needed to migrate records from two different systems into CRM.
Inogic - logo
Inogic needed to perform a large-scale migration from CRM 3.0 to CRM Online including activities and emails.