A powerful connectivity and productivity solution that integrates Dataverse with Dynamics 365 CRM, Finance & Operations (AX), and Business Central (NAV), designed to ensure secure data flow, synchronized systems, and code-free integration across complex environments.
Dynamics CRM / 365
Customer Engagement
Data Solutions
Connect your sales, marketing, and service teams with a single customer view that helps you track leads, manage relationships, and close deals faster.
- Sales
- Customer Service
- Field Service
- Marketing
- Project Operations
- CRM
Dynamics AX / 365
Finance & Operations
Data Solutions
Run complex business operations with a unified ERP that connects finance, supply chain, manufacturing, and logistics, giving you real-time control over global processes and performance.
- Finance
- Supply Chain Management
- AX
Dynamics NAV / 365
Business Central
Data Solutions
Manage core financials, operations, and reporting in a streamlined ERP designed for small to mid-sized businesses, with clear upgrade paths from legacy NAV systems.
Explore Business Central/NAV SolutionsAccomplish more with your data
Integrate. Automate. Report. Analyze. Replicate.
Powered by modern cryptography and authentication technologies for secure connections, such as TLS 1.2, OAuth2, SHA-256, etc.
Download Purchase Data Sheet
SSIS Integration Toolkit
Seamless data integration for Dynamics 365 and legacy systems including NAV, AX, CRM, SL, GP, and CDM.
High-performance, flexible, and easy-to-use components for Dynamics 365 data migration, upgrades, and complex integrations. Powered by the SSIS ETL engine and advanced configuration options, the SSIS Integration Toolkit delivers fast, codeless data integration across the Microsoft Dynamics 365 ecosystem.
Data Integration Made Easy
Advanced Integration Capabilities
Dynamics 365 Connectivity Made Easy
Easily connect to your Microsoft Dynamics 365 instances for advanced data retrieval and writing through expanded actions.
Microsoft Dynamics 365 Support
Finance & Operations
Finance, Supply Chain Management
Dataverse - CDS
PowerApps, Retail, Talent
Customer Engagement
Sales, Customer Service, Field Service, Marketing, Project Operations
Business Central
Online or on-premises
Legacy On-Premises Applications
Microsoft Dynamics AX, CRM, NAV
Microsoft Dataverse
SSIS Components
- ✔Read, write, and update Dataverse data via SSIS components
- ✔Perform bulk loads, upserts, and incremental data synchronization
- ✔Control API usage with batching, throttling, and error handling
Microsoft Fabric
Data Integration
- ✔Load data into Fabric Warehouse and OneLake environments
- ✔Extract and transform data from Fabric for downstream systems
- ✔Build scalable SSIS pipelines for enterprise data movement
Codeless
Integration
You don't have to write a single line of code to make data integration happen so your development can be done in a matter of minutes.
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 an extremely simple licensing model, our solution offers the best value for your investment.
Unparalleled
Performance
Our software includes purpose-built features that help you achieve optimal performance while ensuring exceptional efficiency and reliability.
Featured Case Studies
The Center for Health Affairs needed to streamline their data integration development.
Sound Technologies needed to migrate their CRM data and automate their CRM/ERP processes.
How Genbil uses the SSIS Integration Toolkit for their AutoMerge tool.
SMS Management & Technology needed to migrate records from two different systems into CRM.
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.
More Connectivity Solutions for Dynamics Applications
Our Components for Microsoft Services make it easy to integrate with different services within the ETL process. Each service available has specific components that have been developed to work with all the intricacies of that particular ERP solution. In addition to Dynamics 365 BC / NAV, we support the following ERP services:
Dynamics 365 BC/NAV
Dynamics 365 CE/CRM
Dynamics 365 Customer Insights
Dynamics 365 FO/AX
Dynamics 365 Marketing
Dynamics 365 Supply Chain Management
Dynamics GP
Dynamics SL
Microsoft Dataverse/CDM
Microsoft Fabric
Where Our Solutions Fit in Your Workflow
Our solutions are used across a wide range of roles involved in managing
data pipelines, integrations, and enterprise system connectivity.
Data & Integration Engineers
Enterprise Application Managers
Solution Designers & Architects
More Resources
Download our Data Sheet for
SSIS Integration Toolkit for Microsoft Dynamics 365
FAQ
The SSIS Integration Toolkit for Microsoft Dynamics 365 is a comprehensive solution designed to streamline Dynamics 365 data integration and migration. It provides robust SSIS components that connect directly to various Microsoft Dynamics 365 platforms, including CE/CRM, Finance and Operations (FO/AX), Business Central (BC/NAV), and Dataverse (formerly CDS). This toolkit enables efficient extraction, transformation, and loading (ETL) of your Dynamics 365 data, ensuring seamless interaction with SQL Server and any other system for advanced data integration and reporting.
The SSIS Integration Toolkit for Microsoft Dynamics 365 includes specialized components for both Common Data Service (CDS) integration and Microsoft Dataverse integration. Since Dataverse (formerly CDS) is built on the same framework as Dynamics 365 CE/CRM, our Dataverse Source and Destination components share a similar user interface and functionality with our Dynamics 365 CE/CRM components. This allows for straightforward data integration and migration with your CDS v2 and Dataverse instances, leveraging familiar configuration patterns. Key differences for Dataverse include the shift towards RESTful connections and enhanced flexibility for Active Directory On-Premises domain configurations.
For Microsoft Dynamics 365 CE/CRM integration, the toolkit offers a powerful set of components: the CDS/CRM Connection Manager, Source, Destination, OptionSet Mapping, Dynamics CRM Command Task, and Premium Service Lookup components. These facilitate seamless integration and migration with Dynamics 365 for Customer Engagement (Sales, Customer Service, Field Service, Marketing, Project Operations), and older Microsoft CRM Server versions. You can read data via CRM entity, FetchXML queries, EntityChanges, or AuditLogs, and perform various write actions like Create, Update, Delete, Upsert, Merge, and more, with robust matching options and features like "Ignore Null-Valued Fields" and "Ignore Unchanged Fields" for optimized performance. The CRM OptionSet Mapping component helps manage picklist values, and the Dynamics CRM Command Task allows for executing SQL-like commands at the control flow level.
Yes. The SSIS Integration Toolkit for Microsoft Dynamics 365 includes dedicated components for Dynamics 365 FO/AX integration. These components support Microsoft Dynamics 365 Finance and Operations, as well as legacy versions like Dynamics AX 2012, 2009, and 4.0. The AX Connection Manager uses the .NET Business Connector for older AX versions and OData for Dynamics 365 Finance and Operations. You can read data from the AX Server using the AX Source Component and write data using the AX Destination Component with Create, Update, Upsert, or Delete actions. The AX Next Sequence Number Component is also available for generating sequence numbers, and the Premium Service Lookup Component offers lookup capabilities within your FO/AX instance.
The toolkit provides comprehensive support for Microsoft Dynamics 365 BC/NAV integration, covering Dynamics 365 Business Central and older NAV versions (2018, 2017, etc.). It includes the NAV Connection Manager with built-in retry logic and multi-tenant deployment support, the NAV Source Component for reading data with advanced filtering and supplementary parameters, and the NAV Destination Component for writing data using Create, Update, Delete, or Upsert actions. The Premium Service Lookup Component also extends its lookup capabilities to Dynamics 365 BC/NAV instances.
Yes. The SSIS Integration Toolkit for Microsoft Dynamics 365, particularly with an Ultimate Edition license, fully supports EDI D365 integration. This is made possible through the powerful EDI Source Component and EDI Destination Component, which are part of our SSIS Productivity Pack (included in the Ultimate Edition).
The EDI Source Component allows you to read and retrieve data from various EDI file formats, including X12, EDIFACT, EANCOM, VDA, HIPPA, HL7, and NCPDP Script/Telco. It offers flexible connection managers such as Local File, FTPS, SFTP, Amazon S3, Azure Blob, and more. You can specify EDI format, code page, and even flatten segment loops for simplified output. The component includes an EDI Rules Manager to easily download and manage required EDI rules.
Conversely, the EDI Destination Component facilitates writing data to EDI files, supporting the same wide range of formats and connection managers. It offers robust document design capabilities, including a Document Designer with Details and Diagram Views, allowing you to map input columns from upstream components to your defined EDI document structure. Comprehensive error handling options ensure reliable data processing.
With the Ultimate Edition, you get a single license key that covers all SSIS Integration Toolkits and the SSIS Productivity Pack, providing a complete solution for your Dynamics 365 and EDI integration needs.
Get In Touch
If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!
Contact Us