Our Microsoft Dynamics 365 integration tool enables you to easily set up your integration solution. We offer robust error handling and superior performance to streamline your development process and increase productivity. Our Microsoft 365 integration tools simplify your integration development work with an easy-to-use, development and scheduling process. With our toolkit, your 365 data integration can happen quickly and automatically so you do not have to worry about out-of-date records.
The SSIS Integration Toolkit for Microsoft Dynamics 365 is a cost-effective, easy-to-use, and high-performance data integration solution for Microsoft Dynamics 365, CRM, AX, NAV, and/or CDS
Our SSIS Integration Toolkit for Microsoft Dynamics 365 is equipped with the following four major components that help facilitate data integration and migration.
- Microsoft Dynamics 365 CE/CRM & CDS Components
- 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)
- Common Data Service (CDS) v2 & PowerApps v2
- Microsoft Dynamics CRM Connection Manager
- Facilitates the connection to Microsoft Dynamics 365 CE/CRM server.
- Microsoft Dynamics CRM Source Component
- Allows you to read data from Microsoft Dynamics 365 CE/CRM Server.
- Support to read data from the server through CRM entity, FetchXML query, EntityChanges, or AuditLogs options.
- Microsoft Dynamics CRM Destination Component
- Allows you to write data to Microsoft Dynamics 365 CE/CRM Server using its web service interfaces.
- Support for eight different actions: Create, Update, Delete, Upsert, Merge, Convert, Send, ExecuteWorkflow, & BulkDelete
- Four matching options available when Update or Upsert action is used: 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.
- Microsoft Dynamics CRM OptionSet Mapping Component
- Manage translation and mapping of 365 CE/CRM OptionSet (or picklist) field's option values
- Can be used to create new option when no match is found
- Microsoft Dynamics 365 FO/AX Components
- Supports connecting to and integration with:
- Microsoft Dynamics 365 Finance & Operations
- Microsoft Dynamics AX (4.0 - 2012 R3)
- Microsoft Dynamics AX Connection Manager
- Facilitates the connection to Microsoft Dynamics 365 FO/AX server.
- Microsoft Dynamics AX Source Component
- Allows you to read data from Microsoft Dynamics 365 FO/AX Server using query statement with support for User and System Variables.
- Microsoft Dynamics AX Destination Component
- Facilitate writing data to Microsoft Dynamics 365 FO/AX Server, using different actions: Create, Update, Upsert, & Delete
- Upsert action is based on manually selected matching field(s) with the option to ‘Ignore Unchanged Fields.’
- Microsoft Dynamics AX Next Sequence Number Component
- Retrieves the next sequence number from AX server.
- Microsft Dynamics 365 BC/NAV Components
- Supports connecting to and integration with:
- Microsoft Dynamics 365 Business Central
- Microsoft Dynamics NAV (2009 - 2018)
- Microsoft Dynamics NAV Connection Manager
- Facilitates connection to Microsoft Dynamics 365 BC/NAV web services.
- Support for multitenant deployment.
- Microsoft Dynamics NAV Source Component
- Allows you to read data from Microsoft Dynamics 365 BC/NAV web services.
- Support for Supplementary Parameters on specified objects.
- Microsoft Dynamics NAV Destination Component
- Facilitates writing data to Microsoft Dynamics 365 BC/NAV via web services, using different actions: Create, Update, Delete & Upsert.
- 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 Supplementary Parameters on specified objects.
For more information, visit www.kingswaysoft.com/dynamics365
Licensing
We offer three licensing levels: Free Developer's License, Trial License, and a Commercial Subscription License.
- Free Developer's License: You do not need to acquire a license if you only want to test out the software functionality within the development tools (SSDT-BI, BIDS - Business Intelligence Development Studio, or Visual Studio). After installation, the software will operate under the free developer license by default. With the developer license, you can create and develop data flows within the development tools (SSDT-BI, BIDS, or Visual Studio), including executing test loads without requiring a commercial license. To recap, the free developer license is fully-functional within the development tools (SSDT-BI, BIDS, or Visual Studio). The only limitation is the inability to run the software outside the development tools.
- Trial License: If you want to evaluate whether the software functions properly outside of the development tools (SSDT-BI, BIDS, or Visual Studio), you can acquire a trial license using the License Manager program which is installed along with the software. To request a Trial License, please open the License Manager program (on your new server) and select “Change License Key”. You can leave the license field empty in this case. Once the other fields are completed, the “Request a Trial License” button will be enabled for your activation. After you have acquired a trial license, you will be able to run SSIS packages on a scheduled basis, or from any other Windows process such as command line. The trial software will operate fully-functional for the trial period, which is generally 14 days. When the trial period expires, the software will revert to the free developer license.
- Commercial Subscription License: A commercial license is required when executing unattended jobs (SQL Agent Job, dtexec command line, etc.). Various subscription terms are available.
| |
