eCommerce B2B and B2C Shopping Cart Integration to Microsoft Dynamics GP Programmer Notes

Dec 18
09:07

2009

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

If you are working for the organization, deploying Microsoft Dynamics GP, formerly also referred as Great Plains Dynamics and your next step is ecommerce shopping cart integration to your Corporate ERP (Microsoft Great Plains Dynamics GP), we would like to recommend you this small publication written in FAQ technical style

mediaimage
eCommerce and Microsoft Dynamics GP integration is very popular topic,eCommerce B2B and B2C Shopping Cart Integration to Microsoft Dynamics GP Programmer Notes  Articles especially among ecommerce Microsoft Visual Studio C# and VB developers, as there is special SDK, named eConnect.  Plus, we would recommend you to review Microsoft Dynamics GP Integration Manager in eCommerce integration environment, especially in batch or in quasi real time mode (scheduled every hour or every twenty minutes).  Let's begin to review details:
1. eConnect SDK for Dynamics GP.  If you are experienced or even new Microsoft Visual Studio programmer with some exposure to C#, VB, XML, SQL Stored Procedures, then eConnect should be open for your self discovery.  In eConnect ecommerce integration you can realize both Business to Business and Business to Customer scenarios, where B2C is realized for special walk in customer ID.  If you decided to study eConnect as programmer, please consider reviewing sample codes in C# and VB.Net
2. Microsoft Dynamics GP Integration Manager.  For GP version 10.0 Integration Manager was rewritten in eConnect connectors, so there is less concern about formerly known IM performance issues, as eConnect is based on encrypted SQL Stored Procedures and their performance is definitely faster comparing to traditional Great Plains OLE Server (in earlier versions of Integration Manager).  As we mentioned above IM could be scheduled to run every hour or half an hour (to imitate quasi real time integration mode)
3. Breaking through eConnect and Integration Manager limitations.  Both tools do not allow automatic batch posting in Dynamics GP and this is architectural limitation.  Microsoft Dynamics GP Batch posting is something you normally expect to be approved and executed by GP user.  However there is the way to post Dynamics GP batches from eConnect libraries directly.  Please review Alba Spectrum Posting Server, visit our video presentation on Alba Spectrum website.  For those of you who are on old Great Plains or Microsoft Dynamics GP version, we recommend Order Connector to help with eCommerce B2B or B2C integration.  Order connector is programmed in SQL Stored Procedures to provide compatibility with the older versions: 9.0, 8.0, 7.5, 7.0, 6.0, 5.5, 5.0