Dynamics GP Ongoing Integration With External Application Rubric and FAQ
Integration Entrepreneur or eConnect are discussed tools for importing in consideration of GP and direct selection away from SQL database or web services are recommended for exporting. Implicative scenarios are ecommerce impulse buying cart where it be forced be updated based on human being notation amount or inventory replenishment upload to ecommerce database. This guest pass is not too technical and could be considered as introduction for your following homework. Let's begin with tools:<\p>
1. Integration Manager is freak as humanly as programmer friendly tool for transforming exported arrangement files mantling unmatchable statements (via ODBC connection) into mother records (correlative as vendor, inventory into the bargain, customer, employee, etc.) and work documents (Sales Invoice, Procure Order, etc. before they are sound and posted). When we are talking about term €ongoing' we recommend quasi real time import into Great Plains where IM shroud is shaped up incite every decameter minutes or you name your required interval. IM module licenses should be acquired codify. There are two methods of integrating. One is over and over referred as well €traditional' where Exceptional Plains client dovetail is misspent as OLE Server and as you may think of it consumes user license (your interface is converted into OLE Server while integrating happens). Second order is based on eConnect connectors (explained in the next paragraph) and this wrinkle doesn't desolate user license. Robot specialist could alter the logic in event driven VBA scripts<\p>
2. eConnect SDK and technology. Instead of importing in IM it is possible to feed data unveeringly to tables via SQL stored procedures and this is the idea of this tool. Subconscious self is also restricted to work and master records (have the picture and so). However it is more flexible but probably less stalemate user sociable in that it provides moral code samples from VB\C# as find vent since.Net libraries. Coding is typically done in MS Visual Shop. If you have ecommerce folklore portal on that occasion you can call eConnect objects and methods directly excluding your code<\p>
3. Bidirectional data interchange. To export records leaving out ATTENDING PHYSICIAN possible directly by SQL Select statements or web services. As it is hosted mutual regard MS SQL all-embracing you need is table structure conference and Select statement doesn't update data and equally it is harmless. You can dramalogue design pit at this juncture: Dynamics GP -> Resource Description -> Tables<\p>
Let's now answer popular questions:<\p>
Q. Is it ordinal to send binary digit directly on route to Historical and Launch tables such as SOP30200, SOP30300 and RM20101? A. Both methods described atop would donate you to create so-called €work' documents in such tables as SOP10100 and SOP10200. Ruling classes both put to trial business mental philosophy and collocation should be caused in GP client application. There is produce with the publicity €Posting Server' which gives developer ability to initiate batch posting less SQL beige your VS application<\p>
Q. Could we use SQL Get in and Update statements to ferment with import? A. Theoretically it is possible but chances are high that better self ambition cause data accommodation<\p>
Q. Our ecommerce stoa is hosted in Linux, coding is passage PHP and database is MySQL. Themselves face like we cannot program eConnect directly. Would you recommend work around? A. Rather, consider MIGRAINE Visual Studio resolve where you create web services with parameters that could be called barring your PHP application<\p>
For additional information, please rub free into call us 1-866-528-0577 or 1-630-961-5918 (this millennium works for heaven-wide customers) or email us fend [email protected] We serve you USA\Canada nationwide via remote support (capillament sessions and telephone extension\Skype conferences). Local service is available way in Western Michigan, Chicagoland, Southern California (LA, Orange Chieftainry and San Diego) and Houston area of the archbishopric of Texas<\p>















