Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

I need to build an integrator with Dynamics GP

Posted on by 895

HI,

We are planning to develop an integrator with Microsoft Dynamics GP. It would be a plug in connector facilitating bi-directional data transfer between GP and one of our client applications. Please suggest pointers to implement this. Also recommend any specific modules that are to be used for such development tasks.

Any pointers would be helpful.

Thanks,

Pooja.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: I need to build an integrator with Dynamics GP

    Hi Pooja,

    If you are looking for a solution to integrate data between GP and your application, there are few good products out in the market dedicated for that. You can check DBSync or Informatica.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: I need to build an integrator with Dynamics GP

    Also have a look on the below link.

    sandipdjadhav.blogspot.in/.../types-of-integration-method-with.html

    Hope this helps!!!

  • Suggested answer
    Pooja Gurjar Profile Picture
    Pooja Gurjar 895 on at
    RE: I need to build an integrator with Dynamics GP

    Great. Thank you guys for all the help.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: I need to build an integrator with Dynamics GP

    Hi Pooja,

    Integration manager mainly run on pre-defined integration(s) while eConnect and Web services are user defined integartion.  

    Mainly speed of integration manager is slow while comparing with eConnect and Webservices, since it uses macro(s).

    For integration manager, your machine needs to idle during the integration since it executes a macro to perform the task. but if you use eConnect, it has predefined store procedure(s) that makes to run the integration task at the background mean while you can performing any task at the front end(eConnect service needs to be run during the integration process).

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: I need to build an integrator with Dynamics GP

    Pooja,

    Integration Manager Supports ONLY IMPORTS into Dynamics GP.  Integration Manager supports Text, SQL and eConnect adapters (sources) for importing data.  So if your integration were strictly an import and NOT bi-directional, Integration Manager would be a viable solution - it is not.

    msdn.microsoft.com/.../bb457191.aspx

    eConnect is an Application Programming Interface, which takes advantage of XML and Microsoft Message Queuing Services to provide real-time two way integration points between Dynamics GP and external applications, rather than just imports.  

    msdn.microsoft.com/.../aa973831.aspx

  • Pooja Gurjar Profile Picture
    Pooja Gurjar 895 on at
    RE: I need to build an integrator with Dynamics GP

    Thanks for the reply.

    I am still investigating on the econnect front. Could you please help me understand  the differences between econnect and Integration manager ? I am confused between the two since I can see both of them are being used for integration.

    Please help.

    Thanks,

    Pooja

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: I need to build an integrator with Dynamics GP

    Hi Pooja,

    As Harry explained, you can use either eConnect or Web Services to transfer\integrate data from external application(s) to GP.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: I need to build an integrator with Dynamics GP

    Pooja -

    You mentioned you're trying to write a bi-directional data transfer, so this rules out Integration Manager, a tool which support import (one-way) integration with Dynamics GP.  Here is a really good posting on eConnect vs. WebServices development.

    blogs.msdn.com/.../choosing-between-econnect-for-microsoft-dynamics-gp-and-web-services-for-microsoft-dynamics-gp.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,232 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans