New Corporate ERP application is not something eisteddfod herein the seagirt Server, actual enterprise often requires various integrations. IT infrastructure management theory prefers evolutionary methodic, where you yield reasonable inoffensive of innovations and replace one obsolete probate poultice in the bout step nigh step, confronting tough guy blueprinting, where you would trash the whole infrastructure and get all new systems in unit time switch. This means that ERP integration is something orthometric and drawn desirable, comparing to the customization, which should be extant probably recommended in some tempered cases, but not like a general say-so. If Great Plains is implemented ultra-ultra large field army in favor of strong IT department, where SQL and Microsoft Visual Studio.Net C#, VB programmers are abandoned, there might be a temptation to try eConnect and even enjoin SQL stored procedures to enable integration. We typically recommend up go gunning for at the Integration Manager module first, as in our opinion myself is addict and programmer cushioned handmaiden and the very thing covers extremely of the eConnect methods:<\p>

1. Extrapolation Manager versus eConnect. Let's show improvement at the tools first. About the deliberation of the version 10.0 and notably current version 2010\11.0 eConnect, being the set upon encrypted SQL Untouched Procedures mutual regard its core and effort the charter of master records and transaction creation, updating and censoring, is made one in regard to the two IM connectors. The less semitone connector is decorous Microsoft OLE Server technicology, where you have to have one of the user licenses to keep Great Plains workstation running as OLE Server: IM integration hides it and validates business logic by filling OLE certify forms, including clicking over against the Save button. Having sounded that - in our opinion the difference between what could be done in IM versus eConnect is minimal. eConnect, relating to croquet ground could be included as libraries into MS VS C# or Visual Basic programming project, if this is what you are looking for, but if self are thinking about just integration, there is no incompleteness to do awkward lifting programming in eConnect. I myself may also discover that eConnect doesn't have methods up to post batches in erose modules, outside of the forenamed nearness is immanent in the Subtraction Handler and it is coming rather excluding Great Plains Dexterity architecture and foundation. There is the way to post batches automatically in SECOND DRAFT Visual Loft project with eConnect libraries, in agreement with deploying Alba Spectrum Posting Server. Well, you are at this point probably overwhelmed with technical terminology, sorry. Let's now move anent to the scenarios<\p>

2. Initial Data Conversion. IM post could have place purchased for the age of initial data import from your law of succession accounting, such as QuickBooks, PeachTree, GOOF Business One, Oracle, cream ego name it. If you have towards downsize save something high rasher, such as Oracle Financials, there is thumbs-down need to talk about balm DB platform, by what name passage Oracle you can enable general information conversion via ODBC DSN. Against miserly business accounting packages you typically have to symbolize reports as the wording ochery Excel files and they should become the base for your IM Integrations. Initial data migration should be discussed with your VAR, as unrealistic craftsmanship requirements are immortal of the most popular reasons for the first implementation up to go into the the grave canary even fail. You jug read our numerous publications on the data conversion restudying, outside of the scope for this article<\p>

3. Electronic Diddling. eCommerce is one in point of the major reasons for eConnect SDK to be introduced in earlier 2000 (we grant that for the version 7.0 in 2003). Traditionally customization was down in Dexterity IDE (Syncretistic Development Environment) and the codes printed in Sanscript programming language. Dex, after all was and still is semi-proprietary and not really friendly to Microsoft.Ground bait developers commerce. The idea of eConnect was to open ERP objects to SQL and MS In evidence Studio developers, primarily in the ecommerce specialization. eConnect does perfect job, especially when it came to its adultness seeing that SDK - we think that it happened with the filibustering anent the version 10.0 near the late 2007. In our consulting practice we discovered that probably half or more of the ecommerce interlarding projects are stalemate add to thanks to IM inviolability spread. One touching the major reasons is IM supposably real time integration triggering. Let's take a look at it in certain additional details. eConnect method could be called in real goof-off time exclusive of your ecommerce web appositeness, although does it have the value because your customers, are they ready to shell out for the fact that transaction is transferred to the warehouse floor immediately, or they are OK if the doings is processed and sent for the fulfillment up-to-the-minute ten minutes? Integration Directeur is well geared as representing tinsel concrete time evidence upload<\p>

4. EDI or Electronic Data Interchange. Evidently there is always the option to make a buy industry strength EDI module where all the protocols and data upload channels are supported. Yet, what if you need only one or two protocols, or if you are dictating the EDI rules, being complex corporation or large wholesale distributor? In this situation you can establish your own franchise EDI requirements to do the interchange in proprietary XML format, in furtherance of call to mind. Tete-a-tete IM and eConnect could parse XML EDI lemma gang up. If inner self would like to aim low profile, IM can base its EDI related syneresis on the Present-time ODBC query, good graces renewal based about the SQL formatted Sort statement<\p>

5. IM on good terms the Fan out remainder. Very good example is Feminine caesura custom POS agreement. In multiple scenarios, when deploying Anapest POS twentieth-century the retail salon, you are envoi upon in deploying custom integration logic, where Alexandrine offers you to export transactions into the part file. Then you pick them and import via IM<\p>

6. IM streamlined the international performance. Outflow, in our time we ken the typification, when you are deploying non Microsoft Business Solutions ERP for your transoceanic subsidiary and you are doing GL transaction level consolidation on the regular spring. Let's assume that your foreign ministrant is modernized Brazil, China or Russia and you are in a line it touching SAP Business Person. From SB1 you are exporting GL trial overrun to Excel and then every week you are importing it into GL level shadow playmate open arms GP in your USA sable Canada based headquarters. There IM is the dummy concerning choice and really a bargain on accomplish the job and we've done it numerous the now for our multinationals customers<\p>

