Great,Plains,eCommerce,Integra computer Great Plains eCommerce Integration overview
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
There is some chance, however, that if you are reading theselines you are on older Great Plains Dynamics GP version: 8.0, 7.5, 7.0, 6.0,5.5, 5.0 or earlier or even on Great Plains on Pervasive SQL Server orCtree. In old Great Plains Dynamics youhave to program Microsoft SQL Server Stored Procedures or automate Great PlainsIntegration Manager Integration to work every 10 minutes or so. Lets review the scenarios. Again, real life could be more complex, andthere you need to call our office to get your case reviewed: 1. eConnect. This Software Development Kit, or in essencestack of interface calling technologies, based on SQL encrypted storedprocedures, is available to you if you are on Dynamics GP 10.0 and also withsome restrictions if you are on Great Plains Dynamics GP 9.0. If you are on older Dynamics GP versions,econnect was in progress of being developed at the time, and it is up to you totry to deploy it we recommend you to upgrade to Dynamics GP 10.0 and thenwork on eConnect integration programming 2. SQLStored Procedures Approach. If eConnectis not an option for you, this means that you are on historical Dynamics GPGreat Plains version, then you should consider direct SQL scripting to developyour ecommerce integration. This job isreally hard and prone to multiple data integrity errors and probes. If you are experienced MS SQL Server DBA andyou feel like you are ready to learn new MRP and ERP application, MicrosoftDynamics GP including its data flow scenarios, and your job is secured forthe next few years, then go ahead and try SQL Stored Procedures programming toaccomplish Dynamics GP Great Plains integration project 3. PervasiveSQL and Ctree. These are really archaicversions, and if you have to commit to those older Great Plains platforms,please consider creative solutions, such as importing data to Great Plainstables via Microsoft SQL Server linked server constructions. If you are doing direct Great Plains datarepair, use Microsoft Access with ODBC connection to GP tables via linkedtables technique
Great,Plains,eCommerce,Integra