Open Source CRM & ERP 2026 Complete Guide — Odoo 18, Frappe ERPNext, SuiteCRM, EspoCRM, Vtiger, Mautic, CiviCRM, Twenty HQ Deep Dive

Prologue — Why open source ERP/CRM is back in focus in 2026

"What ERP does your company use?" — back in 2020, the typical answer was "SAP", "Oracle", or "Microsoft Dynamics". In 2026, the same question now invites "Odoo", "ERPNext", and "Twenty" into the mix. Whether you install on your own server or use a managed service like Frappe Cloud or Odoo.sh, open source ERP/CRM is no longer "the risky choice".

Why has it come back into focus? Three reasons.

First, SaaS price inflation has crossed a threshold. Salesforce Sales Cloud Enterprise is around 165 USD per seat per month in 2026, and SAP S/4HANA and Oracle NetSuite start at the 100k USD per year unit. From an SMB perspective, "if we're going to pay this forever, we might as well self-host" becomes a rational choice.

Second, AI has entered CRM/ERP. Twenty HQ was designed AI-first from the start, and Odoo 18 has strengthened its enterprise AI features. As an alternative to proprietary AI like Salesforce Einstein and HubSpot Breeze AI, the combination of open source self-host plus a self-hosted LLM has grown.

Third, data sovereignty and regulatory burdens have grown. EU AI Act, Korean PIPA, and tightened Japanese APPI have reinforced the demand of "we want our data on our servers". Self-host open source ERP/CRM is the answer.

This piece compares 18+ open source tools on a single page, covers the tradeoffs vs proprietary SaaS, the Korean/Japanese local context, and migration, integration, and reporting.

---

Chapter 1 — Distinguishing CRM vs ERP vs MA

Let's start with terminology. CRM, ERP, and MA (Marketing Automation) are often confused, but they cover different domains.

Of course, the boundary is fuzzy. Odoo includes a CRM module, HubSpot does CRM and MA simultaneously, and ERPNext is an all-in-one platform with CRM features.

Selection guide:

• Only customer management needed → CRM alone (EspoCRM, Twenty HQ, SuiteCRM)
• Up to accounting and inventory → ERP (Odoo, ERPNext, Tryton)
• Marketing email automation → MA (Mautic, or HubSpot Free)
• All integrated → ERP suite (Odoo, ERPNext, Microsoft Dynamics 365 Business Central)

In the open source camp, ERP suites tend to absorb CRM and MA features. Odoo and ERPNext are examples.

---

Chapter 2 — Odoo 18 / 19, the peak of modular ERP

Odoo is Belgium-based (founded in 2005), and in 2026, Odoo 18 is the stable release and Odoo 19 is in the release cycle. The license is dual: Odoo Community Edition is LGPLv3, and Odoo Enterprise Edition is proprietary.

Core characteristics:

• 40+ modules — CRM, Sales, Inventory, Manufacturing, HR, Accounting, eCommerce, POS, Subscription, Project, Helpdesk, and more
• Python 3 + PostgreSQL + JavaScript (OWL framework, since Odoo 16)
• Community Edition is free self-host
• Enterprise Edition is per-module pricing plus per-seat pricing (roughly 25-50 USD per seat per month)
• Odoo.sh managed hosting (Enterprise only)

Odoo Community Edition vs Enterprise:

Strengths:

• The broadest module coverage
• Modern UX (significantly improved after OWL framework adoption)
• Active marketplace (Odoo Apps) — 30,000+ modules
• Studio for no-code customization
• Strong multi-language support (Korean and Japanese included)

Weaknesses:

• Confusion from Community vs Enterprise separation
• Some modules only work properly in Enterprise
• Migration is hard (major version upgrades)
• Korean and Japanese tax compliance relies on third-party modules

---

Chapter 3 — Frappe plus ERPNext 15, the strongest Python ERP alternative

ERPNext is an open source ERP made by India-based Frappe Technologies, GPLv3 licensed. The backend framework Frappe is MIT licensed. As of 2026, ERPNext 15 is the stable release.

Stack:

• Frappe Framework (Python 3 plus JavaScript) — full-stack web framework
• MariaDB / PostgreSQL
• Redis (cache plus queue)
• Nginx plus Gunicorn

Core modules:

• Accounting (double-entry, multi-language and multi-currency)
• Stock and Manufacturing (BOM, MRP, batch tracking)
• CRM (lead, opportunity, quotation)
• HR (employee, payroll, attendance)
• Project Management
• Asset Management
• Healthcare, Education, Agriculture (domain-specific additional modules)

Frappe Cloud — official managed hosting. Starts at 10-25 USD per site per month. Multi-site, automatic backups, automatic upgrades.

Frappe HR — HR module separated from ERPNext. Payroll, attendance, leave, expense.

Comparison vs Odoo:

ERPNext is often described as "real open source ERP without lock-in". A good fit for SMBs wanting to avoid Odoo's Enterprise edition lock-in.

---

Chapter 4 — SuiteCRM, the free-camp fork of SugarCRM

SuiteCRM is an open source CRM that UK-based SalesAgility forked from SugarCRM Community Edition in 2013. License is AGPLv3. As of 2026, SuiteCRM 8.x is the main version.

History: When SugarCRM effectively deprecated the Community Edition in 2014, SalesAgility took the GPL code and forked it as SuiteCRM. It has since evolved independently.

Core features:

• Account, Contact, Lead, Opportunity (traditional CRM data model)
• Email integration (IMAP plus SMTP)
• Workflow automation
• Reporting plus dashboard
• Activity stream
• Module Builder (no-code custom module creation)

Stack:

• PHP (Symfony framework, in SuiteCRM 8)
• MySQL / MariaDB
• Apache / Nginx

Strengths:

• Free (AGPL)
• Very rich features (legacy SugarCRM heritage)
• Strong migration tools (attractive to existing SugarCRM users)
• Active community

Weaknesses:

• UI feels somewhat dated (SuiteCRM 8 is improving this)
• PHP and MySQL operational burden
• AGPL is restrictive for SaaS commercialization

Representative users: UK/European SMBs, NGOs, government agencies.

---

Chapter 5 — EspoCRM, a lightweight and modern open source CRM

EspoCRM is US-based (started in 2014) and is a lightweight open source CRM with LGPL license. As of 2026, EspoCRM 8.x is the main version.

Core characteristics:

• PHP plus MySQL plus vanilla JS (frontend is Backbone.js)
• LGPLv3 license (commercial SaaS is also possible)
• Quick installation (under 5 minutes)
• Lightweight (low server resource usage)

Features:

• Account, Contact, Lead, Opportunity
• Email integration, calendar
• Workflow, BPM (Business Process Management)
• Reports, dashboard
• VoIP integration (Twilio, Asterisk)
• Customer Portal
• Knowledge Base
• Mobile apps (iOS, Android)

EspoCRM Cloud — official SaaS hosting. Starts at 17 USD per seat per month.

Comparison vs SuiteCRM:

EspoCRM is appealing for "people who find SuiteCRM heavy". The code is clean and LGPL also offers freedom for commercialization.

---

Chapter 6 — Vtiger CRM, the canonical Open Core

Vtiger CRM is India-based, having started in 2004 from a fork of early SugarCRM code. License is MPLv2 (Mozilla Public License). As of 2026, Vtiger 7.x is the community version.

Structure:

• Vtiger CRM Open Source (community) — MPL 2.0, free
• Vtiger CRM Cloud — SaaS, 12-40 USD per seat per month

Features:

• Sales CRM (deal, quote, contact)
• Help Desk (tickets)
• Marketing (email campaigns)
• Project Management
• Inventory plus Invoicing
• Workflow automation
• Phone integration (PBX, click-to-call)

Strengths:

• All-in-one approach (CRM plus Helpdesk plus Project)
• Relatively affordable pricing
• Multi-language support (Korean and Japanese included)

Weaknesses:

• Open Source version is more limited than Cloud version (classic open core)
• UI feels somewhat dated
• Community is smaller than SuiteCRM or EspoCRM

Vtiger is a good fit for SMBs who like the "traditional SugarCRM lineage" but want something lighter than SuiteCRM.

---

Chapter 7 — Mautic, the open source marketing automation

Mautic is an open source marketing automation platform that started in 2014. It was acquired by Acquia (the Drupal company) in 2019 but continues open development under GPL license. As of 2026, Mautic 5.x is the main version.

Core features:

• Email campaigns (drip, triggered)
• Landing page builder
• Forms plus landing forms
• Lead scoring plus segmentation
• Workflow automation (drag-and-drop)
• A/B testing
• Multi-channel (email, SMS, push)

Stack:

• PHP 8 plus Symfony
• MySQL / MariaDB
• External SMTP or Amazon SES, SendGrid, Mailgun integration

