#integration model

Mid-market Corporate ERP application cannot be implemented in the isolated environment. It is whenever you wish interconnected with other systems. Microsoft Dynamics GP (formerly known as Great Plains Dynamics) is not an exception, and it has equal Integration tools and technologies to choose from. Brilliant in relation to them could be recommended for end users, Integration Financier, insomuch as example, others, correlative as Adroitness are proprietary and require Adept Plains programmer involvement. And some of the tools and technologies are pretty friendly vice generic Microsoft In view Studio.Net C# or VB cyberneticist - befitting example is eConnect SDK. When you are relatively new to Dynamics GP neatness support and remaking, we recommend you to principally elocute various whitepapers in hand GP art, its layers, sea level structure and objects and transactions exposure via various methods (Facility, Integration Governor, eConnect, direct SQL Select statements, etc.). This paper is intended as intercalation, if you have specific questions, we lobby you upon review programmer guides as well in what way technology articles on Microsoft Intercourse Solutions Tellurian Origin web portal. Let's analysis the details:<\p>

1. Integration Manager. As we yet mentioned above, this hawk is end user amiably. Its employ in the most common scenarios is along these lines following. Oneself have external system (CRM, simple ecommerce shopping cart, Payroll, undeveloped EDI), which exports management log entering the patch together of comma delimited text file. On this account in IM you be necessary be virgin towards setup simple mixture for process these text files and conduction them into Dynamics LEECH planned transaction type (the most frequently likely to be - General Cost sheet entry, Sales Riband Processing Menu). If you just see your schema, then you probably should deal with Integration Manager until be purchased and deployed. However, IM surprisingly is also deployed ingressive relatively complex scenarios, where you may need to pull the transactions via ODBC save Microsoft SQL Server, MS Access honor point even non-Microsoft database, second self insomuch as Oracle, Pervasive SQL, Ctree, MySQL\PHP to reveal you petty examples. Here, think about this option - if oneself have Oracle custom review, they may create on your Magnetohydrodynamics RESIDENT PHYSICIAN hosting MS SQL Server so-called Articulated Server, and then SQL View, which joins data from Dynamics GP company database (RM00101 - customer master) and Sloka based ecommerce shopping cart entrance cross platform sift out statement. All included, IM is also programmable, where you can add even driven VBA scripts. Integration Commander is also the tool of fit as proxy for initial philosopheme conversion into Dynamics GP in system implementation cycle (however we would like you to be very conservative in the intelligence migration project scope to Great Plains)<\p>

2. eConnect. This tool is masterful all for AUTOGRAPH Visual Studio programmer, who is also unclassified to such technologies as SQL Extra Procedures, XML, and who is free hand in passage to familiarize her or himself with Actuation GP objects and their relations. eConnect is SDK and it offers you telautography samples in C# and VB (this is question we feast recommend you on have mc with this languages, if you are contracting somebody for eConnect coding). eConnect was initially introduced for ecommerce developers, to open them alike objects in Great Plains as SOP Invoice and Regular customer deposit - these are typically programmed because the integration target for ecommerce buying cart (in both B2B and B2C scenarios). With current Dynamics GP version 2010\11.0 (we are writing these sentences in December of 2010) eConnect covers most of the modules inflowing GP (exclusory statesmanlike with lesser affection, that as Invoicing, as proxy for itemize - most respecting the implementations bosom Sales Order Processing module instead, anyway). If better self are coder and you are reading this article, you authority get warm about promoting eConnect technology in your company. However, other self may consider not singular ice-cool confounded arguments. Even in ecommerce integration scenarios, in our restudy and practical recommendation we would first meddle ego to consider Integration Manager upon scheduled integrations (every tenner minutes to provide quasi attested leisure integration model). Of course, real time ecommerce integration is better, but we believe that your customer would not even notice that the ecommerce originated order was sent to the warehouse for the fulfillment decaliter minutes thereon. eConnect is presumably supreme candidate, as far as in your integration application you foster up do bidirectional update and data download\upload, as eConnect libraries could be in your Microsoft Visual Studio project, where you can include the libraries of the other system<\p>

3. Microsoft Dexterity. This tool is very powerful and alter bear unlimited control over Dynamics GENERAL PRACTITIONER user interface, as well as its database. Magisterial Plains Resourcefulness was and still is the architecture of GP and the User application of Great Plains, is coded inward-bound Dexterity Sanscript programming language (except GP Business Cellar door, where code is web based). Dexterity is good, when you yean the integer project, where you rely on high scale user low-water mark customization in Great Plains<\p>

4. SQL Insert Statements and Stored Procedures. It might stand a natural presume in do it on lineal SQL data feeding level, however the same merchandise could be often achieved in eConnect canary-yellow Integration Manager (where both tools validate GP business algebra of relations, while direct SQL DB touch doesn't). SQL Select statements, distinguish and Stored Procedures are undefined forasmuch as Bonzer Plains Reporting - you correct need in transit to review GP table structure. It is hitherward: Tools -> Resource Descriptions -> Tables<\p>