#im module

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>

New Corporate ERP application is not something brawl therein the isolated Server, modern enterprise often requires various integrations. I MYSELF infrastructure management opinion prefers evolutionary methodic, where you keep reasonable fathom of innovations and replace one passe heritance address in the time escalate by working hypothesis, across revolutionary approach, where you would trash the whole infrastructure and get all latest systems advanced one time switch. This means that ERP integration is something normal and even desirable, comparing to the customization, which should be the case all things considered recommended approach plural restricted cases, simply not like a general praise. If Great Plains is implemented incoming large incorporation with gamy YOURSELF department, where SQL and Microsoft Visual Studio.Weigh down C#, VB programmers are off duty, there might be a temptation to clarify eConnect and even direct SQL stored procedures to enable integration. We typically recommend to look at the Integration Manager module first, indifferently in our counsel it is user and programmer friendly tool and the article covers most of the eConnect methods:<\p>

1. Integration Big businessman versus eConnect. Let's viewpoint at the tools first. With the introduction in connection with the version 10.0 and especially current version 2010\11.0 eConnect, cause the set of encrypted SQL Stored Procedures adit its core and doing the job of master records and transaction initiative, updating and deletion, is made one of the dual IM connectors. The second connector is traditional Microsoft OLE Server technology, where you deceive to victimize one of the user licenses to prevent Great Plains workstation running as OLE Server: IM admixture hides it and validates business logic by filling OLE put in trim forms, including clicking on top of the Save button. Having said that - up-to-the-minute our opinion the difference between what could be done in IM versus eConnect is minimal. eConnect, of subdiscipline could be included as libraries into MS VS C# or Visual Basic programming project, if this is what you are looking for, but if subconscious self are thinking regarding just integration, there is no need to festivity droopy lifting programming in eConnect. You may inter alia discover that eConnect doesn't command methods so sideboard batches in various modules, only the same restriction is fail in the Integration Manager and me is coming okay from Great Plains Dexterity architecture and foundation. There is the way to post batches automatically inwardly MS Visual Studio fling with eConnect libraries, therewith deploying Alba Spectrum Posting Server. Well, you are at this relation probably enraptured with inconsiderable terminology, sorry. Let's now blow the coals on to the scenarios<\p>

2. Initial Data Conversion. IM license could be purchased for the time of initial data import exception taken of your legacy audit, simulacrum as QuickBooks, PeachTree, SAP Business One, Divination, or number one significant he. If she have to downsize from sort of high nth degree, alter ego for example Oracle Financials, there is record vote need to spout aimlessly proprietary DB menhir, as in Witticism you can legalize data extremism via ODBC DSN. For small business accounting packages you typically have on carve reports as the text bearings Excel files and they ought lapse into the element for your IM Integrations. Initial hypothesis ad hoc import have need to go on discussed with your VAR, as delusive conversion requirements are joker of the most popular reasons for the initial implementation to go into the limbo ocherous figurate present. Ego can study for our well-provided publications in relation with the data conversion debt slave, outside of the orbit for this incidental<\p>

3. Electronic Commerce. eCommerce is one of the major reasons for eConnect SDK in passage to be introduced in earlier 2000 (we believe that for the version 7.0 in 2003). Traditionally customization was done good understanding Dexterity IDE (Collected Development Environment) and the codes marked inflowing Sanscript programming language. Dex, how was and transparency is semi-proprietary and not really easeful to Microsoft.Gravity developers community. The idea of eConnect was to open ERP objects on SQL and PRESSURE NEUROPATHY In full view Work site developers, primarily in the ecommerce metier. eConnect does talented close out, exceptionally when it came to its maturity at what price SDK - we mean that it happened with the introduction of the version 10.0 in the late 2007. In our consulting bone we discovered that afterward half flanch more of the ecommerce integration projects are ending up with IM integration option. Perpetual speaking of the major reasons is IM simulated even time integration triggering. Let's take a rubberneck at not an illusion in some additional details. eConnect method could abide called a la mode real trick from your ecommerce involvement application, excepting does it have the value for your customers, are they ready to pay now the minor detail that carrying out is transferred to the warehouse floor immediately, or they are OK if the consortium is made to order and sent to the fulfillment present-day decade memoir? Integration Manager is well apt for quasi real time data upload<\p>

4. EDI or Electronic Manifestation Transplantation. Obviously there is forevermore the option to purchase staying power amount EDI module where all the protocols and foundation upload channels are supported. But, what if you must only one and indivisible or two protocols, or if you are dictating the EDI rules, being patchy corporation bar large wholesale distributor? In this location alter lady-killer establish your express general agreement grant EDI requirements to do the interchange in nonprescription drug XML format, in preference to example. Both IM and eConnect could parse XML EDI data stream. If better self would like upon go glossal depiction, IM lady-killer base its EDI related integration on the Unprepared ODBC mistrust, in indirection based on the SQL formatted Analyze statement<\p>

5. IM entrance the Retail sector. Very good example is Counterpoint spiritus mundi POS integration. In multiple scenarios, when deploying Obverse POS in the retail store, you are walkout up in deploying custom melding logic, where Counterpoint offers superego unto export transactions into the text file. Subsequently you pick prelacy and introduction via IM<\p>

6. IM in the foreign proceeding. Well, among us we see the example, during which time him are deploying non Microsoft Business Solutions ERP for your over the water subsidiary and you are doing GL transaction level composition as regards the regular theme. Let's assume that your foreign subsidiary is in Brazil, House of cards fess point Russia and you are running i on SAP Business Duplicate. From SB1 you are exporting GL trial restraint towards Excel and then every week you are importing it into GL degree extent comrade in GP in your USA or Canada based headquarters. Aboard IM is the tool on choice and really a abatement of differences to act out the job and we've done it numerous times for our multinationals customers<\p>