Comparison vs HubSpot and Klaviyo:

Mautic is chosen by teams who feel "HubSpot is expensive" or "Klaviyo is too eCommerce-centric" for self-host. However, you carry the burden of managing your own email sending infrastructure (deliverability).

---

Chapter 8 — CiviCRM, the non-profit and NGO CRM

CiviCRM is an open source CRM that started in 2004, specialized for the non-profit, NGO, political party, and association domains. License is AGPLv3. As of 2026, CiviCRM 5.x.

Why non-profit specialized:

• Member, donor, volunteer data model (not sales lead)
• Donation tracking (recurring, one-time, anonymous donations)
• Event management (campaign and fundraising events)
• Membership management (member tiers, renewal)
• Pledges
• Grant management
• Case management (social services cases)

Stack:

• PHP plus MySQL
• Installed as plugin for WordPress, Drupal, Joomla, Backdrop
• Or standalone (CiviCRM Standalone, since 5.79)

Representative users:

• Amnesty International
• Wikimedia Foundation
• Creative Commons
• Many political parties (UK/US progressive)
• University alumni associations

Strengths:

• Deepest non-profit domain functionality
• 24 years of history, proven stability
• Active contributor pool

Weaknesses:

• Unsuitable for general sales CRM use (don't confuse them)
• Conservative UI
• Depends on WordPress or Drupal (Standalone is relatively recent)

For NGOs, political parties, and charities, CiviCRM is nearly the first candidate.

---

Chapter 9 — Twenty HQ, the 2026 newcomer in modern open source CRM

Twenty HQ is a modern open source CRM that started in 2023. Y Combinator (W23) graduate, AGPLv3 license. As of 2026, with 25k+ GitHub stars, it is the fastest-growing open source CRM.

Vision: "An open source Salesforce alternative with Notion/Airtable-level UX"

Stack:

• TypeScript plus React plus NestJS
• PostgreSQL plus Redis
• Docker/Kubernetes deployment

Features (as of 2026):

• Contact, Company, Opportunity, Note, Task
• Custom objects (Notion/Airtable style)
• Kanban, table, calendar views
• Email sync (Gmail, IMAP)
• AI assistant (chat with CRM data)
• Workflow automation (beta)
• REST plus GraphQL API
• Self-host (Docker, Kubernetes) or Twenty Cloud (starts at 15 USD per seat per month)

Strengths:

• Modern stack (TypeScript, React, NestJS, GraphQL)
• Fast UI (SPA, optimistic updates)
• AI-first design
• Active development (weekly releases)
• Clean codebase (no legacy burden)

Weaknesses:

• Young (still lacking enterprise features)
• Workflow and reporting features still weak
• Korean and Japanese localization is incomplete

vs Salesforce and HubSpot: Twenty aims at the Salesforce alternative market with "AGPL plus modern stack". Still lacking enterprise features, but adoption is rapid in SMBs and startups.

---

Chapter 10 — NocoDB, Baserow, Appsmith, the low-code adjuncts

There's also the flow of "building CRM/ERP yourself" with spreadsheet, Airtable, and Notion-like tools.

NocoDB (AGPL):

• A GUI that lets you treat MySQL or PostgreSQL like Airtable
• Automatic API generation
• Easy self-host via Docker

Baserow (MIT/AGPL dual):

• Similar concept, Python plus Django plus Vue
• self-host free, Cloud from 5 USD per month

Appsmith (Apache 2.0):

• Internal tool builder
• 100+ datasource connections (PostgreSQL, Mongo, Salesforce, Twilio, etc.)
• Drag-and-drop admin app building

When to use: SMBs for whom a full CRM is overkill, or cases where you only build "reporting and approval workflows" on top of an ERP. Hybrid stacks with Twenty HQ or Odoo have become more common.

---

Chapter 11 — Crater, Invoice Ninja, Akaunting, Tryton, the accounting and invoice space

When you don't need a full ERP, only accounting or invoicing.

Crater (AGPL):

• Specialized in invoices, quotes, estimates
• Laravel plus Vue
• Mobile app available
• Popular among small freelancers and agencies

Invoice Ninja (Elastic License 2.0):

• Invoice, quote, invoice-plus-pay integrated
• self-host or SaaS
• Stripe, PayPal, Square payment integrations
• Strong automation

Akaunting (GPLv3):

• Full accounting (double-entry)
• Multi-currency and multi-language
• App marketplace (Akaunting App Store)
• self-host or SaaS, both options

Tryton (GPLv3):

• Python ERP (a cousin of Odoo — Odoo branched from OpenERP, then Tryton forked separately)
• Very modular, clean architecture
• Accounting, inventory, manufacturing
• Smaller global user base, but code quality is highly regarded

Which tool to use depends on scale and requirements. Freelancers go for Crater or Invoice Ninja, SMBs for Akaunting, and if you want a real ERP, Tryton, ERPNext, or Odoo.

---

Chapter 12 — OFBiz and Compiere, the Apache and old camp

Apache OFBiz (Apache 2.0):

• ERP from the Apache Software Foundation
• Java plus Groovy plus Freemarker
• Very modular, very heavy
• Some large company usage (Walmart, 1-800-Flowers, etc.)
• Steepest learning curve

Compiere:

• One of the most famous open source ERPs in the early 2000s
• Acquired by Consona in 2010, effectively deprecated
• Its fork ADempiere keeps the lineage alive (Apache camp)
• As of 2026, new adoption is not recommended (historical interest)

iDempiere: A fork of ADempiere, more actively maintained. Centered in the EU and Latin America.

This category is not suitable as a new choice except for "already operating" places. For new starts, Odoo or ERPNext is the answer.

---

Chapter 13 — Proprietary comparison set: Salesforce, HubSpot, Pipedrive, Zoho, Dynamics

To understand the open source camp, you have to know the proprietary camp.

Salesforce Sales Cloud (1999 onwards):

• The absolute king of the CRM market
• 2026 pricing: Enterprise 165 USD per seat per month, Unlimited 330 USD
• Einstein AI built-in
• Massive AppExchange ecosystem

HubSpot CRM (2014 onwards):

• Freemium model (CRM free, marketing/sales/service hubs paid)
• 2026 pricing: Starter 50 USD per month, Professional 1,170 USD, Enterprise 3,600 USD
• Breeze AI (announced 2024)

Pipedrive:

• Specialized in sales pipeline, SMB-friendly
• 15-100 USD per seat per month

Zoho CRM:

• CRM from India's Zoho
• Very affordable pricing (from 14 USD per seat per month)
• Zoho One bundle (45 apps) — 37 USD per seat per month

Microsoft Dynamics 365 Sales:

• Integrated with Microsoft 365, Teams, Azure
• 65-135 USD per seat per month
• Linked to Power Platform

Twenty HQ vs Salesforce: Twenty targets the answer to "Salesforce is too expensive". AGPL allows self-host too. However, enterprise features at the Sales Cloud level are still lacking.

---

Chapter 14 — Enterprise SaaS: SAP, NetSuite, Workday, Microsoft Dynamics

The large-enterprise ERP/HR market is still dominated by proprietary.

SAP S/4HANA:

• Released in 2015, S/4HANA Cloud (SaaS) plus S/4HANA Private Cloud plus on-prem
• SAP ECC support ending in 2027 (major migration cycle)
• Pricing is non-public, typically starting at 100k USD per year
• Most extensive modules

Oracle NetSuite:

• The original cloud ERP (started in 1998)
• 2026 pricing: base 99-129 USD per seat per month plus modules
• Acquired by Oracle in 2016
• Popular from SMB to mid-market

Microsoft Dynamics 365 Business Central:

• SMB/mid-market ERP
• Integrated with Microsoft 365
• 70-100 USD per seat per month
• Good Korean and Japanese localization

Workday:

• HR and Finance enterprise SaaS
• Pricing non-public, typically 300-500 USD per employee per year
• Strong in HR (HCM) market, Finance also growing fast

Infor:

• Industry-specific ERP (manufacturing, distribution, healthcare)
• Transitioning to CloudSuite

vs open source: Large enterprises (1B USD or more revenue) still default to SAP, Oracle, Workday, while SMB and mid-market is contested by Odoo, ERPNext, and Microsoft Dynamics Business Central. The middle (50M-500M USD) has the widest range of choices.

---

Chapter 15 — Korean ERP/CRM: Duzon, Younglimwon, Wisetech

The Korean market has strong local ERP and tax solutions. If you only look at global ERP, you miss the big picture.

Duzon Bizon:

• The absolute king of Korean ERP, tax, and HR market
• "iCUBE" — SMB ERP
• "Duzon Smart A" — accounting and tax (the standard for accounting firms)
• "WEHAGO" — cloud integration platform
• Overwhelmingly strong in Korean tax and electronic tax invoice integration
• 2025 revenue about 600 billion KRW

Younglimwon SoftLab:

• "K-System" — mid-sized enterprise ERP
• Strong in manufacturing and distribution
• Korean tax and labor integrated

Wisetech:

• "WiseHR" — HR solution
• "WiseAccounting" — accounting
• SMB accounting and tax

Infomedia — accounting and tax SaaS, targeting accounting firms.

Korean local CRM:

• Channel Talk — customer support plus messenger plus light CRM (covered in support post)
• Kakao Biz / KakaoTalk AlimTalk — marketing and notification message channel
• Daangn (Karrot) member management — for local businesses
• Tossblade — fintech integrated CRM (B2B sales)
• NHN Toast Talk — BizTalk, eCommerce integrated

Why global ERP doesn't work well in Korea: Korea has very detailed regulations like tax invoices, NTS Hometax API, and labor standards. Odoo and ERPNext community lack Korean tax modules, and third-party modules vary in quality. So Korean SMBs use Duzon, mid-market uses SAP B1 or Microsoft Dynamics in general.

---

Chapter 16 — Japanese ERP/CRM: OBC Bugyo, Yayoi, freee, Money Forward, Sansan

Japan has a strong local ERP and accounting market, similar to Korea.

OBC Bugyo (Obic Business Consultants):

• The standard in Japanese SMB accounting, payroll, and sales
• Kanjo Bugyo (accounting), Kyuyo Bugyo (payroll), Sho Bugyo (sales), Jinji Bugyo (HR)
• Both package and SaaS

PCA:

• Japanese accounting and payroll software with 30 plus years of history
• PCA Kaikei, PCA Kyuyo
• The most conservative choice for SMBs

Yayoi Kaikei:

• Started in 1978, widest reach across SMB and self-employed
• Yayoi Kaikei (accounting), Yayoi Kyuyo (payroll), Yayoi Hanbai (sales)
• Owned by KKR

freee:

• Started in 2012, cloud-first
• freee Kaikei, freee Jinji Roumu
• Popular with SMBs and startups
• IPO on Tokyo Stock Exchange in 2019

Money Forward:

• Household budget plus business accounting
• Money Forward Cloud Kaikei, Kyuyo, Kintai
• Two-horse race with freee

SAP Business One / Oracle JD Edwards: Still strong in Japanese mid-market.

Japanese CRM:

• Sansan — business card based CRM, Japan's #1 sales CRM (Sansan plus Eight)
• e-Sales Manager — SoftBrain sales management
• Knowledge Suite — SaaS integrated CRM
• kintone — Cybozu's no-code platform (CRM/workflow versatile)
• Senses (Magic Moment) — modern sales CRM

Japanese market characteristics: "Cloud-ification" is progressing rapidly, but Yayoi/PCA packaged accounting is still the SMB standard. freee and Money Forward are rapidly transitioning customers to cloud. Global open source ERP has low adoption in Japan — Japanese tax, legal, and business practices differ significantly.

---

Chapter 17 — Use case mapping: which company should pick what

Instead of abstract comparison, mapped to concrete scenarios.

SMB SaaS company (20 employees):

• Operations: Odoo Community (or Enterprise) — accounting, HR, project
• Sales CRM: EspoCRM or Twenty HQ
• Marketing: Mautic (self-host) or HubSpot Starter
• Budget: 200-500 USD per month (hosting included)

E-commerce (Shopify, 1M USD revenue):

• ERP: Odoo (strong Shopify/Stripe integrations)
• CRM/Email: Klaviyo (Shopify #1)
• Marketing automation: Klaviyo or Customer.io
• Budget: 500-2,000 USD per month

Non-profit / NGO (5,000 members):

• CRM: CiviCRM (member/donor/event data model)
• Accounting: Akaunting or ERPNext
• Email: Mautic
• Budget: Nearly free (self-host)

Manufacturing (100 employees, 30M USD revenue):

• ERP: ERPNext or Odoo Enterprise (Manufacturing module)
• Or SAP B1, Oracle NetSuite
• CRM: Odoo Sales or SuiteCRM
• Budget: 2,000-10,000 USD per month

Mid-market B2B (500 employees):

• ERP: Microsoft Dynamics 365 Business Central or Oracle NetSuite
• CRM: Salesforce Sales Cloud or HubSpot Enterprise
• HR: Workday or BambooHR
• Budget: 100k-500k USD per year

Korean SMB (manufacturing, 50 employees):

• Tax/accounting: Duzon Smart A or iCUBE
• ERP: Younglimwon K-System or Microsoft Dynamics Business Central
• CRM: self-built or Channel Talk plus Salesforce

Japanese SMB (services, 30 employees):

• Accounting/payroll: freee or Money Forward Cloud
• CRM: Sansan plus Salesforce or kintone
• ERP: PCA or Odoo (limited)

---

Chapter 18 — AI in CRM/ERP 2026: how far have we come

The biggest change in 2026 is that AI has fully entered CRM/ERP.

Salesforce Einstein:

• Einstein Copilot (2024), Einstein GPT
• Account/deal summarization, email drafting, prediction
• Integrated with Data Cloud (CDP)

HubSpot Breeze AI (2024):

• Breeze Copilot, Breeze Agents
• Content generation, lead scoring
• Integrated with Marketing Hub (covered in marketing post)

Odoo AI (Enterprise):

• Invoice OCR (Invoice Digitization)
• Recommendations (next best action)
• Chatbot (Odoo Discuss)

Twenty HQ AI:

• Chat with CRM data
• Auto-enrich contacts
• Email summarization

Microsoft Copilot for Dynamics 365:

• Sales Copilot, Service Copilot
• Integrated with Microsoft 365 and Teams

Open source plus self-hosted LLM: Cases of attaching Ollama or OpenAI API to SuiteCRM, EspoCRM, ERPNext to build self-AI features have increased. The advantage of self-host open source shines here.

AI in ERP:

• Demand forecasting
• Inventory optimization
• Anomaly detection (anomaly transactions)
• Invoice auto-matching

AI is an assistive tool for CRM/ERP, not a replacement. The fundamentals of data model and workflow remain the same in 2026.

---

Chapter 19 — Self-host vs SaaS: real cost calculation

"Self-host is free" is only half true. Let's calculate the actual cost.

Self-host ERP/CRM cost (monthly, 20 employees scale):

vs SaaS (HubSpot Professional 20 seat):

• About 1,170 USD per month (base) plus per seat additions
• Backups, security, upgrades automatic

vs SaaS (Odoo Enterprise 20 seat, 5 modules):

• Module fees plus seat fees = about 1,500-2,500 USD per month

Self-host wins when:

• Data sovereignty matters (healthcare, finance, government)
• Heavy customization needed (core code modifications)
• Long-term (5 plus years) operation — cumulative cost gap widens
• Has in-house DevOps personnel

SaaS wins when:

• Need to start fast
• DevOps personnel lacking
• Standard workflows are enough
• Headcount changes frequently

Most SMBs find SaaS is the answer, and self-host is seriously considered above 50 employees.

---

Chapter 20 — Migration patterns: Salesforce to Twenty, SuiteCRM to EspoCRM

Switching ERP/CRM hinges on data migration. Some common patterns.

Salesforce to Twenty HQ:

• Extract CSV with Salesforce Data Loader (Account, Contact, Lead, Opportunity)
• Load into Twenty's import API
• Map custom objects to Twenty custom objects
• Manually rebuild workflows
• Typically 2-4 weeks (depends on data volume)

SugarCRM to SuiteCRM:

• SuiteCRM is forked from SugarCRM, so data models are compatible
• Migration tools provided by SalesAgility
• Typically 1-2 weeks

SuiteCRM to EspoCRM:

• Both PHP/MySQL but different schemas
• Use EspoCRM's import wizard
• Redefine custom modules via EspoCRM's Entity Manager

HubSpot to Twenty / Odoo:

• HubSpot has relatively free CSV export
• The hardest part is workflows plus email campaign history
• Email campaigns are usually not migrated (start fresh)

Odoo Community to Enterprise:

• Same codebase, so migration is relatively easy
• Use the database as-is, only change the license
• However, install Enterprise modules and restart

ERPNext 14 to 15:

• Major version upgrades are automated via bench update command
• However, custom apps need compatibility checks

General principles:

• Master data (account/contact) is the easiest
• Transactions (deals/invoices) are typically migrated with a cutoff and start fresh in the new system
• Emails, memos, attachments have lower priority (nice to have)
• ERP takes 6-12 months, CRM is typically 2-4 weeks

---

Chapter 21 — API, webhook, Zapier, n8n: integration patterns

ERP/CRM are not standalone systems. They connect to Slack, email, payments, and electronic tax invoices.

Salesforce API:

• REST, SOAP, Bulk API
• Triggers written in Apex (proprietary language)
• Salesforce Connect (external data)

HubSpot API:

• REST API, OAuth 2.0
• Webhooks
• Operations Hub (workflow plus data sync)

Odoo API:

• XML-RPC, JSON-RPC
• REST API via third-party module
• Python direct call also possible

ERPNext API:

• REST API (provided by Frappe Framework)
• Webhooks
• Python script direct call

Twenty HQ API:

• REST plus GraphQL
• Very clean API design (modern)
• Webhook support

Connection tools:

• Zapier: The standard of SaaS integration (covered in automation post)
• Make.com (Integromat): Zapier alternative, more powerful transforms
• n8n (Fair-code license): Workflow tool that can be self-hosted (covered in n8n post)
• Pipedream: Developer-friendly integration

Korean and Japanese integration considerations:

• Korea: NTS Hometax electronic tax invoice API (smart-bill, popbill third-party middleware)
• Japan: NTA e-Tax API, Invoice system (from 2023) compliance needed
• For both, global ERPs depend on third-party modules

---

Chapter 22 — Reporting: Metabase, Superset, Redash, Grafana

ERP/CRM data is ultimately consumed as "reports and dashboards". Summary of open source reporting tools.

Metabase (AGPL):

• The easiest BI tool
• Even non-technical users can create charts with natural language questions
• SQL editor built-in
• self-host free, Metabase Cloud SaaS

Apache Superset (Apache 2.0):

• Started at LinkedIn, graduated to Apache
• Very powerful charts and dashboards
• Powerful SQL Lab
• Strong for large-scale data

Redash (BSD):

• SQL-centric BI
• Collaboration (query sharing)
• Simple dashboards
• Acquired by Databricks (2020)

Grafana (AGPLv3):

• The standard for metric visualization
• More for infrastructure monitoring than ERP/CRM
• Can connect to RDB via Grafana SQL plugin
• Grafana Cloud SaaS

Lightdash (MIT):

• The new standard for dbt plus BI
• Growing fast

Sigma Computing / Mode / Looker: Cloud BI SaaS (not open source).

Selection guide:

• Quick start plus non-technical users → Metabase
• Large-scale data plus powerful charts → Superset
• SQL-centric plus collaboration → Redash
• Infrastructure plus data integration → Grafana
• Modern data stack based on dbt → Lightdash

The most common pattern is exporting ERP/CRM data to a PostgreSQL replica and connecting Metabase or Superset.

---

Chapter 23 — Security and compliance checklist

Self-host open source ERP/CRM means security is the user's responsibility. Items to check.

Basics:

• Enforce HTTPS (Let's Encrypt or commercial cert)
• Strong DB password, block root login
• SSH key auth, block password auth
• Firewall (UFW, AWS Security Group) — DB never exposed externally
• Regular security updates (OS, frameworks, ERP/CRM body)

Backups:

• DB daily backup, 30-day retention
• File attachments (S3 or separate storage)
• Recovery test (once per quarter)

Audit:

• Login logs
• Data change logs (audit trail)
• IP whitelist (admin interface)

Compliance:

• GDPR (EU) — data export/delete API
• Korean PIPA — personal data collection, use, third-party provision consent
• Japanese APPI — personal data handling, cross-border transfer restrictions
• HIPAA (medical) — US medical data
• SOC 2 — security, availability, confidentiality

Open source security advantages:

• Code can be audited (proprietary is a black box)
• Security patches can be applied directly (no vendor wait)

Open source security disadvantages:

• Disclosure of known vulnerabilities is fast (attackers see them too)
• Patch application is user's responsibility

---

Chapter 24 — Decision tree: 2026 5-minute guide

If you want to decide in 5 minutes.

Q1. Company size and revenue?

• 1-20 employees, under 5M USD revenue → CRM-centric, ERP only for accounting
• 20-100 employees → seriously consider ERP suite
• 100-1,000 employees → full ERP, consider large SaaS
• 1,000 plus → SAP/Oracle/Workday territory

Q2. Data sovereignty and customization priority?

• Very important → self-host open source (Odoo Community, ERPNext)
• Medium → SaaS plus multi-export options (HubSpot, Salesforce)
• Low → fastest SaaS (Pipedrive, Zoho)

Q3. Industry and domain?

• Non-profit/NGO → CiviCRM
• E-commerce → Odoo plus Klaviyo / Shopify
• Manufacturing → ERPNext, Odoo, SAP B1
• B2B SaaS → HubSpot, Twenty, Pipedrive
• Healthcare → ERPNext Healthcare, Epic, Cerner
• Education → ERPNext Education, Moodle

Q4. Regional priority?

• Korea-centric → Duzon, Younglimwon, Microsoft Dynamics
• Japan-centric → freee, Money Forward, OBC Bugyo
• Global → Odoo, ERPNext, Salesforce, HubSpot

Q5. Budget?

• Under 500 USD per month → self-host Odoo / ERPNext / Twenty
• 500-5,000 USD per month → HubSpot Pro, Odoo Enterprise SMB
• 5,000 plus USD per month → Salesforce, Microsoft Dynamics 365
• 100k plus USD per year → SAP, Oracle NetSuite, Workday

Q6. Who operates it?

• Has in-house DevOps → self-host possible
• Outsourced/consulting → SaaS plus partner
• Lacking both → SaaS only

---

Chapter 25 — 2026 outlook: where is open source ERP/CRM going

Trends for the next 2-3 years.

1. AI integration accelerates: Twenty HQ, Odoo, ERPNext are all strengthening AI features. Integration with self-hosted LLMs (Ollama, vLLM) will be standardized.

2. Modern stack adoption: The TypeScript/React/NestJS/GraphQL stack that Twenty HQ has demonstrated may become the new standard. ERPNext and Odoo are also progressing on frontend modernization.

3. Open Core model expansion: "Community plus Enterprise / Cloud" dual model will persist over pure open source. Odoo, EspoCRM, ERPNext (Frappe Cloud) are already on that path.

4. Vertical specialization: Industry-specific ERPs (manufacturing, healthcare, NPO) will grow. ERPNext domain modules, Odoo verticals.

5. Low-code integration: Integration between low-code tools like NocoDB, Baserow, Appsmith and ERP/CRM will become standardized. "Core is ERPNext, auxiliary workflows are Appsmith" will be common.

6. Salesforce and SAP response: Enterprises will still be SaaS-led, but differentiated by pricing competitiveness plus AI features. The open source camp's threat cannot be ignored.

---

Epilogue — 2026: "Is open source actually usable?"

The answer: yes, but with care.

Open source ERP/CRM is a serious alternative in 2026. Odoo and ERPNext compete with SAP and Oracle in SMB and mid-market. Twenty HQ targets the Salesforce alternative market with a modern stack. EspoCRM and SuiteCRM have evolved the legacy of the SugarCRM era, and CiviCRM is solid in the non-profit market.

However, self-host means cost, operations, and security responsibility falls to the user. "Free does not mean free". You must be able to handle 6-12 months of migration plus continuous maintenance.

Recommendations:

• SMB SaaS startup → Twenty HQ plus Odoo Community plus Mautic
• SMB manufacturing → ERPNext (or Odoo Enterprise) plus Duzon tax (Korea)
• Mid-market → Microsoft Dynamics 365 Business Central or Odoo Enterprise
• Enterprise → SAP, Oracle NetSuite, Workday (still)
• NGO → CiviCRM plus Akaunting plus Mautic

The question is not "should we use open source?" but "given my company's scale, industry, data sovereignty needs, and operational capacity, what fits?". Hope this piece is a starting point for finding that answer.

---

References

• Odoo Official Site
• Odoo GitHub
• Odoo Community vs Enterprise Comparison
• Frappe Framework
• ERPNext Official
• ERPNext GitHub
• Frappe Cloud
• SuiteCRM
• SuiteCRM GitHub
• EspoCRM
• EspoCRM GitHub
• Vtiger CRM
• Vtiger CRM Open Source
• Mautic
• Mautic GitHub
• CiviCRM
• Twenty HQ
• Twenty HQ GitHub
• NocoDB
• Baserow
• Appsmith
• Crater Invoice
• Invoice Ninja
• Akaunting
• Tryton ERP
• Apache OFBiz
• iDempiere
• Salesforce Sales Cloud
• HubSpot CRM
• Pipedrive
• Zoho CRM
• Microsoft Dynamics 365
• SAP S/4HANA
• Oracle NetSuite
• Workday
• Infor CloudSuite
• Duzon Bizon
• Younglimwon SoftLab
• Wisetech
• Channel Talk
• freee
• Money Forward
• Yayoi
• OBC Bugyo (Obic)
• Sansan
• kintone (Cybozu)
• Metabase
• Apache Superset
• Redash
• Grafana
• n8n
• Zapier