Microsoft Fantastic Plains Integrations - Guidelines For Developer
During this small FAQ model report we'd like to introduce you - software program developer, programmer, databases administrator into Microsoft Excellent Plains Integration equipment and options
Microsoft Excellent Plains is principal Microsoft Company Alternatives products for US mid-market. Traditionally Excellent Plains Computer software built Terrific Plains Dynamics and Dynamics C/S+ as multiplatform software and also the integration was feasible by means of Great Plains Dexterity or Dexterity-based close person equipment, including Import Utility and later on by using Integration Supervisor. When Microsoft Home windows platform gained the OS market place (the final struggle was in 1997 with PowerMac) Wonderful Plains encouraged OLE Server technique: Continuum for VB and Delphi and new Microsoft light programming know-how - VBA (Visible Primary for Purposes), which was integrated into Dexterity software - Fantastic Plains Modifier (requires customization internet site enabler license). Since then Great Plains Dynamics/eEnterprise integration procedures use Microsoft systems.
Microsoft SQL Server method. This integration approach utilizes SQL saved methods and views to pull information from the legacy or third party application and force it into Terrific Plains. The nice point about MS SQL Server - it's linked server technology - it is possible to establish 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 some. You can program your integration as upkeep great plains dresses work or DTS offer. Even so take into account that Great Plains tables composition is quite complicated (it has learn records, summaries, historical, operate, open tables) so you need to possibly validate your stored methods enterprise logic with Terrific Plains supply code (DYNAMICS.DIC with Dexterity procedures and capabilities scripts - in common DYNAMICS.DIC these are definitely stripped out - not each individual MBS spouse has source code membership - so do your assortment get the job done)
Wonderful Plains Dexterity integration with Good Plains process server. This is certainly more innovative and proposed solution, nevertheless it demands sophisticated Dexterity programming techniques and usage of the supply code. The thought powering is straightforward - you populate so-called triggering customized table and then look at it from Dexterity tailor made software every five seconds or so. Should the history is there - then you definately procedure it. Processing is often Dexterity supply code saved technique call. Excellent Plains employs very similar logic if you post the batch and see the standing in Method Observe window. For those who you should not have supply code - you'll be able to make an effort to do the most beneficial guess with Microsoft Great Plains Application Growth Package (SDK)
Great Plains Integration Manager. That is conclude person tool which is simple to use. Nevertheless - it makes use of Fantastic Plains as OLE Server and phone calls Excellent Plains forms driving the scenes. Because the result - it really is very sluggish - we suggest making use of integration manager any time you have as many as one thousand transactions per day.
eConnect - it is form of Computer software Improvement Kit with samples in VB.Web. Of course the development surroundings ought to be Visual Studio.Web. eConnect allows you to definitely integrate grasp documents - including new clients, vendors, employees, etcetera, furthermore you can convey transactions into so called Terrific Plains work tables (eConnect will not permit you to convey open or historical data - you'll need to put up work records in Terrific Plains, the exact same limitation relates to Integration Supervisor earlier mentioned) eConnect is rather for ongoing integration. It had been at first created for eCommerce software integration to Excellent Plains.
