Work

Services

Blog

Resources

Integration Tips

9 MIN READ

How To Spot Ineffective Data Integration Solutions

We’d all like to make less mistakes. In this article, we’re taking our 30+ years of data integration experience and sharing some valuable lessons learned on how to spot ineffective data integration solutions before you make costly investments and long-term commitments that turn into never-ending headaches.

Fool me once, shame on me, fool me twice…

Wouldn’t it be nice to not be fooled at all?

Data integration is still a fairly young industry. With any maturing space, it gets harder to sort the worthy solutions from the bandwagoners and lesser solutions. The more popular an industry becomes, the more confusing it gets for those on the buying side of the table. And with data integration as an industry projected to be worth $24.95 billion USD by 2026, we could just be seeing the tip of an exploding technology industry. That being said, it is imperative for merchants to pick the best data integration solution that meets their business’ needs as well as works effectively.

Coupled with the growth arc many companies go through, it’s not surprising that by the time merchants reach VL by eHouse that they’ve already had a number of experiences with other data integration solutions or approaches. What persists is the number of mature merchants who are still going through a number of ineffective data integration solutions. Consequently, encumbering their growth and slowing their agility to respond to their own market changes.

While making mistakes is valuable to lessons learned, going through multiple applications in any vertical shows that there’s a bigger problem to solve.

What is it? Merchants are being sold on data integration approaches that they never should have been evaluating from the get-go because it was never going to work for them.

We’d all like to make less mistakes. In this article, we’re taking our 30+ years of data integration experience and sharing some valuable lessons learned on how to spot ineffective data integration solutions before you make costly investments and long-term commitments that turn into never-ending headaches.

We have identified four signs to help you spot ineffective data integration solutions. Read on to learn more!

SIGN #1:

It was built on old tech

Have you ever logged into a portal for an application and… cringed?

Data integration as an industry is evolving at an incredible pace. API-centric data integration has only been around for a decade or two (unlike EDI, which VL by eHouse also does, which has been around forever by comparison’s sake). As such, new programming methods, interfaces, and best practices are still being developed and launched. The technology powering your data integration platform behind the scenes is important, but you, as a user, will likely never get a peek under the hood of what’s powering the integration platforms you’re evaluating.

The interface you as a user interact with, though, can be telling. Data integration, again, is a young industry, so there’s no excuse except a lack of innovation and iteration for a data integration platform that looks like a non-ironic retro throwback. If the data integration platform is built on cutting-edge best practice technology, their user interface should reflect this investment in the applications’ own technology. If something feels off, it’s a sign to ask some hard questions about what’s powering the integrations. And then get your pen and paper ready.

Most data integration providers worth their salt are pretty open about their technical capabilities, especially when asked (be skeptical of those who don’t want to share).

Good Signs

Signs that the data integration platform/partner is built on best practice and driven by new developments include: 

  • Ability to work with GraphQL, REST- and SOAP-based APIs. GraphQL is potentially the most cutting edge of the three, with REST being preferable to SOAP-based APIs.
  • The ability to use webhooks, enabling the movement of data in real-time.
  • True serverless technology, meaning the platform is powered by microservices and enabling the integrator to run integrations in parallel and not just in a linear manner. True serverless integration uses microservices, full stop, and not just hosting their services via a third party like Azure, AWS, or Google Cloud.

Warning Signs

When it comes to indications that the integration platform is built on old technology, it gets a little more complicated.  In general, there are some criteria you can take into consideration.

Some warning signs the integration platform is built on less-than-stellar technology include:

  • Technology that was built around the turn of the century (2000) or earlier, like the Commerce One framework or ‘middleware’ (an old term for on-premise data integration technology). Old integration technology will reduce your business’ ability to be agile and ability to scale effectively to meet demands. You can expect issues like loss of data due to API throttling (maxing out servers and crashing them) and more.
  • A linear approach to integration, meaning data transfer is dependent on other conditions. Workflows are not run in parallel, so one error along the way takes the entire connection down.
  • No true process for error troubleshooting and reconciliation, other than maybe ‘we re-run the integration/connector’. Don’t be fooled — this is a manual process.
  • And as a bonus, the user-facing interface for an integration platform is also worth exploring from a security standpoint. In the age of leaks, hacks, EU-GDPR and more, data security is of the utmost importance to you and your end users.

If the data integration platform is built on cutting-edge best practice technology, their user interface should reflect this investment in the applications’ own technology.

SIGN #2:

It does everything!

(AKA, the ‘Universal’ integration platform)

