web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect-2 Webs - One ...
Microsoft Dynamics GP (Archived)

eConnect-2 Webs - One db?

(0) ShareShare
ReportReport
Posted on by Richard Whaley 25,195

Can two different web sites (one serving the general public and a completely differerent web site serving selected professionals) both send SOP transactions to a single instance of GP and receive updates back on their specific orders using eConnect?  Has anyone done this?  How complex is this?

*This post is locked for comments

I have the same question (0)
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Haven't done it, but can't see why it won't be possible. In theory, each eConnect instance would be on a separate web server which would allow you to submit orders separately without any issues. Where I can see things getting a bit fishy is when setting up the Requester Service -- if this is how you plan to communicate updates to your web applications -- as the Requester Service can only address one MSMQ queue at a time. This would leave all messages in one queue from which the developer would have to write code to poll the queue and figure out what server should get updated. This can be perhaps avoided if the queue is queried by some sort of Windows service written to run asynchronously on each server.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    I did a little research yesterday and it seems that an instance of eConnect places it's own triggers on the host SQL tables.  That would mean that  if we had two instances of eConnect, one would overwrite the other?????

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    No, that would mean just what I said, you will get all updates to sales documents going to one eConnect_OUT table, which in turn would be sent off to one MSMQ queue. Hence, your developer will have to write a service to be deployed on each web server to read the queue and establish whether the document he/she is reading needs to update that web server. If so, he/she will also need to clear that message from the queue, otherwise leave it so the other service on the other server can do its thing too.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    the issue there is that we do not have control of one of the web servers.

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    In that case, you will want to write a service that checks which web server should the message in the queue update, rather than deploying services on the web servers.

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    I was thinking... one thing that occurs to me is that you can pass in the SQL Server name in one of those eConnect pre procedures then store it in a table with the transaction number in the eConnect post, since the transaction number (assuming it's auto-assigned by GP) will be known at that point.

    This way, your developer will know what server the transaction came from when they need to update at a later date.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans