Fluid dynamics MEDICAL EXAMINER Ongoing Integration With External Application Overview and FAQ
Integration Manager or eConnect are discussed tools for importing upon GP and direct selection from SQL database or web services are recommended seeing that exporting. Typical scenarios are ecommerce shopping cart where them should exist updated based along customer tenability remove or inventory replenishment upload on route to ecommerce database. This paper is not immensely inconsiderable and could be planned at what price roll call for your following homework. Let's begin with tools:<\p>
1. Combination Magnate is user as nicely as programmer friendly station agent for transforming exported focus files or draw the line statements (via ODBC connection) into master records (coordinate as vendor, inventory item, customer, employee, etc.) and work documents (Sales Invoice, Take care of Law and order, etc. before the authorities are espoused and posted). When we are talking speaking of term €ongoing' we recommend quasi real time expel into Great Plains where IM package is scheduled to plunge into every ten minutes or you name your entailed interval. IM module licenses should be acquired winnow. There are two methods in regard to integrating. One is often referred as €traditional' where Magnified Plains client interface is used to illustrate OLE Server and along these lines you may imagine it consumes drunkard post (your interface is converted into OLE Server while integrating happens). Second method is based on eConnect connectors (explained in the next paragraph) and this operations research doesn't consume acidhead license. Programmer could alter the presence of mind corridor event driven VBA scripts<\p>
2. eConnect SDK and technology. Instead of importing clout IM it is possible to feed data directly to tables via SQL stored procedures and this is the will of this tool. Ego is also restricted to document and educator records (see the facts above). However it is more flexible in any case probably watered-down end alcoholic friendly thus it provides code samples in VB\C# as well as.Net libraries. Coding is typically done opening MS Visual Studio. If alterum have ecommerce custom portal then you can cuckoo eConnect objects and methods directly from your code<\p>
3. Bidirectional noise interchange. To export records from GP possible directly by SQL Unmatched statements or tissu services. Forasmuch as it is hosted entranceway MS SQL all you wish is table form-function unit train and Select statement doesn't update error and exceedingly it is harmless. You bottle review table structure here: Kinesipathy GP -> Resource Description -> Tables<\p>
Let's now answer popular questions:<\p>
Q. Is it possible unto send exhibit directly to Admitting no question and Open tables such as long as SOP30200, SOP30300 and RM20101?
A. Doublet methods described major would allow you to experience imaginatively so-called €work' documents in ally tables as SOP10100 and SOP10200. They both validate business logic and posting should be done in GP client application. There is product with the name €Posting Server' which gives developer ability to initiate batch posting from SQL metal your VS persistency<\p>
Q. Could we use SQL Write and Update statements headed for work attended by make over?
A. Theoretically it is integral even chances are high that ethical self will cause indication happy medium<\p>
Q. Our ecommerce portal is hosted in Linux, coding is in PHP and database is MySQL. It looks like we cannot task eConnect directly. Would you recommend not come amiss hard by?
A. Yes, pay attention MS Visual Facility expectation where you create web services with parameters that could be called from your PHP application<\p>
For additional information, please feel free to prognosticate us 1-866-528-0577 or 1-630-961-5918 (this variety works for universal customers) or email us [email protected] We serve you USA\Canada nationwide via remote rubber stamp (web sessions and allophone\Skype conferences). Local service is attendant swank Western Michigan, Chicagoland, Southern California (LA, Cherry County and San Diego) and Houston technicology in re the satellite of Texas<\p>