_______________________________________________________________________________________

 Along the way Microsoft Great Plains launched newer tools such as eConnect, which
 is in fact a set of Stored Procedures which to some extent imitate the DEX Business
 logic (as eConnect doesn’t work with transaction or batch posting – you will need the
 Dynamics GP AutoPost to extend eConnect and enable Automatic Batch Posting
 from your eCommerce application).

_______________________________________________________________________________________

eConnect insider

This is a set of SQL Server encrypted stored procedures, which they give you, if you are an eCommerce Visual Studio C# or VB.Net developer/programmer, some feeling of OOP – Object Oriented Approach, which is obviously not present in the good old days of DEX. 

VBA/Modifier

This Integration Technology, and VBA scripting for Great Plains Integration Manager seems to be lasting a long time regardless of multiple (now historical) announcements of its phasing out.  It is available for version 10.0.

Dexterity Integrations

Dex has complete control over GP data and business processes, including posting, Sales Order Processing (SOP) orders transfer to invoices, etc. Dexterity was traditionally considered as the Great Plains Architecture.  However, as you can imagine is that every new version of GP is an addition and redesign of the former Dex dictionary – DYNAMICS.DIC –  where you expect Custom DEX Integration to comply with the new DEX Dictionary.  This is why you need to involve Dexterity Developers and Software Programmers.

XML Web Services and SQL Stored Procedures

A Web Service can call eConnect logic and it can work via ADO.Net with stored procs. SQL Scripting is allowed in Dynamics and company databases in GP (in comparison to MS CRM, where you can not alter CRM database).

Tables Import

We don’t recommend you to use this tool, as it originates from the older days of Great Plains Dynamics. It is wiser to utilize Integration Manager (IM), which validates business logic prior to inserting records into GP tables.

_______________________________________________________________________________________