• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 847
  • Last Modified:

Microsoft Dynamics GP integration Manager

Why is there  2 destination adapters in inegration manager ?

Great plains SQL OPT 8.00

Great Plains 8.00
1 Solution
Steve EndowMicrosoft MVP - Dynamics GPCommented:

"Standard" destination adapters are effectively macros that literally automate windows, button clicks, and data entry in GP.  They allow IM to utilize all of the business logic and data validation in GP, but they require that GP be open and logged in when the integration is run.

"SQL Optimized" destination adapaters utilize SQL stored procedures (I believe they now all utilize eConnect stored procs).  These destination adapters go directly against the database and do not rely on the GP user interface, so they run much faster and do not require GP to be running during the integration.  The downside is that not many transaction types are supported by SQL adapters, and those that do have some limitations.  For example, I think that SOP Transactions don't support serial and lot numbers with the SQL destination adapters, so if you need that functionality, you would have to use the standard adapter.

As eConnect and Web Services matures, I suspect that IM may eventually migrate more adapters to SQL optimized, but I've been thinking that for years and it doesn't seem to be happening.


Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now