KingswaySoft

SSIS Integration Toolkit for Microsoft Dynamics GP

High performing data integration software for Microsoft Dynamics GP

High performance data integration software that is easy to use, with a simple and cost-effective licensing model.

The SSIS Integration Toolkit for Microsoft Dynamics GP enables Microsoft Dynamics GP integration which is easy-to-use, efficient, flexible, reliable, and powerful.

The SSIS Integration Toolkit for Microsoft Dynamics GP

  • Data integration can be done in a matter of minutes when using this powerful integration toolkit.
  • Utilizes Microsoft SSIS as the data integration platform to take advantage of the flexibility and power of the SSIS ETL engine.
  • Develop simple to complex data integration jobs without ever having to write a single line of code.
  • A simple development process with built in features to help ease the process even further, including built-in SQL Query builder and automatic field mapping.
  • Includes GP Connection Manager, GP Source component, GP Destination component and the bonus GP Next Document Number Generator Component.
  • GP data integration with virtually any other application or data source through other SSIS components and the Ultimate Edition which includes Microsoft Dynamics CRM, SharePoint, Active Directory, Salesforce and many more.
Dynamics GP 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

  • Write custom SQL queries or simply choose a source object to retrieve data.
  • Column/field filtering capabilities to retrieve only the data you need.
  • Write to Microsoft Dynamics GP using 4 different write actions: Create, Update, Delete or Void.
  • Automatically maps fields to establish associations between input columns and GP fields.
  • NextDocNumber component can be used to generate new sequential IDs for transnational objects.
  • See help manual for a highlight of the technical features.

Technical Requirements

  • Microsoft Dynamics GP, either:
    • Microsoft Dynamics GP 2018,
    • Microsoft Dynamics GP 2016,
    • Microsoft Dynamics GP 2015,
    • Microsoft Dynamics GP 2013,
    • Microsoft Dynamics GP 2010, or,
    • Microsoft Dynamics GP 10.0.
  • SQL Server Integration Service, 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 GP SSIS Components

Microsoft Dynamics GP Connection Manager

SSIS Integration Toolkit for Microsoft Dynamics GP - GP Connection Manager

The Dynamics GP Connection Manager facilitates a connection to your Microsoft Dynamics GP database schema.

Microsoft Dynamics GP Source Component

SSIS Integration Toolkit for Microsoft Dynamics GP - GP Source Component

The Dynamics GP source component allows you to read data from your Dynamics GP SQL database.

Microsoft Dynamics GP Destination Component

Microsoft Dynamics GP Destination Component

The Dynamics GP destination component facilitates writing data to your Microsoft Dynamics GP Server.

Microsoft Dynamics GP Next Document Number Generator Component

Microsoft Dynamics GP Next Document Number

The Dynamics GP NextDocNumber Editor / Generator is used to help you generate the next sequential ID number for given records that do not have automatic ID number generation.

An efficient and cost effective way to perform data migrations and integrations using technologies that our customers are comfortable with.

Chris Scott

Partner

Celedon Partners