Great,Plains,Development,Dexte computer Great Plains Development: Dexterity, eConnect, .Net programm
----------------------------------------------------------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
Also, please take into consideration the fact, that Great Plains ERP was introduced to the market in earlier 1990th as Great Plains Software Dynamics and at this time it is matured system, which is pretty stable, but considering its size and all the available business logic it might be too complex to do modification without external consultant help. OK, lets go on and review the tools:1. Microsoft Dexterity. Former product name is Great Plains Dexterity. Dex has its own scripting language Sanscript and it is in fact Integrated Development Environment and architecture, which is a shell, written in C programming language in turn. Dex is virtually all-mighty, when you think about modifying GP business login and changing programmatically this ERP application. However you should understand that Dexterity was designed back in late 1980th, when such popular concepts as Object Oriented Programming (OOP) were not yet implanted. So, in fact Dex is procedural language and so, it requires more codes and it is not overly easy to debug Dexterity scripts. From time to time we hear from the customers, that they would like to put one of their in-staff programmers to lead and perform GP Dexterity customizations we think this is not practical, as again Dex requires relatively long learning curve (several years), which should be supported by programmer exposure to different GP modifications scenarios, which is typically impossible for internal employees2. eConnect. This SDK and development tool was dedicated initially to eCommerce programmers, who were considering to use GP as back end ERP for e-commerce web applications. eConnect heart is written in SQL stored procedures (they are encrypted and you can not alter their logic directly). There are various opinion on eConnect, in our opinion it is replication of Dexterity logic with some OOP improvements. If you are comfortable in programming for .Net platform: SQL, C# or even VB.Net eConnect is what you need to invest your time into, instead of trying to get experienced in Dexterity3. Direct SQL scripting and .Net programming. Of course you can use direct SQL views and stored procedures and call them via ADO.Net technology. We recommend you first to try eConnect approach, and if direct SQL call is easier and there is no risk to violate GP business logic, then go ahead and call SQL script directly especially in reading information from master tables: customer or vendor master for example4. GP Integrations and integrating tool selection. Again here we say that you can use multiple tools, when you are considering integration, please review GP Integration Manager module first, as it is now rewritten in eConnect and it boosts IM performance
Great,Plains,Development,Dexte