Register   Login 
Search  
 ProductsDynamics GP SSIS Toolkit    February 22, 2012
Overview

Are you performing double entry?  Is your website order system not integrated into Dynamics GP?  Do you need to record financial transactions from other line of business (LOB) systems into Dynamics GP?

If the answer is "Yes" to any of above questions then the Dynamics GP SSIS Toolkit is what you need to reduce your administrative costs and increase the visibility of your financial data by eliminating unnecessary double entry and integrating your LOB systems together!

The Dynamics GP SSIS Toolkit enables businesses to use the familiar SQL Server Integration Services (SSIS) environment that is already available with your installation of SQL 2005/2008/2008R2 to integrate business data into Dynamics GP.  Why buy a completely different integration tool when you have the perfect tool (SSIS) already at your disposal?

Business data such as Orders, Invoices, General Ledger, Purchase Orders, and many more types of business data are supported through the use of the Microsoft Dynamics GP eConnect API.

The Dynamics GP SSIS Toolkit provides several SSIS tasks and data adapters on top of the over 80 out of the box SSIS tasks and data adapters to bring a complete solution for integrating from a variety of data sources such as Web services, XML, OLE DB data sources, ODBC, flat files, and Excel.

Most integrations can be done without coding.  However the SSIS foundation provides for the ability to completely customize all aspects of the integration using the .NET programming language at any step in your integrations for the most powerful and compact Dynamics GP integration tool on the market.

All Keelio Software products are compatible with all editions of Microsoft SQL Server 2005, SQL Server 2008, and SQL 2008 R2 (32-bit and 64-bit).

Licensing terms and conditions can be found by viewing the Price List Brochure.

 
Features
  • All the features of the XML SSIS Toolkit
  • Real-time Dynamics GP Data lookup (for items such as SOP document types and many other Dynamics GP document types)
  • Variable error logging. All error logging gets stored for later use in emails or other types of notifications
  • Text and binary file loading. Used to load preformatted eConnect XML files from the file system
  • Advanced XML destination mapping tools utilizing the Template Transformation, XML Merge Transformation, and XML Formatter data flow components
  • Complete eConnect API functionality
  • Requester transaction support
  • Full transaction rollback support utilizing the SSIS transaction framework
  • Does not require eConnect API to be installed on SSIS server
 
Included Products
  • Dynamics GP eConnect Task (GP 9.0, 10.0, 2010)
  • Dynamics GP Next Document Number Task (GP 9.0, 10.0, 2010)
  • Dynamics GP Next Document Number Transformation (GP 9.0, 10.0, 2010)
  • File Task
  • Template Transformation
  • XML Formatter Transformation
  • XML Merge Transformation
  • Sample Integrations for Dynamics GP 9.0, 10.0, and 2010
 
Screenshots
 
 
 Copyright 2011 by Keelio Software, LLC   Terms Of Use  Privacy Statement