Integrating External Data into Dynamics GP
Posted Wednesday, October 5, 2011 by Don Kapuscinski
Microsoft Dynamics GP is commonly used as the system of record and principal accounting system for all types of enterprises. Microsoft Dynamics is selected for its robust features and functionality, ease of use and familiar interface, and outstanding reporting and business intelligence. Integration of the systems will allow for the seamless sharing of information, the elimination of manual duplicative data entry, and reduce the time needed for data to be visible in Dynamics GP.
The Integration Suite for Microsoft Dynamics GP 2010 offers two tools for integrating data into the system:
- Integration Manager is designed to move data into Dynamics GP from an external source. This is done in a batch mode, where the batch consists of multiple transactions of a single type. This could be done at the General Ledger level, creating balanced Journal Entries to be posted in GP, or it can be done to some of the sub-ledgers in GP, creating unposted transactions in GP that can be reviewed and posted by a GP user. eConnect is designed to move data into and out of Dynamics GP.
- eConnect can work in either a batch-mode, processing transactions either “on-demand” or on a schedule, or eConnect can work in a “real-time” mode, processing transactions from the external source as soon as they are presented to eConnect. (Real-time is commonly used in eCommerce environments, while batch-mode is frequently used in restaurant integrations). eConnect can also wortk with multiple types of external data, including .csv, .xml, and others.