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 later 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.
The first time you run a Great Plains process, the Atom will detect if eConnect is already installed and if not, go ahead and automatically install it for you.
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
Prerequisites
Important: An Atom must be deployed to a machine within your network that has physical connectivity to the Great Plains database.- 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.
- eConnect must be installed (eConnect Documentation). However, the Atom will automatically install it if missing.
Tracked Properties
This Connector has no Tracked Properties.
Additional Resources
Microsoft Great Plains Website
eConnect Documentation
Creating a Great Plains Connection
(Boomi On Demand)
This page
Other pages
Account
