You’re offline. This is a read only version of the page.
3,177
Hi
I have an eCommerce application and I was hoping to get some information related to best approach of integrating order related data with dynamics GP 10.
Thank You
*This post is locked for comments
Agreed. Much better in the long run. And if you have issues, MS will support you or your partner to resolve.
Upgrades will be much easier also.
Ian.
Thank you for the reply. Yes I understand the consequence of using the direct calling of db objects. That's why I was skeptical about using it. I think it is better to try the API of eConnect.
Thank You
Hi,
Using the stored procs directly is not recommended by Microsoft. Over the years we have come across a number of sites where this approach has been taken with mixed issues. We have switched all of them now to run using a .net service.Calling the SP's is not the recommended method and Microsoft can change anything they like in later releases. Really is best to use eConnect as intended. Yes, calling the SP's is a shortcut, but you're on your own if you do it.
I'm not saying you can't go down that route - just beware.
Ian.
Alaa, Can I directly call the eConnect stored procedures, can you give me an example or some links.
Thanks You
Thank you for the replies. I will work on the option provided and will update this thread with my approach.
You may also consider eConnect direct through SQL, there is a collection of Stored Procedures (the ones start with ta.....) almost for every function in GP. i personaly love it. your external application just need to make a call to the procedure with the required paramters.
let me know if you need any help
Thanks,
Hi, as said above, it really has to be eConnect (Smartconnect is built on eConnect) for robust large volume integration. Communications back can use the outgoing eConnect schemas - but this will depend on exactly what you are sending back to the eCommerce database.
Ian.
I have used SmartConnect from eOne Solutions to bring in order data from an external source into GP. It works great, and can be scheduled to run at any time during the day.
Thanks for the reply, I will work on it and update this thread.
eConnect has both an incoming and outgoing service although I've only ever used the incoming one.
eConnect 10 works fine; we started using it with this version. The most transactions I've seen a client put through in one day was about 500 which went through without issue.
eConnect works, in the method we used, by polling the MSMQ for eConnect xmls and loading them into GP. I've not read of any particular scale issues but perhaps someone else here has experience of larger use.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (