Overview

DBSync's GreatPlains Adapter allows you to move data into and out of the Microsoft Dynamics GP accounting application. Our adapter connects directly to GreatPlains instance and enables you to query, add, modify, and delete many types of records like: Accounts, Customers, Sales Orders (SOP), Invoices, and more. Our template for Standard Objects allows you to be up and running in an hour, and our flexible system enables you to integrate all your custom objects.




Features

  • Easily Integrated
    Our Microsoft Dynamics GP for Salesforce supports integration with a wide range of data structures including Databases, Accounting Software, Files, and CRM adapters.
  • Highly Customizable
    Customize what data is synced and how often (as often as every 5 minutes) from MS Dynamics GP to any other connected adapter.
  • Database Integrations
    Supported database integration is for JDBC and ODBC compliant databases like Oracle, SQL Server, DB2, mySQL, PostgreSQL and more.
  • Streamline & Automate Business Process
    Integrate your front and back office applications for streamlining and automating business processes that ensure your MS Dynamics GP data is accurate, timely, and functional
  • eConnect
    eConnect is a Microsoft programmatic interface layer that facilitates the exchange of data by performing business validations and ensures data integrity. It is implemented as a set of database stored procedures installed on the Great Plains database server. eConnect is required to be installed before connecting to DBSync GP adapter.

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 Dynamics 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.