Page 1 of 1
Great Plains Integration
Posted: Wed May 28, 2008 5:26 pm
by katiebruno
Has anyone out there integrated AbleCommerce with Great Plains or have a suggested strategy? I have a client with a very large inventory with all sales information in Great Plains and they would like to have real time sales numbers for both the warehouse and the webstore integrated so that they can share the same inventory.
Re: Great Plains Integration
Posted: Wed May 28, 2008 11:38 pm
by AbleMods
I haven't heard of anything yet for Great Plains. Does GP have an SDK or API interface?
I haven't worked with GP for many years...didn't realize it was still around.
Re: Great Plains Integration
Posted: Thu May 29, 2008 7:35 am
by katiebruno
Yes it does.
http://msdn.microsoft.com/en-us/library/ms994230.aspx
My question to the client is what version of Great Plains are they running. If they are in the .NET version, I am willing to go for it. If they are still using the legacy Dexterity version, forget it.
Re: Great Plains Integration
Posted: Thu May 29, 2008 7:57 am
by AbleMods
That's why I haven't seen it in a while, Microsoft bought it
Even if it's in .Net, you're still going to hit the server-side execution wall. Since AC7 is server-side code, GP will have to be on the web server as well or you'll have to expose the SQL db to the internet. Neither makes me feel real warm and fuzzy.
Otherwise, downloading the db to a local SQL install will be your only practical option although it's not very efficient. If Able gets some docs out on the data client API, things can get a whole lot simpler.
I'm writing a one-way Quickbooks interface right now...been going round-and-round on this for weeks now.
Welcome to the downside of server-side code execution
