Skip to content
+1-888-319-3663

EONE BLOG

Integration: The Danger of Coding Custom Integrations


“Everyone thinks that they can code their way to success here (with integrations), when in fact it typically means that your ongoing maintenance costs, and also the cost of inefficiencies, are off the charts. In this day and age, unless there are specific and unique needs, custom coding your data integration solution is never a good idea.” This was a quote from David Linthicum in a blog back in 2009.

In 2016, if you walk into your IT department and state “we need to integrate sales orders from our web app to our ERP” you will almost always get a response that involves “we can write some code for that”.  It is not only IT departments but there are still many IT consultants and ERP/CRM implementers that will jump to custom coding as a first solution.  Why? The main reason is that developers love to write code – it’s their job. The second reason is the developer gets total control with custom code – there is an essence of control freak in most developers. I understand this from the dev perspective, it is easier for the them, they are able do whatever they want in code without limitations. Just because something is easier for the development team does not mean it is a good solution for the business.

Many small and large businesses have turned to custom coding to churn out an integration quickly with the flexibility of tailoring that integration. For businesses with a limited scope of integration requirements, custom integration is often perceived as the fast and most logical path. As that business grows and their integration needs become more complex, you end up with a complex spaghetti architecture that leads to a reduced agility, flexibility and scalability.

It sometimes seem surprising to a business, but developers sometimes quit their jobs. Shortly after, the business may develop more or different integration needs. Inevitably the documentation around a certain integration is lacking and everyone is too scared to touch it. The business carries on for a long time with an old process that should be changed or improved to maintain efficiency but it is too important to mess with. Calling in a new developer is like starting from scratch all over again. 

In 2016, the need for a structured, non-code based integration plan has never been stronger. In the SMB market especially there is a strong move back to selecting ‘best of breed’ software solutions that do not talk to each other natively. Fewer companies are choosing large, expensive, all-encompassing businesses management solutions but rather are staying agile with the ability to choose and switch to new applications as they are released. This leaves IT teams with some awesome software that is just what the business needs, but each solution does not talk nicely to all the other software selections. This is just another reason why mid-market businesses need an integration solution to manage this process.

API’s are the big thing. API’s are simply fantastic – if you employ a developer.  If you do not employ a developer then API’s are a complete waste of time.  To call an API you have to be able to code.  Integration solutions such as SmartConnect mean you never have to code.

So what is the downside of writing all this custom integration code?

  1. The integration is hidden and secret.
  2. Overall cost of maintaining the integrations.
  3. Ability to trouble shoot integrations is limited.
  4. Ease of managing integrations on an ongoing basis.
  5. Changing or expanding the integration requires a developer.
  6. Changes to the underlying API’s require a developer.
  7. In 2016 there are so many integration points that you need a tool to manage them.
  8. Most developers would rather do exciting work and not write integrations.


If these are the negatives above, what are the benefits of deploying integration solutions such as eOne’s SmartConnect?

  1. These tools are developed by integration experts who live and breathe integration – not just the IT guy.
  2. Integration solutions are fully featured with robust error handling, data lookups, and workflow messages.
  3. Solutions are never one off. They will connect many software applications as your needs change.
  4. It becomes easy to call in an expert to help as everything is exposed and open.
  5. The business can manage integrations, without calling the developer.
  6. Reduced cost of ongoing ownership.


To summarize, you can always go down the integration development route and build good integrations. The problem is that over time things change and often get very expensive. 

Integration tools like SmartConnect keep the costs down and the flexibility high. The business can grow and change, it can choose best of breed software and know that it is all relatively easily interconnected.

Leave a Comment





RECENT POSTS


Accessing Historical Dynamics GP Data in NetSuite: Using Popdock
Popdock's Top 10 New Features
New Webinar: Getting Started with Matrix Reporting in Popdock
Tech Tuesday: Popdock User Security in D365 Business Central
Popdock Data Lake Upload Tool for Dynamics NAV Data - FREE TRAINING

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.