KingswaySoft

SSIS Integration Toolkit for Microsoft Dynamics SL

The first and only solution for Microsoft Dynamics SL integration

A one-of-a-kind tool that enables high-performing data integration for Microsoft Dynamics SL.

By utilizing Microsoft SQL Server Integration Services (SSIS) as your data integration platform, developers unlock a simplified, codeless development experience using a familiar toolset.

The SSIS Integration Toolkit for Microsoft Dynamics SL

  • Simple, straightforward and cost effective data integration built to handle the intricate details of working with Microsoft Dynamics SL web service interfaces.
  • Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio as the ETL development tool.
  • Easy-to-use, codeless solution that enables integration to occur in a matter of minutes for what could otherwise take months of development.
  • Variety of functional buttons to better support the development process.
  • Takes advantage of the flexibility and power of the SSIS ETL engine to integrate with virtually any application or data source.
  • Powered by modern cryptography and authentication technologies for secure connections, such as TLS 1.2, OAuth2, SHA-256, etc.
  • Available as a stand-alone product or as part of the Ultimate Edition which includes Microsoft Project Server, Microsoft Dynamics 365, OneDrive, Salesforce and many more.
Dynamics SL SSIS Data Integration

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 offers many specifically designed features that help you achieve the best possible performance without having to hijack your budget.

Unique Features

  • Built in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.
  • Support for working with Child Objects in both reading and writing.
  • Can specify both the source object and child object properties and provide filtering criteria for each.
  • Write based on the primary key for both the source object and the child object.
  • Write to Microsoft Dynamics SL through either Create, Update, or Delete actions.
  • See help manual for a highlight of the technical features.

Technical Requirements

  • Dynamics S, either:
    • Dynamics SL 2015, or,
    • Dynamics SL 2011.
  • SQL Server Integration Services, either:
    • Azure-SSIS Integration Runtime,
    • Microsoft SQL Server 2019,
    • Microsoft SQL Server 2017,
    • Microsoft SQL Server 2016,
    • Microsoft SQL Server 2014,
    • Microsoft SQL Server 2012,
    • Microsoft SQL Server 2008 R2, or,
    • Microsoft SQL Server 2008.

Microsoft Dynamics SL SSIS Components

Microsoft Dynamics SL Connection Manager

SSIS Integration Toolkit for Dynamics SL - Connection Manager

The Dynamics SL Connection Manager facilitates connection to Dynamics SL's web services.

Microsoft Dynamics SL Source Component

SSIS Integration Toolkit for Dynamics SL - Source Component

The source component allows you to read data from Dynamics SL objects via web services.

Microsoft Dynamics SL Destination Component

SSIS Integration Toolkit for Dynamics SL - Destination Component

The destination component facilitates writing data to Dynamics SL via web services.

Database Developers can be fully utilized to create complex data integrations or migrations from start to finish without the need for additional development resources.

Chris LaBadie

Senior Database Developer

Sonoma Partners