DBSync's Microsoft Dynamics GP (Great Plains) connector allows you to move data into and out of the Microsoft Dynamics GP (Great Plains) accounting application. Our solution connects directly to Great Plains 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.
- Easily Integrated
Our Microsoft Dynamics GP for Salesforce supports integration with a wide range of data structures including Databases, Accounting Software, Files, and CRM connectors.
- Highly Customizable
Customize what data is synced and how often (as often as every 5 minutes) from Microsoft Dynamics GP to any other connected solution.
- 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 Microsoft Dynamics GP data is accurate, timely, and functional
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 Microsoft Dynamics Great Plains database server. eConnect is required to be installed before connecting to DBSync Microsoft Dynamics GP (Great Plains) connector.
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 (Great Plains) connector can be either configured on the same instance Great Plains is installed or on a remote machine which can access Great Plains 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 Connector 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 (Great Plains) database directly to maintain data integrity and business rule executions.