Data onboarding generally means bringing in data from some outside source into some specific system.
When we talk about customer data onboarding, we’re talking specifically about taking data from your customers and loading it into your system or platform where you can work with it and return something of value to those customers.
The most common scenario we see is a SaaS platform needing to onboard data to get a new customer up and running – and there’s usually also a need for some ongoing data ingestion too, so the customer is seeing their up to date data in the platform.
"The onboarding process is our first chance at making a good impression with our customers after the dollars are already spent"
- Bryan Kahlig, Senior Director Product Development, Zywave
How you handle data onboarding gives a critical first impression of you as a vendor. And this can happen even before you’ve signed your customer. As part of your pitch you want to be able to give reassuring and positive answers when prospects are asking questions about your onboarding process such as:
And once you’ve signed the deal, you want to make sure that good impression carries on.
Of course the onboarding process may be iterative, requiring adjustments or re-mapping, but the crucial thing is that this should be as transparent to the client as possible. A lack of transparency, unexpected delays or lots of errors can leave your new customers asking themselves ‘did we make the right decision?’
The speed and efficiency of the onboarding process is also valuable to you as the ‘onboard-er’. If your engineering team is having to do a lot of time-consuming, manual work to onboard each new client, that not only costs you money, but also means you may not be able to keep up with the number of customers you need to onboard. These bottlenecks not only hinder your scalability but can also leave your new customers frustrated with the time it takes to get them live.
The #1 challenge with onboarding data from multiple clients is that you’ve got no control over the format or quality you receive the data in. In an ideal world, you want to be able to take whatever they have easily and get it into your system.
"When I go in and I speak to a prospective customer, I don't ever worry about data. I did before. The question was always ‘Where's your data? What does it look like? What format is it? How much are we talking?’
So what we were doing before was we were kind of going in with handcuffs. And what CloverDX really allowed us to do is go in and say ‘It doesn't matter how you're giving us this stuff, we're just going to stitch it all together.’"
Other data onboarding challenges include:
The solution to all these problems is to automate the process. Building an automated customer data onboarding pipeline enables you to:
Your automated pipeline not only needs to handle the entire end-to-end process, but it also needs to account for the variations in format, quality and frequency of data delivery that come from different customers.
How Formula 3 Group were able to onboard more customers and grow their business without increasing headcountIf we break down the individual steps we want a data onboarding pipeline to handle, they’re generally common to every job:
These stages apply to any type of data integration job – data migrations, system integrations, data warehousing, as well as data onboarding.
Specifically for customer data onboarding, those broad stages can be broken down into specific steps that we want our automated framework to handle automatically:
The steps of a data onboarding pipeline
The second part of this post looks at how you can automate this customer data onboarding process in CloverDX.
The CloverDX Data Management Platform is designed to build and operate data pipelines. It enables you to design pipelines in a visual editor, but also to code whenever you need, so you’re not constrained and can build a completely custom onboarding framework for your specific needs.
CloverDX can connect to any type of data, ingest it, shape it, cleanse it and write it to any target. And automation means onboarding jobs can run automatically and unattended, with monitoring and error alerting to notify you of any issues.
The video on the next post shows you the step by step process of how this works, and walks through how you can build a single pipeline to work with many different clients, by using configuration files to drive the whole process. (What does that mean? Mainly it means you don’t have to build a new pipeline for every new client, or for every change you need, and it means that this configuration – which can just be a human-readable Excel file – can be managed by less technical people).