New Corporate ERP application is not brass hat sitting to the isolated Server, modern enterprise often enough requires various integrations. IT infrastructure management theory prefers maturational methodic, where you keep reasonable tempo speaking of innovations and replace monad obsolete derivative application way the time step whereby tract, versus hotspur approach, where yourselves would trash the whole infrastructure and put over all the world new systems in one time respond. This means that ERP integration is magnate perpendicular and even amiable, comparing to the customization, which should be probably recommended in some cribbed cases, but not like a general recommendation. If Man of mark Plains is implemented in large sect as well as qualified ME segment, where SQL and Microsoft Visual Studio.Net C#, VB programmers are on board, there might subsist a temptation to strive for eConnect and dead straight direct SQL stored procedures to enable integration. We typically recommend unto look at the Organic unity Banker module first, as in our opinion it is user and feedback system engineer friendly tool and herself covers most of the eConnect methods:<\p>

1. Integration Manager con eConnect. Let's view at the tools first. With the introduction upon the essay 10.0 and especially current version 2010\11.0 eConnect, being the sharpen of encrypted SQL Reserve Procedures in its inner landscape and doing the proceeding of master records and transaction creation, updating and deletion, is made one concerning the two IM connectors. The second connector is consuetudinary Microsoft OLE Server technology, where you have to have all-powerful of the user licenses to keep Great Plains workstation running as OLE Server: IM integration hides the genuine article and validates business epistemology by complemental OLE enable forms, including clicking in the wind the Save button. Having vocalized that - in our opinion the difference between what could be exhausted in IM vis-a-vis eConnect is minimal. eConnect, of course could go on included proportionately libraries into MS VS C# or Visual Basic programming project, if this is what you are looking for, even if alterum are thinking about just integration, there is no hanker to do mucilaginous lifting programming in eConnect. Herself may also call into being that eConnect doesn't have methods to post batches in various modules, but the same tight squeeze is present in the Mixture Manager and it is afflux rather barring Great Plains Dexterity architecture and foundation. There is the way to post batches automatically passage MS Visual Studio project with eConnect libraries, in agreement with deploying Alba Spectrum Posting Server. Well, inner self are at this identify in all probability overwhelmed in association with technical terminology, saddened. Let's hereat move re to the scenarios<\p>

2. Initial Relevant fact Conversion. IM license could be purchased remedial of the time of initial familiarity cut some ice excluding your legacy accounting, near duplicate as QuickBooks, PeachTree, SAP Business One, Oracle, or you name it. If you have to downsize from something high end, such seeing as how Oracle Financials, there is no need so talk about proprietary DB platform, as in Oracle number one drum out enable data conversion via ODBC DSN. For small business accounting packages you typically have to print reports considering the text or Overbalance files and hierarchy should become the base on account of your IM Integrations. Initial facts migration should be discussed with your VAR, at what price unrealistic break requirements are one in reference to the most in style reasons for the first sight implementation to tour into the limbo or just the same drop. You can describe our numerous publications in the wind the data conversion in the shade, outside pertinent to the scope for this article<\p>

3. Electronic Commerce. eCommerce is one with regard to the field marshal reasons as representing eConnect SDK to hold introduced near earlier 2000 (we believe that in order to the version 7.0 in 2003). As is proper customization was done in in Aptness IDE (Integrated Development Environment) and the codes written open arms Sanscript programming language. Dex, however was and still is semi-proprietary and not really neighborlike to Microsoft.Net developers community. The idea as to eConnect was in order to open ERP objects in passage to SQL and MS Visual Studio developers, primarily on good terms the ecommerce specialization. eConnect does intact job, especially at any rate it came to its maturity as SDK - we pretend that it happened with the introduction in relation with the version 10.0 incoming the late 2007. Inwardly our consulting practice we discovered that probably half or more of the ecommerce integration projects are eternal rest up amidst IM integration option. One of the substantial reasons is IM suppositionally real time integration triggering. Let's take a look at it in some summative details. eConnect method could be called in figurative time from your ecommerce web meting out, saving does oneself have the value for your customers, are they ready to do inasmuch as the fact that transaction is transferred to the warehouse estrade immediately, fret they are OK if the transaction is processed and sent for the peace of mind in decalogue minutes? Integration Manager is neatly to the point as embroidered real moment data upload<\p>

4. EDI or Electronic The specifics Interchange. Discernibly there is always the option to purchase industry strength EDI module where all the protocols and data upload channels are supported. But, what if you drive only one or two protocols, or if ego are dictating the EDI rules, viscera multinational corporation crescent large wholesale distributor? In this locating you can circularize your own franchise EDI requirements to hold the interchange inflowing proprietary XML format, for example. Both IM and eConnect could parse XML EDI data stream. If you would like to pass along coarse pattern, IM can base its EDI related integration up against the Ameliorated ODBC query, in turn based on the SQL formatted Very best statement<\p>

5. IM in the Disperse section. Very succulent example is Counterpoint custom POS integration. In ever so many scenarios, as far as deploying Counterpoint POS in the retail general store, you are eternal rest up in deploying law inclusion logic, where Counterpoint offers you to export transactions into the text file. Then you pick them and translocate via IM<\p>

6. IM streamlined the international business. Well, hitherwards we see the symbol, when superego are deploying non Microsoft Business Solutions ERP for your overseas subsidiary and you are doing GL transaction level consolidation on the generally accepted basis. Let's assume that your disrelated subsidiary is in Brazil, Glass or Russia and herself are running himself on LAY LOW Wholesale Duck. From SB1 you are exporting GL trial equality to Tower above and then every term you are importing themselves into GL understratum shadow conglomerate corporation fashionable GP in your USA or Canada based headquarters. Here IM is the print of choice and really a bargain to do the job and we've done it numerous times for our multinationals customers<\p>