Microsoft Great Plains Integrations - Tricks For Developer

From DataScienceAndEngineeringWiki
Revision as of 17:06, 7 July 2014 by Corrina66 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

In this limited FAQ design and style post we'd like to introduce you - software developer, programmer, database administrator into Microsoft Excellent Plains Integration equipment and possibilities

Microsoft Excellent Plains is main Microsoft Company Methods product for US mid-market. Historically Terrific Plains Software developed Terrific Plains Dynamics and Dynamics C/S+ as multiplatform software as well as integration was probable through Wonderful Plains Dexterity or Dexterity-based close person resources, for instance Import Utility and later on via Integration Manager. When Microsoft Home windows system gained the OS sector (the final fight was in 1997 with PowerMac) Great Plains encouraged OLE Server method: Continuum for VB and Delphi and new Microsoft light programming technology - VBA (Visual Primary for Applications), which was integrated into Dexterity application - Excellent Plains Modifier (calls for customization website enabler license). Since then Good Plains Dynamics/eEnterprise integration procedures use Microsoft technologies.

Microsoft SQL Server method. This integration procedure utilizes SQL saved processes and views to pull information from the legacy or 3rd party application and press it into Good Plains. The great detail about MS SQL Server - it's got connected server technologies - you are able to set up the link to almost all ODBC ir OLEDB compliant databases: Oracle, DB2/Unidata, Sybase, Ingress, Lotus/Domino, Pervasive SQL/Btrieve, Ctree/Faircom, Microsoft Entry, Foxpro to call a couple of. You could agenda your integration as upkeep http://www.beewaits.com/2014/06/pretty-woman-and-great-plains.html occupation or DTS package deal. Having said that keep in mind that Fantastic Plains tables structure is very advanced (it has master information, summaries, historic, function, open tables) and you must in all probability confirm your stored methods organization logic with Excellent Plains source code (DYNAMICS.DIC with Dexterity strategies and functions scripts - in frequent DYNAMICS.DIC these are generally stripped out - not just about every MBS companion has supply code membership - so do your assortment do the job)

Excellent Plains Dexterity integration with Good Plains approach server. This really is much more superior and advised technique, nevertheless it calls for innovative Dexterity programming skills and entry to the source code. The idea at the rear of is simple - you populate so-called triggering personalized desk and after that look at it from Dexterity tailor made application just about every 5 seconds or so. If your record is there - you then procedure it. Processing is generally Dexterity resource code stored method connect with. Excellent Plains employs equivalent logic once you submit the batch and find out the status in Approach Keep track of window. If you never have resource code - you may attempt to do the very best guess with Microsoft Good Plains Program Advancement Kit (SDK)

Great Plains Integration Supervisor. That is end consumer tool and it is convenient to use. However - it makes use of Excellent Plains as OLE Server and phone calls Terrific Plains sorts at the rear of the scenes. Since the final result - it's pretty sluggish - we advocate employing integration supervisor if you have as much as 1 thousand transactions a day.

eConnect - it's sort of Software program Enhancement Package with samples in VB.Web. Naturally the development natural environment should be Visual Studio.Net. eConnect will permit you to integrate master information - like new consumers, distributors, workforce, and so on, additionally you'll be able to deliver transactions into so termed Great Plains do the job tables (eConnect won't enable you to carry open up or historical information - you require to write-up perform information in Fantastic Plains, a similar limitation relates to Integration Manager above) eConnect is very for ongoing integration. It was at first established for eCommerce application integration to Good Plains.