By Henning Lund - June 30, 2020
When businesses contact me about a data integration project, there’s one question they tend to ask me before anything else:
Is it best to get someone to develop a custom integration for me, or can I get my needs met with an off-the-shelf integration platform? What are the benefits of data integration platforms vs custom integrations?
Businesses naturally want to minimize costs while making sure they have an effective customization. Budgets will always be an issue, but getting it right is vital too. No business wants to end up with an expensive piece of software that doesn’t do what they need it to.
With every business we work with, we spend time really getting to know their needs and figuring out together how we can best meet them. The answer is usually to recommend our data integration platform, RapidiOnline.
Surprised? It perhaps seems obvious that a custom system will be the better choice for most, but data integration platforms offer flexibility and functionality that’s hard to beat. Especially when you want to do Salesforce integration or Microsoft Dynamics integration.
It can be difficult to answer this question. Sometimes, when we do our initial evaluation, we’ll see that while a custom development might cost more to set up, it it’s likely to be cheaper to maintain over time.
Note the ‘likely’. The difficulty is that we can’t be sure what the maintenance costs will be as the business develops. Things change all the time as businesses grow, and that could mean that much more maintenance is needed than first appears.
There is also the fact that custom development often only includes a small amount of, or sometimes no, additional functionality for scheduling, error handling or monitoring. These things will be included at no extra cost in an integration platform. Adding them to a custom platform after setup can be a substantial extra cost.
While our own analysis tends to find that it’s cheaper for most businesses to use a platform, data integration platforms still have a reputation as being the expensive option. This is undeserved.
This reputation probably comes from the early days of data integration. The tools we used (known as ETL or extract, transform and load), were expensive, despite offering only limited functionality. This meant that custom integrations were both cheaper and more effective most of the time.
Now, things have moved on, and the tools we use include development, operational processing and integration functionality. There are are many affordable data integration options available now, for businesses small and large.
Data integration platforms have made it far easier for businesses to develop a simple, effective data integration no matter what the data sources are. They are fast, user-friendly and robust, often much more than custom integrations are. Anyone who’s ever developed and maintained a custom integration will know how difficult it can be to get those three things right consistently.
In their early days, data integration platforms could be tricky to implement. Now, a Salesforce Dynamics ERP integration can be up and running in just three to 10 days using cloud-based data integration tools such as RapidiOnline.
We’ve established that data integration platforms are generally cheaper than custom builds, but what about their other benefits? Don’t assume that a data integration platform will be one-size-fits-all but they have proven data integration capabilities. Platforms are usually highly flexible.
Being data-driven has become a strategic direction for many businesses. They have to think about data management and transformation, data processing without compromising on data quality. Data integration platforms help companies that wants to integrate systems together, for example their salesforce CRM and their Microsoft Dynamics 365 ERP. While providing a solution to their data integration needs, data integration platforms have to maintain high performance of the systems.
Our own data integration platform, RapidiOnline, comes with pre-configured endpoints to integrate Salesforce with Microsoft Dynamics AX, NAV and GP. This means that you can:
Data integration platforms are hands-down the better approach for the vast majority of businesses. There will always be some businesses that need a custom-build, but a data integration platform is customizable enough that it can work as well or better for the majority.
Want to know more? We’ve put together this data integration handbook (below) to help you learn everything you need to know.
Read also: 7 steps to successful Salesforce-ERP integration
Read also: How easy is it to integrate Salesforce with your ERP?
Read also: Top challenges of ERP-CRM integration projects
Read also: 10 cases: successful ERP-CRM integration