While it might feel like we’re living in the future, we’re not quite there (yet).

What VL by eHouse does is technical, complex, and involves lots of specialty knowledge and experience. Without getting too technical, APIs — application program interfaces — aren’t all the same. Different APIs are built differently and can do (or can’t do) different things. Some applications have very limited APIs that aren’t well documented (making it hard for integrators like VL by eHouse to do what we need to do). On the other hand, some applications don’t have APIs at all and need different processes to extract data.

With all these variables, limitations, and conditions, how could a universal integration platform exist?

Simple: it doesn’t. 

Universal integration platforms don't exist.

SIGN #3:

They pass work off to you

Does a self-serve portal make you feel like you’re in control and saving money?

If you said ‘yes’, here are two follow-up questions:

  • Are you an expert in that technology?
  • Do you work for free?

If you answered ‘yes’ to both of those questions too, then you can skip this section! But if you answered ‘no’, then keep reading.

A self-serve data integration portal may feel like you’re gaining (or regaining) control of your company’s automated data movements. However, these platforms are typically designed for agencies managing small customers, or for mid-sized merchants. In most cases, merchants who have grown out of lesser plug-and-play integrations but aren’t yet ready to make the jump to a managed solution like VL by eHouse’s.

Self-serve portals are limited in their use because they have to be a) simple to use and b) serve the lowest common denominator merchant to gain the most ROI of the platform itself. They have to be simple to use, as the users aren’t programmers or developers, but rather laymen. Functionality will be reduced as a result, as will be the configuration of the integration to your business’ exact needs. These portals also need to have a decent market of users to support it, meaning if you’re looking for support or troubleshooting, you’ll likely be left waiting. Portals aren’t strong on customer support — they’re more like a factory churning out basic integrations. 

The fact of the matter is that your time costs money. Outsourcing a complex need like data integration to experts will ultimately save you time and money, because integration experts like VL by eHouse can do what we need to behind the scenes and configure all project needs much faster. Our managed service means we take care of the dirty work of setting up and any troubleshooting, and we’re customer service-forward. You get the VL Dashboard, but do not have to manage, field match, set business rules, or worry about changes — that’s all on us, leaving you to do what you do best: grow your ecommerce or multichannel business.

Self-serving portals aren't strong on customer support — they're more like a factory churning out basic integrations.

SIGN #5:

Does the Future Matter To Them? 

We started this article off by starting with old tech, and this final section brings the conversation full-circle. One final way to spot an ineffective integration solution is looking at the platform in a future-forward way. What features does the platform have now, and what’s on the roadmap for the future? The answer can be hugely illuminating.

Analytics is a great litmus test to try on any and all integration platforms you’re evaluating. Most applications regardless of their vertical have some sort of analytics plugged in; which is a best practice. With data integration platforms, the presence or absence of analytics as a part of their platform exposes their technology strategy. Those without analytics or with basic analytics only aren’t using a centralized database. This likely means they’re using a linear approach to integration (Point A to Point B only, and only in one direction), which causes interdependencies that can take an entire connection down with a single error or issue.

In contrast, rich analytics with explorable depth indicates a more sophisticated integration approach. This includes holistic analytics, channel-specific analytics, and analytics not available via other portals, channels, or trading partners. Rich analytics are only possible with an API-centric forward approach that includes a centralized database.

These bells and whistles aren’t just ‘nice to haves’, either. They’re often indicators of the future development and potential of the integration platform, too. An inability to meet today’s standards in any web portal indicates issues today that are only going to compound tomorrow. Following our example on analytics, no analytics means a lack of data to power said analytics, AKA no centralized database and likely not a heavy reliance on APIs within the integration platform’s own technology. 

Platforms using basic analytics or no analytics at all aren't using a central database — likely meaning they are using a linear approach that causes interdependencies that can take an entire connection down with a single error or issue.

Final Words

At the end of the day, the more experience you can collect on data integration, the more of an expert you’ll be on advocating for what your business really needs out of an integration solution. At VL by eHouse, we’re up-front and honest about advising merchants who come to us. Even if it means pointing them towards a different integrator. We’re in it to build businesses and help merchants, and not just to turn a quick dollar.

FREE RESOURCES

Browse Our Library of Resources

Check out tips and tricks for growing your business with our collection of eBooks and infosheets.

Let’s work together.

Have an idea? Bring it to our house; let's make it a reality.

Get a quote
Get a quote

Let’s talk.

Have an idea for a project? Fill out this form and we’ll get back to you shortly.