Dynamics GP ISV Partner Newsflash: Great Plains Custom Add-Ons Programming
Microsoft Dynamics GP customizations could be developed in various tools: Great Plains Dexterity, SQL Stored Procedures, eConnect, Extender, etc. Traditionally, add-ons were written in Great Plains Dexterity, this architecture allows you to package Dex custom module into so-called Chunk file, which should be copied into Dynamics GP directory and when you launch GP workstation next time, you will get prompt to integrate new functionality
This integration converts chunk file into new custom add-onsDictionary, registered in Dynamics.set file.This small publication is dedicated to IT manager level highlights onDexterity technology and where you should consider Dexterity programming workfor your organization:
1. Historicalexcurse on Great Plains Dexterity. Dexwas coded in C programming language as the shell with its own architecture and scriptinglanguage Sanscript plus with its own instruments to manage Database access:table creation, records addition, deletion, update. For DB access Dexterity deploys cursors andthis makes it a bit slower, comparing to direct aggregation in SQL language:Select, Insert, Update. Dex can, howevercall native Microsoft SQL Stored procedures, where you could dramaticallyimprove Dex performance, in fact Microsoft Business Solutions ported goodportion of former Dexterity cursors into SQL Stored Procs. Initially, introducing Dexterity Great PlainsSoftware planned to have it as secured shell to avoid single DB platformdependency, but when Microsoft acquired GPS, this caution was obviously disregarded,as Great Plains ERP became since then committed to Microsoft Windows and MS SQLServer Platform
2. WhereDex might be not the best customization tool?The answer is simple in integrations.If all you need to do is Dynamics GP integration in eCommerce, EDI,Barcoding, with Legacy Systems, Lotus Notes, Excel, ODBC data source (Oracle,MySQL/PHP, Pervasive SQL, Ctree, MS Access) these integrations do not needDexterity, you can rather deploy either eConnect programming in C#, VB.Net, oreven GP Integration Manager
3. WhereDex does its best job? In seamlesslyintegrated to Dynamics GP user interface custom screens, and especially whenyou need GP security real to be extended to these custom windows
4. Howto locate Dynamics GP ISV Partner.Typically, ISV should not be local by requirements or company IT policies. Microsoft Dynamics GP Dexterity SoftwareDevelopment Factory is not a simple thing to launch and afford to maintain fortypical local or even regional Great Plains Reseller
5. Feelfree to call us: 1-866-528-0577, help@albaspectrum.com,we specialize in Great Plains Customizations, Integrations, Reporting, EDI,eCommerce
Comments
Post a Comment