Overview


Manual data entry and reconciliation, often time-consuming , expensive , error-prone and often the result of disconnected systems with duplicated efforts in managing customer information, invoices or getting payments something that is not easily shared and updated.
DBSync allows you to integrate your front- and back-office applications to streamline and automate your business processes and ensure that your MS Dynamics GP (GreatPlains) data is accurate, timely, and functional.
DBSync can automated in near real-time between MS Dynamics GP and other applications and can be used to

  • Synchronize Customer Master Databases with Microsoft Dynamics GP
  • Convert Opportunities Won to Order generated in MS Dynamics GP
  • Convert Opportunities Won to Invoice in MS Dynamics GP
  • Integrate E-commerce website orders to MS Dynamics GP
  • Integrated payments received from online payment systems for reconciliation

Frequently Asked Questions


What are the supported versions?
  • GreatPlains 9.x
  • GreatPlains 10.x
What are the pre-requisite software requirement for DBSync integration with Microsoft Dynamics GP?

The eConnect libraries must be installed (eConnect Documentation) however the full eConnect Runtime module does not need to be installed.

Does Dbsync need to be installed on the same machine as that of Microsoft Dynamcs GP?

DBSync Microsoft Dynamics GP (GreatPlains) adapter can be either configured on the same instance GP is installed or on a remote machine which can access GreatPlains database.

What are the limitations of DBSync integration with Microsoft Dynamics GP?

The eConnect interfaces do not support every object and interaction available within Microsoft Dynamics GP (Great Plains). If your integration scenario requires working with objects from other modules or more sophisticated queries, you will need to use our Database Adapter for Microsoft SQL Server to connect to backend database tables directly. While this is an option, it is recommended to avoid accessing Microsoft Dynamics GP (GreatPlains) database directly to maintain data integrity and business rule executions.