The Great Plains Connector allows you to move data into and out of the Microsoft Great Plains (now called Dynamics GP) business management application. The Connector connects directly to your Great Plains database and enables you to query, add, modify, and delete various types of records including Accounts, Customers, Sales Orders, Invoices, and more.
The Connector utilizes an integration layer called eConnect to exchange data with the Great Plains database (What's 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. It is important to make sure that eConnect is installed before you attempt to connect to Great Plains.
Connector Configuration
The Connector is comprised of two sub-Components:
- Connection - The Connection represents a specific Great Plains company database. You will create one Connection for each company database.
- Operation - The Operation represents an action against a specific record type. You will create one or more Operations, one for each type of interaction required by your integration scenario.
Supported Versions
- Great Plains 9.x
- Great Plains 10.x
- Great Plains Version 11
- Modules:
- Bank Reconciliation (BR)
- Company (CMP)
- Field Service (FS)
- Fixed Assets (FA)
- General Ledger (GL)
- Inventory (IV)
- Lockbox (LB)
- Project Accounting (PA)
- Purchase Order Processing (POP)
- Purchasing (PM)
- Receivables (RM)
- Sales Order Processing (SOP)
- Shared Master (SM)
- US Payroll(UPR)
Prerequisites
Important: You must setup a Local Atom within your network to be able to connect to Great Plains. It is strongly recommended you install the Atom on the Great Plains server itself to facilitate.- The Connector must be configured with a Windows Domain user that has access to the Great Plains SQL Server database machine. A SQL Server Login must be created for this domain user and the database user must be granted the "DYNGRP" role within the "DYNAMICS" database.
- The eConnect libraries must be installed (eConnect Documentation) however the full eConnect Runtime module does not need to be installed.
Additional Notes
- The eConnect interfaces do not support every object and interaction available within Great Plains. If your integration scenario requires working with objects from other modules or more sophisticated queries, you will need to use the Database Connector to connect to backend database tables directly. Consult your eConnect documentation for more information about the table schemas. As always, use caution when accessing an application database tables directly to maintain data integrity.
Tracked Properties
This Connector has no Tracked Properties.
Additional Resources
Microsoft Great Plains Website
eConnect Documentation
This page
Other pages
Account
