Do I need a CRM, an ERP, or both?

Under 20 employees and under a few million in revenue, you almost certainly want a CRM and almost certainly don't want an ERP. A CRM organizes your relationships with customers and prospects. An ERP is the operating system of a larger company — finance, HR, inventory, procurement, all connected. ERPs are heavy and expensive; most small businesses get better results stringing together purpose-built tools.

What does ETL really mean in practice?

ETL is the plumbing that moves data between your tools. Extract (pull it out of one place), Transform (clean and reshape it), Load (put it somewhere useful). Every time you download a CSV, reformat it, and paste it into another system, you are doing ETL by hand. A tool like Flowfile does it for you on a schedule.

Is a spreadsheet a CRM?

For your first 50 customers, yes, absolutely. A spreadsheet is a legitimate CRM up to the point where you start losing track of who said what when. Most founders know exactly when that moment arrives, and that's the right time to move to a real CRM — not before.

Where does BI fit in?

BI stands for Business Intelligence — the reports and dashboards you look at. A BI tool (Looker Studio, Metabase, Power BI) visualizes data once it's already in a clean shape. The ETL step comes before BI. BI without clean data shows you wrong pictures confidently.

What's the smallest useful stack for a small business?

For e-commerce: Shopify + Stripe + a free CRM (HubSpot Free or Pipedrive starter) + an email tool (Mailchimp free, Klaviyo) + a pipeline tool to connect them. For SaaS: your app + Stripe + a CRM + email + a pipeline tool. That's five tools, which is enough to run a real business and small enough to understand.

All articles

Small Business Beginner CRM ERP ETL Glossary

CRM, ERP, ETL: Which Three-Letter Acronyms a Small Business Actually Needs

Software vendors love three-letter acronyms. Here's a plain-English guide to which ones matter for a small business, which ones you can ignore, and what to buy when.

By Edward van Eechoud April 16, 2026 6 min read

TL;DR. If a salesperson has tried to sell you a “CRM”, an “ERP”, a “data warehouse”, and an “ETL platform” in the same quarter, you’re not alone. Most small businesses need one of those four, probably don’t need two of them, and already have the fourth whether they know it or not. Here’s what each one actually does, which ones matter at which size, and the plain-English order to buy them in.

Why the jargon gets in your way

Small business software is marketed mostly at enterprise buyers. That’s why your product demo sounded like alphabet soup — CRM, ERP, BI, ETL, MDM, CDP — and why the pricing jumped the moment you said your company size. The acronyms aren’t wrong. They describe real categories. But they were invented in an era when a medium-sized company had an IT department to tell these tools apart. You don’t, and the vendors know it.

The good news is that the categories themselves are simple once you strip the marketing off them. Here’s the short version.

CRM — Customer Relationship Management

What it does. A CRM is a database of people and what you’ve said to them. Contacts, conversations, deals in progress, tasks you owe back, emails sent. When a prospect replies two weeks after a call, a CRM is why you remember what the call was about.

When you need one. The moment a spreadsheet starts failing you. Symptoms: you forget to follow up with someone who asked for a quote, two teammates email the same lead the same pitch, or you can’t remember which customer asked for which feature. For most small teams this lands somewhere between 50 and 200 contacts.

What to consider. HubSpot Free, Pipedrive, Attio, Folk. All of them handle the job. HubSpot’s free tier covers most startups for their first two years.

What it is not. A CRM is not an email tool, a dashboard, or a source of truth for your revenue. It’s a memory aid for your sales process.

ERP — Enterprise Resource Planning

What it does. An ERP is one big system that tries to run all of your operations: accounting, inventory, purchasing, HR, payroll, sometimes manufacturing. The pitch is “one place for everything,” which is genuinely valuable in a business with 200 employees and 10 departments that all have to reconcile at quarter-end.

When you need one. When the cost of not having everything in one system starts exceeding the cost of an ERP project. In practice, that’s rarely below 50–100 employees, and more often in the hundreds. Under that size, an ERP is usually an expensive way to under-use software.

What to consider. NetSuite and SAP Business One at the bigger end, Odoo or Microsoft Dynamics 365 Business Central at the smaller end, Xero plus specialized add-ons in the middle. Implementation is almost never a weekend project.

What it is not. An ERP is not an upgrade path from your CRM. It’s a different category with a different job. Most small businesses get better results from five well-chosen tools connected by a pipeline than from one ERP pretending to do everything.

ETL — Extract, Transform, Load

What it does. ETL is the plumbing that moves data between your tools. Extract it from a source (Shopify, Stripe, your CRM). Transform it — clean it, reshape it, join it with something else. Load it somewhere useful — a report, a dashboard, another system.

You are already doing ETL. Every time you download a CSV from one tool, open it in Excel, rework the columns, and import it somewhere else, you have just completed a small ETL job by hand. The question isn’t whether you do ETL; it’s whether you automate it or keep doing it by hand.

When you need a tool for it. The moment the manual version starts costing you more than an hour a week, or the moment a mistake in the manual process costs more than a few dollars. That’s earlier than most founders think.

What to consider. For small businesses, Flowfile (visual, local, free), Fivetran or Stitch (cloud, managed, paid, aimed at larger setups), or Zapier / Make for row-by-row automation rather than batch jobs.

What it is not. ETL is not a dashboard. It’s the step that prepares data so the dashboard works.

The also-rans: BI, CDP, MDM, Data Warehouse

You will be pitched these. Here’s the short version.

BI — Business Intelligence. Dashboards and reports. Looker Studio (free), Metabase (open-source), Power BI, Tableau. You need this once you have data in a clean shape and several people want to look at it. Not before.
Data Warehouse. A purpose-built database for analytics — BigQuery, Snowflake, DuckDB. Relevant when your data outgrows spreadsheets but you still want to ask SQL-style questions. For most small businesses this is a “later” problem.
CDP — Customer Data Platform. A CRM for marketers. Think Segment, Rudderstack, Klaviyo’s data side. Useful if you do heavy personalized marketing across channels; skip it otherwise.
MDM — Master Data Management. A system to keep “the one true list” of customers, products, or suppliers across multiple tools. Enterprise-only in practice. Small businesses solve the same problem with a pipeline job once a week.

The honest buying order for a small business

Software vendors like to pitch these in parallel. A more useful order is sequential, by the problem each one solves:

Your core tool. Shopify, your Bubble app, your accounting package — whatever your business actually runs on.
Payments. Stripe, PayPal, or whatever charges the card.
Email and a light CRM. Mailchimp + a spreadsheet for the first 50 customers; HubSpot Free + your email tool once you pass that.
A pipeline tool. The moment any recurring manual routine crosses the 30-minute mark. This is where tools like Flowfile earn their keep.
BI / dashboards. Once clean data exists and more than one person needs to see it.
ERP. Only when you have genuinely outgrown a stitched-together stack, which is later than most salespeople suggest.

If you are a founder or owner reading this and wondering where to start, the answer is almost always “step 4.” Core tool, payments, and email you already have. ERP you don’t need yet. The pipeline step is the one most small businesses skip and then regret, because every hour spent merging spreadsheets by hand is an hour you spent doing software’s job.

Getting started with the pipeline step

Flowfile is free, open-source, runs on your laptop, and handles the ETL work for small businesses that don’t have an engineering team. The browser demo gives you a taste of the canvas without installing anything.

A good first project: pick the one recurring report where you currently merge files by hand. Build it as a pipeline. Run it again the following week. By the third run, the tool has saved more time than it took to install.

Related reading. Stop Copy-Pasting Between Spreadsheets shows the pipeline step in practice, and What Is a Data Pipeline? goes deeper on the concept.

Frequently asked questions

Do I need a CRM, an ERP, or both?: Under 20 employees and under a few million in revenue, you almost certainly want a CRM and almost certainly don't want an ERP. A CRM organizes your relationships with customers and prospects. An ERP is the operating system of a larger company — finance, HR, inventory, procurement, all connected. ERPs are heavy and expensive; most small businesses get better results stringing together purpose-built tools.
What does ETL really mean in practice?: ETL is the plumbing that moves data between your tools. Extract (pull it out of one place), Transform (clean and reshape it), Load (put it somewhere useful). Every time you download a CSV, reformat it, and paste it into another system, you are doing ETL by hand. A tool like Flowfile does it for you on a schedule.
Is a spreadsheet a CRM?: For your first 50 customers, yes, absolutely. A spreadsheet is a legitimate CRM up to the point where you start losing track of who said what when. Most founders know exactly when that moment arrives, and that's the right time to move to a real CRM — not before.
Where does BI fit in?: BI stands for Business Intelligence — the reports and dashboards you look at. A BI tool (Looker Studio, Metabase, Power BI) visualizes data once it's already in a clean shape. The ETL step comes before BI. BI without clean data shows you wrong pictures confidently.
What's the smallest useful stack for a small business?: For e-commerce: Shopify + Stripe + a free CRM (HubSpot Free or Pipedrive starter) + an email tool (Mailchimp free, Klaviyo) + a pipeline tool to connect them. For SaaS: your app + Stripe + a CRM + email + a pipeline tool. That's five tools, which is enough to run a real business and small enough to understand.