Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

eConnect / Web Services?

Posted on by Microsoft Employee

Hi all, Firstly let me say, I am not a developer but am fairly IT savvy / technical. We are currently in the process of upgrading to Gp 2013 r2.

 

We have a 3rd party solution which processes our sales and I am looking for a method to automatically import these in to Dynamics GP based on the underlying data tables. Could any suggest the best solution and any good guides? I've spent most the day reading up on eConnect and Web Services and struggle to understand the differences.

Thanks

*This post is locked for comments

  • RE: eConnect / Web Services?

    Can you please clarify your question...……..what recommended steps or outline are you looking for, in regards to eConnect?

    Being it is a 5 year old forum, the more detail you can give for your question/ask, the better...……

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect / Web Services?

    hi soma,

    We have a crm called BPM online and we need to integrate the data to GP . We are currently using E connect for that . COuld you please give us the recommended steps or just an outline .

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: eConnect / Web Services?

    It would be either webservice or eConnect process. But, we can not confirm this without seeing the code and functionality. Better contact the service provider for this custom solution and get the detail about the same.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect / Web Services?

    Thanks all. We currently have a solution that when sales are processed through a webpage, they automatically appear in GP as a sales batch. This was custom designed and it's difficult to see how it runs, would you have thought it would have to be through webservices?

    Thanks.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: eConnect / Web Services?

    You can create the eConnect integration in both ways ( manually or automatic).

    To create a manual solution, create a integration and run it manually within GP(by adding button to any custom and run the integration) or out side GP (create a console application and double clicking the same).

    To create a automatic integration, create a console application to integrate the transaction from your custom table to GP and add it to window task scheduler to assign and run with specific time intervals.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect / Web Services?

    Many thanks for the reply and as said, I am looking at using eConnect. Does this always have to be run manually or can it be automated based on a condition change within the data?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect / Web Services?

    Hi Daniel,

    You can use any of the integration techniques such as eConnect, Web Services, Integration Manager, GP Macro integration using mail merge, Table import.

    Please find the below link about different integratio technique in GP.

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

    based on the data size, you can prefer any of the above techniques.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect / Web Services?

    Many thanks to you both for your time and answers. I am also leaning towards eConnect. Am I right in thinking the best way to use this is through Integration Manager? In addition, can these be set up to run dynamically as data objects change?

  • steveendow Profile Picture
    steveendow 2,281 on at
    RE: eConnect / Web Services?

    My first choice for custom integrations is eConnect, if the requirements allow for it.

    I have two simple reasons:

    1. It is simpler in many respects. The API is simpler, the infrastructure is simpler, the installation is simpler, the configuration is simpler, the maintenance is simpler.  That simplicity saves time and money.

    2. There are only a few cases where the web services architecture is a technical requirement.  Typically, this would be when you have to traverse a firewall, or perhaps when you want to have an external system directly access GP (which I do not advocate).  There are a few cases where there might be a requirement to use an API call that web services supports but eConnect does not (void, cancel, get list, etc.), but I have yet to encounter the need for web services over an eConnect + SQL solution.

    While I know that there are people that "prefer" web services or openly advocate it, I haven't yet heard a compelling argument justifying the additional infrastructure (web server), configuration, and complexity of web services as an integration solution in the absence of clear requirements for them.  Those things typically cost the client more money, so unless there is a strong technical or business requirement for them, I don't recommend them.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: eConnect / Web Services?

    Hi,

    Here's an article from the best regarding how to choose between the two.

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

    Kind regards,

    Leslie Vail

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans