SSIS Integration Toolkit for Microsoft Dynamics GP by KingswaySoft is an extension for Microsoft SQL Server Integration Services (SSIS) that enables integration with Microsoft Dynamics GP (Great Plains). The toolkit provides dedicated connection managers, source and destination components, and task components specifically designed for working with Dynamics GP data and business objects. It supports integration through Microsoft Dynamics GP eConnect as well as direct SQL Server access, enabling both transactional and bulk data operations. The solution integrates into the SSIS design environment (Visual Studio / SSDT) and allows developers to build ETL packages that extract, transform, and load data between Dynamics GP and external databases, applications, and data warehouses. It supports both on-premises deployments and Azure-SSIS Integration Runtime. The product is intended for integration developers and organizations that require controlled, repeatable processes for data migration, synchronization, and system integration involving Microsoft Dynamics GP.

Key Features

Dynamics GP Connection Manager Provides connectivity to Microsoft Dynamics GP.

• Supports eConnect-based integration
• Direct SQL Server connectivity option
• Configurable connection settings

Dynamics GP Source Component Extracts data from Dynamics GP.

• Access to GP tables and views
• Support for custom queries
• Incremental data extraction support

Dynamics GP Destination Component Loads data into Dynamics GP.

• Create and update operations
• Transactional data processing via eConnect
• Support for bulk data operations

eConnect Task Component Executes GP-specific operations.

• Invokes eConnect business logic
• Supports document and transaction processing
• Handles GP-specific validation rules

Metadata-Driven Configuration Utilizes Dynamics GP schema information.

• Automatic metadata retrieval
• Field mapping support
• Support for customizations

Error Handling and Logging Facilitates reliable ETL execution.

• Detailed error output
• Execution logging
• Configurable retry logic

Deployment Compatibility Supports SSIS environments.

• SQL Server Integration Services (supported versions)
• Azure-SSIS Integration Runtime
• 32-bit and 64-bit runtime support

Benefits

Structured GP Integration Enables repeatable and controlled data exchange.

• Centralized ETL management in SSIS
• Scheduled integrations
• Reduced manual processing

Reduced Custom Development Minimizes need for custom eConnect coding.

• Pre-built components
• Visual configuration interface
• Standardized integration patterns

Support for Business Logic Leverages native GP integration mechanisms.

• eConnect-based validation
• Consistent transaction handling
• Compliance with GP data rules

Improved Data Consistency Supports transformation and validation before loading.

• Field-level mapping
• Error redirection
• Integration with enterprise data processes

Flexible Deployment Works across infrastructure models.

• On-premises SQL Server
• Azure-SSIS runtime
• Hybrid scenarios