| Microsoft Dynamics GP consulting field nowadays | | | | upgrade path is critical for you |
| typically requires high-end technology expertise and | | | | 2. Great Plains data massage, this is related to GP |
| hands-on experience. If you are implementing Microsoft | | | | data conversion. ERP data conversion is expected |
| Great Plains in large or mid-size company, you expect | | | | scenario, however this is typically something that is not |
| your new ERP application to be seamlessly integrated | | | | cheap and you should review all your possible options, |
| into your existing IT infrastructure: Microsoft Windows | | | | prior to diving into full-scale data migration |
| domain, probably elements of such non-Microsoft | | | | 3. Heterogeneous GP reporting. Microsoft SQL Server |
| systems as Linux Red Hut and PHP with MySQL (or | | | | allows you to deploy such constructions as SQL linked |
| another Linux brand), Oracle db integration, and things | | | | server, where you can query data (using |
| like these. Also take into consideration the needs to | | | | OPENROWSET command) from non-Microsoft |
| switch from unsuccessful implementations of | | | | platforms, such as Java, Oracle, Sybase or IBM DBII |
| concurring MRP products: Oracle EBusiness Suite, | | | | related |
| People Soft, PeachTree, Accpac, MAS 90 or 2000 - | | | | 4. eConnect. This tool or SDK was initially dedicated to |
| then the need of technical expertise in ERP data | | | | eCommerce developers and programmers, opening |
| conversion will be even more valuable. We'll try to | | | | for them Microsoft Dynamics GP objects realm for |
| keep reasonable balance in ERP consulting | | | | programming and e-commerce integration. eConnect |
| requirements expertise, reviewing it in this article | | | | should be moderate learning lesson for C# or VB.Net |
| 1. Great Plains Dexterity - is more likely the must. | | | | MS Visual Studio developer, as it is in its core set of |
| Historically in earlier 1990th Great Plains Software | | | | encrypted SQL Stored Procedures |
| Dynamics was designed on GP Dex platform. Dex is | | | | 5. SQL Scripting for GP integration. Of course this |
| in fact C-shell, meaning that C programming language | | | | approach is not "object-oriented" and it is not |
| was used in the developing of Dexterity Integrated | | | | recommended for somebody who considers himself |
| Development Environment. Of course, currently | | | | as GP novice. However, if you are scripting for Great |
| Microsoft is marketing and positioning GP on MS .Net | | | | Plains for over 5 years, you should recognize that |
| platform, so Dexterity is kind of legacy, comparing to | | | | direct SQL scripting is the most efficient way to gain |
| .Net. However here we have to play Dex apologetic | | | | integration performance |
| role - if your GP business logic was designed and | | | | 6. GP Reporting. |
| programmed in Dex, then Dexterity modification | | | | |