10X ERP Dedicated Database Architecture

The Security of On-Premise, The Innovation of SaaS

Most cloud ERP systems store all customer data in one shared database, relying on software logic to keep your data separate from competitors. 10X ERP takes a different approach: every client gets their own dedicated PostgreSQL database while benefiting from a shared, continuously updated platform. This gives you the security and isolation of on-premise systems with the convenience and innovation of modern SaaS, without the trade-offs of either.


We may be the only modern, distribution-focused cloud ERP with this architecture. While some legacy systems offer hosted options and a few enterprise ERPs provide single-tenant configurations, no other distribution ERP delivers this combination of dedicated isolation and continuous innovation.

How It Works

Single Codebase, Dedicated Databases

Our architecture separates data storage from application logic. Every client gets their own dedicated PostgreSQL database while running the same proven codebase. This means your data is completely isolated while you benefit from continuous platform improvements.

  • Your own dedicated database — never shared with other customers
  • Automatic updates every two weeks — always on the latest version
  • Same schema across all clients — thoroughly tested migrations

Why It Matters

Security & Compliance

Database-level isolation provides stronger security guarantees than software-based separation. Your dedicated database provides:

  • Physical separation from all other clients
  • Independent backups and point-in-time recovery
  • Database-level encryption
  • Isolated audit trails

For compliance audits:

  • HIPAA: Your PHI stays in your database only
  • SOX/GDPR/ITAR: Clear data boundaries
  • Simple answer: "Physically separate database" vs. shared database: "Application filtering with tenant IDs"

Performance

When databases are shared across customers, one tenant's activity can impact everyone else. Shared database problems include:

  • Other customers' activities slow your system
  • Peak hour conflicts across tenants
  • One maintenance window affects everyone

With 10X ERP:

10X ERP is designed to give every client reliable, consistent performance.

  • Dedicated databases and processes – Each client runs on its own database and application processes, providing strong isolation for both data and performance.
  • Optimized resources – Our infrastructure allocates dedicated CPU, memory, and I/O at the instance level, minimizing the impact of noisy neighbors.
  • Optional Dedicated Server – For clients who want complete isolation, we offer the option to run on a fully dedicated server, ensuring all resources are reserved exclusively for your instance.

Automatic Updates

Our release process keeps every client current while prioritizing stability:

  • New features every two weeks – Regular, predictable improvements to help your team move faster.
  • Same-day security patches – Critical fixes are applied immediately, so your system stays protected.
  • No version management – You never have to schedule or manage upgrades yourself.
  • Always on the latest version – All clients run the current release without delay.
  • Staggered releases for stability – Updates are rolled out to select instances first, allowing us to validate performance before broad release. This minimizes the risk of critical issues and reduces support impact.

Data Ownership

Your dedicated database means you have complete access to your data without vendor restrictions, including:

  • PostgreSQL database exports
  • API access
  • Offsite backups to your location
  • No vendor lock-in

Backup schedule:

  • Incremental backups every 30 minutes
  • Full daily backups at midnight
  • Point-in-time recovery to the second
  • Custom schedules available

See Data Backup and Recovery for details.

How We Compare

Understanding different ERP deployment models helps clarify why dedicated databases matter.

Traditional SaaS

These platforms use a multi-tenant architecture where all customers share one database, separated by software logic.

Examples: QuickBooks Online, NetSuite, Acumatica, Infor CloudSuite Distribution, Microsoft Dynamics 365 Business Central

Trade-offs:

  • Data sits alongside competitors
  • Security breach affects everyone
  • Performance impacted by other customers
  • Complex compliance audits

On-Premise ERP (SAP, Oracle)

Traditional on-premise systems give you full control but require significant IT resources. You install and maintain everything.

Examples: SAP Business One, Oracle, Epicor Prophet 21 (on-premise option), DDI Inform, Distribution One ERP-ONE+, SYSPRO (on-premise option)

Trade-offs:

  • $50k-$200k/year IT overhead
  • Manual security patches
  • Expensive upgrades
  • Version divergence

Hosted ERP (Per-Client Versions)

Traditional on-premise systems give you full control but require significant IT resources. You install and maintain everything.

Examples: SYSPRO (hosted option), SAP Business One (cloud hosted), Epicor Prophet 21 (cloud option)

Trade-offs:

  • Locked to specific version
  • Delayed feature access
  • Scheduled upgrade projects

Key Benefits

Our architecture delivers advantages across security, performance, and operational efficiency.

You Get:

  • Security of on-premise (isolated database)
  • Innovation of SaaS (auto updates every 2 weeks)
  • Data ownership (full portability)
  • Compliance simplicity (clear boundaries)

You Avoid:

  • Version management
  • Upgrade downtime
  • Data commingling
  • Performance conflicts

Common Questions

What happens during updates?

Automatic deployment with zero downtime. New features appear every two weeks.

Can we get our data?

Yes. PostgreSQL dumps, CSV exports, API access, read-only credentials, and offsite backups to your location.

How is database isolation enforced?

  • Separate database instances
  • Unique credentials per database
  • Network isolation available
  • Database audit logs

Data residency support?

Yes. US, EU, Canada, and UK regions available.

Security Features

Our security approach combines database-level isolation with application-level controls. Full security details available at Security Documentation.

  • TLS encryption in transit
  • Two-factor authentication
  • Role-based access control
  • Real-time monitoring

Learn More

10X ERP: Enterprise security, SaaS simplicity.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us