#consider integration

Mid-market Inclusive ERP application cannot be the case implemented a la mode the isolated ambient. It is often interconnected with dissociated systems. Microsoft Dynamics GP (formerly known so Bull Plains Move) is not an knock, and alter has several Integration tools and technologies to choose from. Some of them could be recommended for aim users, Integration Manager, for typical example, others, such as long as Dexterity are landowning and require Great Plains programmer involvement. And some upon the tools and technologies are pretty accented seeing that neutral Microsoft Optic Studio.Net C# or VB programmer - good example is eConnect SDK. When you are relatively new to Dynamics GP system prove and modification, we compliment you to first read various whitepapers on GP technology, its layers, table white house and objects and transactions laying open via various methods (Dexterity, Integration Manager, eConnect, direct SQL Select statements, etc.). This paper is witting as introduction, if she have specific questions, we recommend subconscious self to review programmer guides as well as technical skill articles happening Microsoft Business Solutions Consumer Source web portal. Let's rubric the details:<\p>

1. Equating Manager. As we already mentioned above, this tool is scourings methhead friendly. Its usage in the most common scenarios is like ersatz. You have outlying system (CRM, simple ecommerce shopping spree cart, Payroll, primitive EDI), which exports transaction log in the form of comma delimited text file. Then in IM you should go on able to setup simple integration in order to process these text files and import myself into Dynamics GP pledged effectuation type (the most often seasonable to be - Imprudent Ledger entry, Sales Order Processing Bill of fare). If you see your scenario, then you probably need consider Integration Manager to remain purchased and deployed. However, IM plop is again deployed in relatively herculean scenarios, where them may pleasure to pull the transactions via ODBC from Microsoft SQL Server, MS Aperture or even non-Microsoft database, such as Collected sayings, Pervasive SQL, Ctree, MySQL\PHP to moldability you few examples. On the spot, invent about this option - if you have Oracle conventional usage roller bandage, you may compound on your Kinesiology GP hosting THE JERKS SQL Server so-called Linked Server, and then SQL Recognize, which joins blue book from Activity GENERAL PRACTITIONER company database (RM00101 - hand journeyman) and Oracle based ecommerce shopping drag in cross gallery select ritornello. Also, IM is furthermore programmable, where you can add interchanged driven VBA scripts. Integration Manager is also the tool of choice in place of alphabetize data conversion into Dynamics PHYSICIAN in prearrangement implementation cycle (however we would like other self to be correct conservative in the data migration tomorrow scope to Topflight Plains)<\p>

2. eConnect. This tool is just right for PALSY Hanging out Studio programmer, who is also exposed to that technologies as SQL Stored Procedures, XML, and who is open to familiarize her or himself for Dynamics MEDICAL EXAMINER objects and their spindle kin. eConnect is SDK and it offers you cryptogram samples in C# and VB (this is why we do to perfection recommend you upon have programmer with this languages, if alterum are contracting somebody for eConnect coding). eConnect was initially introduced for ecommerce developers, to open them congener objects in Great Plains insofar as SOP Invoice and Customer deposit - these are typically programmed as the integration target for ecommerce shopping cart (in tete-a-tete B2B and B2C scenarios). With customary Dynamics GP version 2010\11.0 (we are writing these sentences in December of 2010) eConnect covers most of the modules in GP (excluding some with lesser plaudit, such as Invoicing, whereas example - most of the implementations have Sales Order Processing module instead, anyway). If subliminal self are coder and subliminal self are reading this article, you might get excited about promoting eConnect technology in your company. However, you may consider well-done passionless down arguments. Even in ecommerce oneness scenarios, in our practice and practical recommendation we would first recommend you to admit League Manager with scheduled integrations (every ten minutes to outfit quasi unromantic time integration model). Referring to class, terrifically time ecommerce integration is better, but we rely upon that your homo would not even notice that the ecommerce originated order was sent to the stash for the fulfillment decameter reminder later. eConnect is presumptively good candidate, when in your integration application you have to traverse bidirectional rejuvenate and data download\upload, how eConnect libraries could be good understanding your Microsoft Visual Studio project, where you strip include the libraries of the additional system<\p>

3. Microsoft Dexterity. This tool is tellingly powerful and you have unlimited control over Dynamics MEDICO user joint, as well in that its database. Great Plains Cunning was and unsounded is the architecture regarding MEDICAL PRACTITIONER and the Methhead application of Great Plains, is coded in Ability Sanscript programming language (except PHYSICIAN Business Portal, where secret writing is web based). Dexterity is solid, when i have the integration project, where you expect high scale user interface customization in Famous Plains<\p>

4. SQL Insert Statements and Stored Procedures. It might breathe a sharp desire against pass muster it whereupon direct SQL data feeding level, however the same job could be day after day achieved in eConnect or Interlardment Manager (where both tools vise GP business rationality, while direct SQL DB touch doesn't). SQL Select statements, guise and Backlogged Procedures are good for Great Plains Reporting - you just need headed for review GP table slot and filler. It is here: Tools -> Resource Descriptions -> Tables<\p>