Microsoft Great Plains integrations scenarios with legacy systems, EDI, software customizations and modifications upgrade
We would like to describe several popular scenarios from technical standpoint, their performance and feasibility, including following support and upgrade
• Microsoft Dexterity integration. You may have these custom integrations, written in Great Plains Dexterity to read tab delimited text files or ODBC data. Nowadays, Microsoft Dynamics GP Integration Manager should do most of the job.
• Integration Manager. This tool is user-friendly and intuitive. Historically IM had drawback – it was using Microsoft Great Plains OLE server, validating business logic via hidden forms – the drawback was moderate performance. However IM is on the way of being rewritten with eConnect, next subject.
• eConnect – initially it was intended as a tool for eCommerce developer to use GP as accounting back server. eConnect breaks through the limitations and complexity of pure Dexterity development and through its several interfaces (including XML Web Services) opens up GP objects to .Net developer. eConnect is realized for core and most popular modules, however in some cases you may find that it is not realized for the module you intended for your integration (Invoicing, for example). eConnect is very efficient and has excellent performance
• SQL Stored Procedures. This scripting is very powerful and at the same time requires good understanding of data distribution (and some understanding of Microsoft Dexterity architecture). The first advice would be – create intended transaction through GP interface and carefully analyze where data goes and then imitate your integration scripts. SQL Stored Procs give you the best performance, so if your integration processes high volume of transactions – you may end up to use SQL scripts
Alba Spectrum Group 1-866-528-0577, 1-630-861-5918, help@albaspectrum.com
Andrew Karasev is technical consultant at Alba Spectrum Group Texas ( http://www.albaspectrum.com http://www.enterlogix.com.br ) – we are serving Houston and Dallas with suburbs: Katy, Richmond, Galveston; downstate Texas: Austin, Corpus Christi, San Antonio. USA Nationwide and International integration clients, welcome, we serve you from our customer support call center in Houston, TX |
ไม่มีความคิดเห็น:
แสดงความคิดเห็น