50
I have a need to connect to Dynamics GP from Java to pull/update information. What is the best way of doing it.
I see that their is something called econnect - which provides different ways
1) MSMQ, 2)BixTalk etc.
Which is the best way to connect? We don't host Dynamics GP, we just need to integrate to our clients Dynamics GP to pull/update data.
Thanks
*This post is locked for comments
There is no specific way to get this data using Java as such.
Your summary options are:
1. Use a SQL type query run by the Java application to periodically query the relevant GP data and present it for upload to your applicaion.
2. Write your own triggers to run when new data enters the relevant GP tables (Not advisable unless you have no other options).
3. Use eConnect to export data as the event happens in GP. If its Sales Orders / Purchase Orders etc then this is probably your best option. (Remember, Microsoft could change the underlying GP tables in new releases - using eConnect protects your initial investment in setting up these 'outegrations'...if you write your own triggers or base it on queries - these may have to be revisited when you upgrade GP).
Your choice between 1 and 3 depends on how you need the data presented - in real time or in batch, Just new records or all records and the Java applicaion synchronises etc.
The question of whether its strictly .net or Java is really too broad to answer here. In a way its not really a choice between Java and .Net. It would require proper analysis of requirements before one could advise you - If GP / eConnect / SQL is not your area of expertise, you could do worse than engage with a willing GP Partner.
Best regards,
Ian.
Hi - the best starting point is eConnect. You can use the eConnect outgoing service to 'react' when something happens in GP and send out data that your system can then pick up.
A lot depends on exactly what data you want exported and when.
Ian.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (