Menu
KingswaySoft SSIS Integration Toolkit for Microsoft Dynamics 365
KingswaySoft SSIS Integration Toolkit for Microsoft Dynamics 365 is a cost-effective, easy-to-use and high-performance data
integration solution, utilizing Microsoft SSIS capabilities. The toolkit includes components to facilitate integration with Microsoft
Dynamics 365 applications as well as CDS, PowerApps, Dataverse, and all versions of Microsoft Dynamics CRM, CE, AX, and NAV.
Dynamic
Integration
Complimented by SSIS capabilities, the SSIS Integration Toolkit is most feature-rich data integration solution for Microsoft Dynamics 365, which enables data integration between Microsoft Dynamics 365, CRM, CE, NAV, AX, CDS, Dataverse, PowerApps and virtually any other database or application systems.
Simplified Integration
Utilizing the codeless data integration approach, you can forget all intricate details involved in working with Microsoft Dynamics web service interfaces when developing data integration solutions.
Streamlined Development
Easy learning curve, consistent application user interface, and familiar development experience, all adds up to an improved development experience.
Optimized Performance
Offers many specifically designed features that help you achieve the best possible performance without sacrificing your IT budget.
Below are the components included with the SSIS Integration Toolkit for Microsoft Dynamics 365 and just some of their many technical features.
Microsoft Dynamics
365 CE/CRM
CRM/CDS Connection Manager
- Supports connections to 365 Customer Engagement, CRM 3.0 - 2016, and CDS.
- Option to work around intermittent errors by making retry service calls.
CRM/CDS Source Component
- Facilitates reading data from Microsoft Dynamics 365 CE/CRM using either Entity, FetchXML query, EntityChanges or AuditLog option.
- The most sophisticated support of any complex FetchXML queries.
CRM/CDS Destination Component
- Facilitates writing data into Microsoft Dynamics 365 CE/CRM using Create, Update, Delete, Upsert, Merge, Convert, Send, Bulk Delete, or ExecuteWorkflow write actions.
- Four different matching options when performing Update or Upsert: Primary Key, CRM Duplicate Detection, Manually Specified Fields, & CRM Alternate Key.
- Support of utilizing CRM Bulk Data API.
- Equipped with many configurable options, Text Lookup feature makes CRM lookup references painlessly easy.
- Support for CRM many-to-many relationship without requiring writing a single line of code.
- Support for a transparent handling of special CRM fields.
- Many advanced options are offered for special integration scenarios.
- Support for multithreaded writing using one single configuration.
CRM/CDS Destination Component
- Provides a consistent way to manage the translation and mapping of CRM OptionSet values.
NAV Connection Manager
- Supports connections to Microsoft Dynamics 365 Business Central and NAV 2009 - 2018.
- Support for multitenant deployment.
- Option to work around intermittent errors by making retry service calls.
NAV Source Component
- Facilitates reading data from Microsoft Dynamics 365 BC/NAV via Web Services.
- Option to filter data using Page Filtering query with support for User and System Variables.
NAV Destination Component
- Support for Create, Update, Delete, Upsert actions.
- Upsert action is based on manually selected matching field(s) with several options to handle multiple matches.
- 3 Error Handling Mechanism with 2 additional configurable Default Output columns: Key & IsNew, Advanced filtering features for NAV field mappings.
- Support for multithreaded writing using one single configuration.
Microsoft Dynamics
365 BC/NAV
Microsoft Dynamics
365 FO/AX
AX Connection Manager
- Supports connections to Microsoft Dynamics 365 Finance & Operations and AX 4.0 - 2012 R3.
AX Source Component
- Facilitates reading data from Microsoft Dynamics 365 FO/AX using query with support for User and System Variables.
- Option to specify AX fields to retrieve for specified objects.
AX Destination Component
- Support to write to the AX server using Create, Update, Delete, and Upsert actions.
- Upsert action is based on manually selected matching field(s) with the option to ‘Ignore Unchanged Fields.’
- 3 Error Handling Mechanism with additional configurable columns: AxRecId, IsNew, Advanced filtering capabilities for AX field mappings.
- Support for multithreaded writing using one single configuration.
AX Next Sequence Number Component
- Retrieves the next sequence number from the AX server to use as the input for one of the input columns within the AX Destination component.
Technical Requirements: Azure-SSIS IR or Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, or 2008.
Microsoft Dynamics 365 CE Online & CDS requires SQL Server 2012 or above.
About KingswaySoft
KingswaySoft is a leading provider of data integration solutions for Microsoft Dynamics software and beyond. Organizations from more than 100 countries rely on our solutions to drive their business data efficiency.
SplashDev is a Microsoft Dynamics 365 Solution Provider that helps companies achieve performance excellence and make sure their investment in software brings real, measurable results.
Home
Services
Newsletter
Signup for our newsletter to get updated information, promotion & Insight.
Copyright © 2023 SplashDev, All rights reserved. Powered by Altasoft Solutions.
