Microsoft Nice Plains or present ERP identify is Dynamics GP has varied modification instruments and SDKs. Your diligence responsibility is to evaluate them on the highest stage to grasp which instrument will do one of the best job within the particular case. Let’s start reviewing instruments briefly one after the other, being form of a bit technical, so it ought to be focused to IT individuals, programmers and DBA:
1. GP Integration Supervisor. IM has lengthy evolution from pure OLE server to extra fashionable and superior applied sciences and connectors. For GP model 10.zero you’ve got wealthy assortment of eConnect integrations. eConnect in flip is the set of encrypted SQL saved procedures, that are working a manner sooner than conventional connectors (OLE Server, utilizing GP workstation varieties and fields to validate integrating enterprise logic).
2. Textual content and CSV recordsdata integrations. It looks like Textual content and CSV integration drivers have been form of launched in beta testing part in 2003 and 2004, so if you’re utilizing Superior ODBC integration with union SQL constructions – you could obtain unusual error messages about saving integration format for textual content tab or comma delimited recordsdata. There’s work round, nonetheless outdoors of the scope of this text, name as for help
three. eConnect. As you already know from prepared the subject above, IM deploys eConnect connectors, nonetheless you may program eConnect strategies immediately in MS Visible Studio immediately, being C# or VB developer. That is particularly useful if you’re coping with eCommerce integration, sending information to GP ERP backoffice
four. eConnect limitations. This good instrument works on the extent of grasp data: buyer, GL account, vendor, worker, mission, contract, and many others. and work transactions: SOP bill, POP receipt, GL transaction to provide you few samples. Nevertheless eConnect does not put up batches or transactions (with single exception – it posts Financial institution Reconciliation paperwork, nonetheless it’s not an enormous assist for e-commerce integration). If you really want automated posting of GP batches from e-commerce web site software, it is best to take into account deploying Alba Spectrum posting server
5. SQL information feeding. That is whenever you create and deploy SQL saved procedures or insert statements. For those who plan one thing like that, you need to be actually acquainted with GP information distribution on the desk stage – please evaluate GP SDK, which could possibly be put in from Dynamics GP CD #2
6. Nice Plains Dexterity. If the case when your integration ought to handle customized tables and logic, created in flip by previous builders in GP Dex, please seek the advice of with Dex programmers or GP ISV companion to grasp your choices