Great Plains Customization Overview: Dexterity, Econnect, Sql Stored Procedures
Microsoft Dynamics GP ERP platform is ready for software developers for modifications, integrations, reporting, data export and other custom development projects. However, if you carry generic programmers in IT department, you need to know the options and how add-on development project should be structured: especially where your domestic programming workforce should be extended by professional Great Plains Dexterity developers. Let's review the tools:
1. Microsoft Dexterity, former name was Great Plains Dexterity. This is the shell, written in C programming language, specially designed to be the core of Great Plains Dynamics architecture in early 1990th. Dexterity has its own programming language Sanscript, plus Dexterity programmer should be familiar with Dynamics GP tables structure, forms and windows architecture - this knowledge allows Dex developer to extend existing Dynamics GP business logic with custom rules and exceptions. Dexterity allows you to alter Great Plains user workstation interface seamlessly, plus it work within Great Plains security realm. Obvious drawback is the fact, that you cannot cook new GP Dexterity developer over night or have somebody to write Dexterity code in one month. The recommended approach is to subcontract Dexterity programming part to GP Dex technical consultants, ISV or Great Plains VAR
2. eConnect. This is Software Development Kit, initially created for Dynamics GP ecommerce programmers to enable ecommerce web site project integration: natural example is ecommerce shopping cart integration to Great Plains Sales Order or Invoice. eConnect is open technology and you are welcome to begin inhouse eConnect programmer if you internal C#, VB or SQL programmers. eConnect turned into feasible option since Great Plains Dynamics GP version 9.0. If you are deciding on eConnect programming, we recommend you to upgrade your Great Plains MRP to version 10.0
3. Direct SQL scripting. This is good option if you are extracting GP data with select statement. In this case there is no way to occasionally cause Great Plains data integrity compromise. Good example would be Crystal Reports with SQL stored procedure or view as the report base. Another typical case is EDI export from Great Plains. If you are trying to push data to Great Plains or update existing objects, consider Great Plains Integration Manager or as safer programming approach - eConnect
Related Tags: dynamics gp
Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com 1-866-528-0577, http://www.albaspectrum.com Serving GP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Central America
Your Article Search Directory : Find in ArticlesRecent articles in this category:
- Improper Way Of Marketing Reflects Poorly On A Company.
New business, product or service everything requires visibility, awareness in order to come into the - Replacing Paper Prints With Online Versions
Nowadays saving out on resources and being additionally informative are both aspects that are in. In - Stop Smoking Effectively
If I told you of a way that you could stop smoking harmful tobacco would you believe it? Most people - What Is Runtime Error 182? And How To Fix It
Are you finding an effective way to fix runtime error 182? Do you think fixing runtime error 182 is - Do You Know How To Fix Runtime Error 87 In Minutes?
Are you finding an effective way to fix runtime error 87? Do you think fixing runtime error 87 is to - Knowledge About Avi, Avi Player, Avi Converter On Mac
Knowledge about AVI, AVI player, AVI Converter on MacWhat is an AVI?AVI, an acronym for Audio Video - Buy Your Highly Successful Email Survey Software Today
Email Survey Software- Boost Your Business and Increase ProfitsAn email survey software could be one - Xrm - The Anything Relationship Management Solution
I recently attended the Microsoft Dynamics West Region FY11 Sales Planning Retreat. This year's meet - What Are The Benefits Of Working With Electronic Medical Records
Recording medical information is a vital part of health care services. These records are necessary f - Basic Factor To Make Website Business Oriented
Internet is home for millions of websites. The online business is becoming more and more competitive
Most viewed articles in this category:
- Parental Control Software
Parental control software is software that can help parents protect their children when they are onl - Digital Asset Management Software
Managing and organizing your organization's documents is a critical component to your business's suc - AdobeRGB vs. sRGB
Understanding color spaces I'll try to explain it very simplified, but understandable for everyone - Confessions of a Prankster
I wanted to get a jump on April Fool's Day, partially because of the long, cold winter blues, and pa - Malicious Thoughts About The Spyware Ills Of My PC
Who would think I was capable of such revengeful thoughts about the parties responsible for inflicti - Recover File and Recover Deleted File Tools
Data recovery software is a very effective way of retrieving data from a worn or damaged hard disk d - Life without Windows
Ubuntu, a user-friendly version of Linux, has been running so nicely on my home PC that I decided to - What Benefit Does an Online Software Download Site Offer You?
Are you having a problem that where you find a good softeware when you consider to have a try or wan - Maintaining A Website
There was an era when people were talking about how to create a website using html coding or some ea - Benefits Of Proper Time Tracking
Have you ever written down time when you have started and finished your work? Maybe you have had mul