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 365, SharePoint, Directory Services, 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
    technical feature highlights    .

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 2022,
    • 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.

SSIS Integration Toolkit for Microsoft Dynamics GP - GP Connection Manager

Microsoft Dynamics GP
Connection Manager

  • The Microsoft Dynamics GP Connection Manager facilitates a connection to your Microsoft Dynamics GP database schema.
  • Provides robust security features, ensuring the safe and reliable transfer of financial and business data between Dynamics GP and SSIS.
  • Supports connecting to various Dynamics SL instances and companies with options for using basic and integrated authentication.
  •  See this component's documentation.

Microsoft Dynamics GP
Source Component

  • The Microsoft Dynamics GP Source Component allows you to read data from your Dynamics GP SQL database.
  • Enables efficient data extraction from Dynamics GP, facilitating seamless integration of financial data with various systems.
  • Offers advanced data filtering and transformation options, allowing users to select specific Dynamics GP data and align it accurately with SSIS fields.
  •  See this component's documentation.

SSIS Integration Toolkit for Microsoft Dynamics GP - GP Source Component

Microsoft Dynamics GP Destination Component

Microsoft Dynamics GP
Destination Component

  • The Microsoft Dynamics GP Destination Component facilitates writing data to your Microsoft Dynamics GP Server.
  • Supports bulk data insertion, optimizing the upload process of large datasets to Dynamics GP and reducing processing time.
  • Provides comprehensive mapping capabilities to precisely align SSIS data with corresponding Dynamics GP fields for accurate data integration and management.
  •  See this component's documentation.

Microsoft Dynamics GP NextDocNumber Generator Component

  • 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.
  •  See this component's documentation.

SSIS Integration Toolkit for Microsoft Dynamics GP - NextDocNumber

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