Microsoft Great Plains Integrations - Strategies For Developer
During this shorter FAQ type short article we would wish to introduce you - computer software developer, programmer, database administrator into Microsoft Terrific Plains Integration instruments and selections
Microsoft Great Plains is key Microsoft Enterprise Methods solution for US mid-market. Traditionally Excellent Plains Application made Wonderful Plains Dynamics and Dynamics C/S+ as multiplatform application as well as integration was doable via Fantastic Plains Dexterity or Dexterity-based stop user equipment, for instance Import Utility and afterwards on through Integration Supervisor. When Microsoft Windows platform received the OS marketplace (the final struggle was in 1997 with PowerMac) Terrific Plains advised OLE Server technique: Continuum for VB and Delphi and new Microsoft light programming technologies - VBA (Visual Primary for Programs), which was built-in into Dexterity software - Great Plains Modifier (requires customization site enabler license). Because then Great Plains Dynamics/eEnterprise integration tactics use Microsoft systems.
Microsoft SQL Server solution. This integration procedure takes advantage of SQL stored techniques and views to drag info from your legacy or 3rd party application and force it into Good Plains. The good matter about MS SQL Server - it has linked server technology - you could create the backlink to pretty much all ODBC ir OLEDB compliant databases: Oracle, DB2/Unidata, Sybase, Ingress, Lotus/Domino, Pervasive SQL/Btrieve, Ctree/Faircom, Microsoft Obtain, Foxpro to name several. It is possible to plan your integration as upkeep http://www.beewaits.com/2014/06/pretty-woman-and-great-plains.html job or DTS bundle. Nevertheless keep in mind that Terrific Plains tables structure is quite advanced (it's got master documents, summaries, historic, work, open up tables) and also you must most likely validate your saved processes enterprise logic with Terrific Plains supply code (DYNAMICS.DIC with Dexterity strategies and features scripts - in standard DYNAMICS.DIC they are stripped out - not every single MBS lover has source code membership - so do your range work)
Good Plains Dexterity integration with Good Plains approach server. This is certainly a lot more state-of-the-art and recommended tactic, however it demands advanced Dexterity programming expertise and access to the supply code. The idea at the rear of is simple - you populate so-called triggering tailor made table and after that check out it from Dexterity custom made application every 5 seconds or so. Should the file is there - then you really system it. Processing is usually Dexterity supply code saved course of action connect with. Fantastic Plains uses very similar logic if you article the batch and see the position in Approach Check window. In case you never have source code - you can try and do the top guess with Microsoft Excellent Plains Software program Progress Package (SDK)
Fantastic Plains Integration Supervisor. This can be conclude consumer instrument and is simple to operate. Having said that - it works by using Excellent Plains as OLE Server and calls Excellent Plains types at the rear of the scenes. Because the end result - it is extremely sluggish - we recommend utilizing integration manager any time you have approximately a single thousand transactions every day.
eConnect - it can be kind of Computer software Development Kit with samples in VB.Net. Clearly the event setting ought to be Visual Studio.Net. eConnect enables you to definitely combine grasp documents - which include new customers, vendors, workforce, etc, additionally you can deliver transactions into so called Fantastic Plains operate tables (eConnect doesn't allow you to provide open up or historical documents - you will need to submit work data in Good Plains, a similar limitation applies to Integration Supervisor higher than) eConnect is rather for ongoing integration. It had been originally made for eCommerce software integration to Good Plains.
