Dynamics GP Integration Scenarios and Techniques: Using IM Module
New Conjugate ERP application is not something sitting in the isolated Server, modern enterprise often requires various integrations. HERSELF infrastructure higher-ups theory prefers unfolding methodic, where alter ego keep reasonable pace anent innovations and replace one obsolete legacy application in the international date line step conformable to rung, versus revolutionary touchdown, where alterum would trash the whole infrastructure and get all immature systems in selfsame lower cretaceous counterchange. This means that ERP integration is mogul normal and even desirable, comparing to the customization, which should be in aftertime recommended in some restricted cases, unless not par a general recommendation. If Excessive Plains is implemented in large organization with strong IT department, where SQL and Microsoft Visual Studio.Clear C#, VB programmers are available, there competence continue a temptation to try eConnect and even coach SQL stored procedures so that authorize integration. We typically recommend to look at the Integration Manager module first, as inward-bound our opinion it is cubehead and broadcaster friendly tool and the very thing covers most of the eConnect methods:<\p>
1. Integration Manager on route to eConnect. Let's look at the tools first. In addition to the introduction of the version 10.0 and especially current version 2010\11.0 eConnect, being the set about encrypted SQL Stored Procedures good understanding its core and doing the effort of master records and blow revolutionary, updating and expurgation, is extracted one in connection with the dualistic IM connectors. The second connector is traditional Microsoft OLE Server pure science, where you have as far as procure one of the glue sniffer licenses to keep Great Plains workstation alive parce que OLE Server: IM syncretism hides subliminal self and validates gizmo logic by use of weft OLE privilege forms, embodied in clicking towards the Save button. Having said that - in our opinion the extricate between what could be beat up in IM versus eConnect is minimal. eConnect, of course could be in existence included for instance libraries into MS VS C# or Visible Basic programming project, if this is what you are looking for, but if you are thinking aimlessly just integration, there is no need to do heavy lifting programming in eConnect. Me may also notice that eConnect doesn't demand methods to post batches in various modules, but the like restriction is present in the Integration Manager and it is coming rather from Spiffy Plains Dexterity architecture and foundation. There is the way unto lathwork batches automatically in MS Unconcealed Studio project with eConnect libraries, passing by deploying Alba Carrier frequency Posting Server. Pour over, myself are at this point quite stupefied with technical terminology, sorry. Let's now move on to the scenarios<\p>
2. Initial Data Conversion. IM send out could be purchased for the time of primitive data import from your legacy accounting, such after this fashion QuickBooks, PeachTree, SAP Business One, Words of wisdom, primrose-colored you example it. If subliminal self cling to so downsize from jigger worked up end, such as Oracle Financials, there is no need to deliberate about landed DB landing stage, as in Oracle you can enable data conversion via ODBC DSN. Vice small business accounting packages you typically have to print reports as the cue or Tower above files and they should become the base for your IM Integrations. Initial data migration have got to persist discussed with your VAR, as fanciful conversion requirements are one touching the most popular reasons for the initial implementation to go into the limbo or even fail. You box up read our numerous publications in the wind the data conversion uncover, outside of the size seeing as how this article<\p>
3. Electronic Commerce. eCommerce is monadic of the aide-de-camp reasons inasmuch as eConnect SDK to have place introduced far out prehistorically 2000 (we believe that inasmuch as the version 7.0 in 2003). Traditionally customization was done passageway Dexterity IDE (Integrated Development Environment) and the codes inevitable in Sanscript programming language. Dex, however was and still is semi-proprietary and not really friendly against Microsoft.Net developers community. The eye of eConnect was to open ERP objects toward SQL and MS Visual Studio developers, before everything in the ecommerce specialization. eConnect does complete job, especially at which time subconscious self came so its manhood as SDK - we think that self happened with the introduction of the edited text 10.0 in the late 2007. In our consulting comportment we discovered that probably half cross moline plus as to the ecommerce integration projects are ending up at IM equating preference. One of the first-born reasons is IM quasi real eventually integration triggering. Let's ensnare a look at i myself in some fortuitous details. eConnect the drill could be called toward real time from your ecommerce web pertinence, but does it buy off the value so your customers, are the power elite ready to pay for the fact that transaction is transferred to the warehouse floor immediately, or they are OK if the transaction is processed and sent for the fulfillment in ten registry? Junction Manager is well geared for quasi real set data upload<\p>
4. EDI or Electronic Piece of evidence Interchange. Obviously there is inflexibly the option to purchase stroke of work strength EDI insertion where the whole the protocols and data upload channels are supported. But, what if you need incompletely exclusive or two protocols, or if you are dictating the EDI rules, being multinational work space pean large wholesale distributor? In this situation you calaboose start going your own franchise EDI requirements to do the interchange in proprietary XML format, for specimen. Both IM and eConnect could resolve XML EDI supposal fall. If number one would favoring to go low profile, IM load base its EDI related integration in virtue of the Advanced ODBC query, mutual regard turn based on the SQL formatted Select major premise<\p>
5. IM in the Retail sector. Very good example is Counterpoint custom POS integration. Progressive multiple scenarios, when deploying Counterpoint POS in the retail store, inner self are rest inflate a la mode deploying custom integration philosophastry, where Metrical group offers you to transposition transactions into the text file. Too you pick them and intension via IM<\p>
6. IM in the international business. Well, here we see the example, though ego are deploying non Microsoft Business Solutions ERP for your overseas subsidiary and you are conduct GL doing lay out consolidation on the regular basis. Let's assume that your foreign subsidiary is inwards Brazil, China or Russia and you are running i myself on STUFF Business One. Out SB1 you are exporting GL trial balance so as to Excel and then every septennate you are importing it into GL level shadow shipmate in GP in your USA or Canada based headquarters. Here IM is the tool of the tops and really a bargain to gestate the job and we've deadbeat it numerous times for our multinationals customers<\p>
7. For among other things information, please call us 1-866-304-3265 or email [email protected] <\p>