Great Plains ERP Custom Programming and Add-ons Development

By: Andrew Karasev

Microsoft Dynamics GP has variety of modification tools: Dexterity, eConnect, SDK for Visual Studio Developer, then SQL stored procedures should be considers as advanced scripting option. In this small article we would like to give you introduction level highlights, assuming that you are in the MRP selection phase and your implementation requires customization, integration, programming, data conversion, cross-platform reporting

1.Great Plains Dexterity. This tool requires several years of extensive programming experience, and at the same time it allows you as software programmer to customize the most advanced scenarios of GP business logic. Dexterity is written in C programming language as EDI shell, in turn it has its own programming language sanscript. You typically rescue to Dex, when other tolls or SDK don't do the job

2.eConnect. It is in essence SDK with C# and VB sample codes, plus it has layers of technologies ending up at the database side with SQL encrypted stored procedures. eConnect was introduced as the tool for ecommerce web developer to integrate GP as back office accounting and Sales Order Processing system

3.SQL Scripting. If you need relatively simple data integration without deploying expensive tools, consider SQL Insert statement based scripts and stored procedures. Alternatively you can incorporate these constructions into DTS or Data Transformation Services package. Please, be sure that you are familiar with GP tables structure and data flow, please install GP SDK from CD #2

4.Cross Platform Integrations. If your legacy system database is not Microsoft SQL Server - something like Oracle, DBII, Progress, Sybase, Pervasive SQL, Ctree, you should consider making ODBC connection from MS SQL Server as preferred first option, as GP is MS SQL Server application

Enterprise Information Systems
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 

» More on Enterprise Information Systems
 



Share this article :
Click to see more related articles