Dynamics GP Integration Instruments and Practical Recommendations Computers Articles | December 20 Wholesale Zach Gentry Jersey , 2010
Mid-market Corporate ERP application cannot be implemented in the isolated environment. It is often interconnected with other systems.? Microsoft Dynamics GP (formerly known as Great Plains Dynamics) is not an exception, and it has several Integration tools and technologies to choose from.


Some of them could be recommended for end users, Integration Manager, for example, others, such as Dexterity are proprietary and require Great Plains programmer involvement.? And some of the tools and technologies are pretty open for generic Microsoft Visual Studio.Net C# or VB programmer ? good example is eConnect SDK.? When you are relatively new to Dynamics GP system support and modification, we recommend you to first read various whitepapers on GP technology Wholesale Benny Snell Jr. Jersey , its layers, table structure and objects and transactions exposure via various methods (Dexterity, Integration Manager, eConnect, direct SQL Select statements, etc.).? This paper is intended as introduction, if you have specific questions Wholesale Justin Layne Jersey , we recommend you to review programmer guides as well as technology articles on Microsoft Business Solutions Customer Source web portal.? Let?s review the details:


1.?Integration Manager.? As we already mentioned above, this tool is end user friendly.? Its usage in the most common scenarios is like following.? You have external system (CRM, simple ecommerce shopping cart, Payroll, primitive EDI), which exports transaction log in the form of comma delimited text file.? Then in IM you should be able to setup simple integration to process these text files and import them into Dynamics GP intended transaction type (the most often likely to be ? General Ledger entry, Sales Order Processing Invoice).? If you see your scenario Wholesale Diontae Johnson Jersey , then you probably should consider Integration Manager to be purchased and deployed.? However, IM surprisingly is also deployed in relatively complex scenarios, where you may need to pull the transactions via ODBC from Microsoft SQL Server, MS Access or even non-Microsoft database, such as Oracle, Pervasive SQL, Ctree Wholesale Devin Bush Jersey , MySQLPHP to give you few examples.? Here, think about this option ? if you have Oracle custom application, you may create on your Dynamics GP hosting MS SQL Server so-called Linked Server, and then SQL View, which joins data from Dynamics GP company database