KingswaySoft SSIS Integration Toolkit
by KingswaySoft · CRM Integration
SSIS components for codeless Dynamics 365, Dataverse and CRM data integration
- Works with
- Microsoft Dynamics 365, SAP
- Deployment
- On-premise, Cloud
- Company size
- SMB, Mid-market, Enterprise
- Pricing
- Subscription
- Headquarters
- Oakville, Ontario, Canada
Overview
KingswaySoft's SSIS Integration Toolkit is a suite of SQL Server Integration Services (SSIS) components that enable codeless data integration and migration with enterprise applications. It is best known for its Dynamics 365 / Dataverse integration capabilities, and is widely used by developers and consultants to move and transform CRM data using the familiar SSIS/Visual Studio environment.
Rather than being a hosted iPaaS, the toolkit installs into SSIS so integrations run within Microsoft's data integration framework, on-premise or in Azure. It provides source and destination components, connection managers, and lookup capabilities for Dynamics 365 CE/CRM, Dataverse, PowerApps, and legacy Dynamics AX and NAV, as well as Salesforce, SAP, and many other systems via additional toolkits.
The product is favored for high-volume CRM data migration, ETL, and integration projects where teams want SSIS-based control and performance. KingswaySoft is a Canadian company based in Oakville, Ontario, with customers across more than 100 countries.
Screenshots & demo
Demo video from the vendor's YouTube channel.
Features & capabilities
Dynamics 365 / Dataverse components
Codeless CRM integration in SSIS
- Dynamics 365 CE/CRM source and destination
- Dataverse and PowerApps connectivity
- Legacy Dynamics AX and NAV support
- Connection managers for authentication
- Codeless configuration
ETL and migration
High-volume data movement
- Bulk data migration
- Upsert and delete operations
- Data transformation in SSIS pipelines
- Lookup and matching components
- Batch and multithreaded processing
Broad application coverage
Multi-system toolkits
- Salesforce integration toolkit
- SAP integration toolkit
- Many SaaS and database connectors
- Premium components for advanced sources
- Ultimate Edition bundling toolkits
SSIS-native execution
Runs in Microsoft's ETL framework
- Installs into SQL Server Integration Services
- On-premise or Azure-SSIS execution
- Visual Studio / SSDT design experience
- Scheduling via SQL Server Agent
Reliability and developer tooling
Robustness for data projects
- Error handling and logging
- Retry and fault tolerance
- Reusable package design
- Detailed help and documentation
Common use cases
- Migrating large volumes of data into Dynamics 365 / Dataverse
- Building ETL pipelines between CRM and databases
- Integrating Dynamics 365 with Salesforce, SAP, or other systems
- Performing codeless CRM integration within SSIS
- Consolidating CRM data into a data warehouse
- Automating scheduled CRM data loads via SQL Server Agent
- Transforming and cleansing CRM data during migration
- Running integrations on-premise or via Azure-SSIS
Strengths & considerations
Strengths
- Codeless CRM integration within the familiar SSIS framework
- Strong reputation for high-volume Dynamics 365/Dataverse data work
- Perpetual-license model rather than hosted subscription iPaaS
- Broad toolkit coverage beyond Dynamics (Salesforce, SAP, more)
Considerations
- Requires SQL Server Integration Services and developer skills
- Not a hosted iPaaS; teams manage their own runtime
- Less suited to non-technical business users
ERP integrations
SSIS source/destination components for CE/CRM, AX, NAV, F&O via Dataverse
Pricing
Licensed per edition (including Ultimate Edition bundling all toolkits); free developer license and trial available Get an independent shortlist with pricing guidance below.
Technical & security
- Hosting
- Self-managed (runs within SSIS on-premise or Azure-SSIS)
- Data residency
- Customer-controlled
- Mobile app
- No
- Languages
- English
About the vendor
- Headquarters
- Oakville, Ontario, Canada
- Employees
- ~23
- Ownership
- Private
Alternatives to KingswaySoft SSIS Integration Toolkit in CRM Integration
KingswaySoft SSIS Integration Toolkit — frequently asked questions
Is the SSIS Integration Toolkit an iPaaS?
No. It is a set of SSIS components that install into SQL Server Integration Services and run within Microsoft's ETL framework, on-premise or in Azure, rather than as a hosted service.
What is it best known for?
Codeless, high-volume data integration and migration with Microsoft Dynamics 365, Dataverse, and PowerApps.
Does it support systems other than Dynamics?
Yes, KingswaySoft offers toolkits for Salesforce, SAP, and many other SaaS and database systems, bundled in its Ultimate Edition.
Who typically uses it?
Developers, consultants, and data teams comfortable with SSIS and Visual Studio who need control and performance for CRM data projects.
Evaluating CRM Integration?
Tell us your ERP and requirements and we'll send an independent shortlist — including KingswaySoft SSIS Integration Toolkit and the best-fit alternatives — with honest pros and cons.