Welke 17 punten zijn belangrijk, bij keuze koppeling Microsoft Dynamics NAV en Magento?

by Erica Hoekerd.

Image Graphic Word Cloud with Data Integration wording

Het aantal bedrijven dat claimt een werkende koppeling te hebben om Magento met Microsoft Dynamics NAV te koppelen groeit zeer snel. Dat is niet voor niets: Magento is wereldwijd het meeste gebruikte e-commerce platform en Microsoft Dynamics NAV wordt ingezet door 100.000 bedrijven als ERP systeem.

Wij zien het aantal klanten toenemen die initieel levenacier ‘X’ hebben geselecteerd voor de koppeling en uiteindelijk toch voor Tinx-IT kiezen om de daadwerkelijke integratie op te zetten. De initiële leverancier is niet in staat gebleken om de verwachtingen voor de integratie waar te maken. Dit brengt een aantal serieuze nadelen met zich mee voor zowel de klant als voor ons:

  • Kosten nemen toe en worden onbeheersbaar
  • De live-datum wordt vaak niet gehaald, project loopt vertraging op
  • Klant verwachtingen moeten worden bijgesteld
  • Minder vertrouwen in een betrouwbare en stabiele koppeling tussen Magento en Microscoft Dynamics NAV (Navision).

In this whitepaper, we would like to offer you a number of points to consider when selecting the right integration solution and, importantly, which company can support you the most during that selection.
The integration between both systems should never be an afterthought of an e-commerce project; it should be the starting point to integrate Microsoft Dynamics NAV with Magento especially since the integration forms the most important part of your online sales channels.

This checklist can also be used for Magento integrations with ERP systems other than Dynamics NAV, such as SAP, AFAS, Exact, and Dynamics AX.


Checklist integrating ERP – Magento:
1. Beschikbaarheid van werkende demo
Can the vendor show a functioning product, can a demo be requested that demonstrates that it meets the needs of your specific business case? It often occurs that a customized integration is built in during a project that subsequently is sold as a standard solution that should work out-of-the-box. If no demo can be provided, then that often indicates that a one-time customized solution has been used.

2. Standaard vs. maatwerk
Does the vendor have a standard solution, or is this being developed as a customized solution specifically for your company? Customized solutions are often riskier because only the supplier developing it understands it (vendor locking), and a dependency on them is created. It can also cause problems during upgrades of your systems. The more customized the solution, the more complex an upgrade of the latest version of the software will be.

3. Specialistische kennis
Is the vendor a specialist in this area and do they have a thorough knowledge of both Magento and Microsoft Dynamics NAV? Knowledge of both systems is necessary to set up a successful integration of both systems. The data model of both systems differs greatly.

4. Afgeronde implementaties
How many implementations has the integrator performed? What kind of customer cases were these? In order to determine how much integration experience the integrator really has, it is recommended that you request references and cases of implementations performed previously. The more implementations completed, the more the integrator can meet the customer’s requirements.

5. Wijzigingen naar Magento
How many changes should be made to Magento that affect core files in order to make the integration work?

6. Type of solution: middleware or extension
Type of solution. Is a middleware solution being used? This is a solution that has been installed as independent software between NAV and Magento. This can also be provided through the cloud. Does the solution contact the suppliers’ servers first, or is software being used that has been installed completely separate on the customer’s servers without intervention by the supplier? A supplier connection creates a dependency because if your supplier’s system is not working, neither will the connection.

7. Source code beveiliging
Has the source code been encrypted upon delivery? This can be a problem if changes to the source code need to be made afterward. Can changes to the configuration be made through a user interface or is the entire integration only possible through programming?

8. Flexibiliteit oplossing
Is the solution flexible, meaning that potential customization on the NAV database or add-ons are part of the integration without having to rebuild the integration solution? Or are all necessary integration points hard coded?

9. Horizontale of verticale oplossing?
What is the solution’s reach? Is it horizontal or vertical? A vertical solution means that the solution is made and geared toward 1 specific industry, for example fashion or retail. A horizontal solution means that the solution has been set up generically so that the target group is unlimited.

10. Compatibiliteit met Microsoft Dynamics NAV versies
Does the connector work with a number of NAV versions? If you are using an older version of Dynamics NAV system, is it still compatible with the connector? An example is version 5.0. Or is it necessary to upgrade to the latest version of NAV and maybe even a change to the database platform is necessary: from a native database to an SQL database.

11. Welke Magento versies
Does the connector work with multiple versions of Magento? Check your current Magento installation’s compatibility with the connector of your choice. Does it also follow forthcoming versions if you want to upgrade? Another important question relevant to this subject, is Magento 2.0 supported?

12. Soort connectie
Is this a database / ODBC connection so that portals have to be opened, or does the connection take place through the exchange of XML messages via web services? The initial connection can create security issues since ….. directly on the database. De eerste koppeling kan security issues oplveren, omdat er rechtsreeks op de database wordt

13. Logging en monitoring
Is the integration completely automated and is everything that happens between these systems being completely logged? Will e-mail notification be used in case the integration between both systems stagnates? Logging and monitoring helps during error analysis and facilitates solving potential problems and disruptions.

14. Implementing changes after going live
Is it easy to make changes after implementation or do you need to consult a specialist? For example: it could occur that you need to save certain data in Magento in the NAV sales order. Should a programming change be made that allows the necessary data to be saved, or are you able to integrate data in Magento easily with fields in Dynamics NAV?

15. Gebruikers interface
Is it visible within the application how the linking of fields between Magento and Dynamics is set up? Was a clear user interface provided during the integration? Or is it not visible at all how data between the two systems is exchanged? If no insight is available in how fields are mapped, then the integration is a kind of black box, which means implementing changes is impossible without a programmer.

16. Product Informatie Management
Can all information be managed in 1 location within the ERP system, or should changes also be made in Magento to improve the product catalogue?

17. Total Cost of Ownership
Total Cost of Ownership. (TCO) How much maintenance does the connector need after implementation? Or does it work completely automatic and independently?