What is an External Database?
An external database is defined as any database other than the built-in Derby database that is packaged with PaperCut as standard.
How do I use an External Database with PaperCut?
If you’d like to run PaperCut from an external database, the setup procedure for this is covered here Manual - Chapter 18.
What External Databases are supported on PaperCut?
PaperCut supports Microsoft SQL Server (32 and 64-bit, and Server Express), Oracle, PostgreSQL and MySQL as standard. Please note that with SQL 2016, if you’re running PaperCut version 18 or earlier - you’ll need to install Microsoft’s driver to get things working correctly: (see here for the steps for SQL 2016). Version 19 of PaperCut includes the correct Microsoft SQL driver out-of-the-box.
PaperCut’s framework is designed to support many other database systems. The policy we’ve defined on external databases is as follows:
- PaperCut will support an internal database + two commercial + two open source as standard. (i.e. Microsoft SQL Server, Oracle, PostgreSQL and MySQL).
- We can support other database systems on request. This is covered with a one-off cost, combined with the initial standard license price.
- Once 5 or more customers have subscribed to a new database type, we’ll promote it to a “standard” database option and make available to all customers. (Oracle and MySQL are examples of this policy in action. Oracle was added as a standard option in April 2008, and MySQL was added as a standard option in 2009 after 5 customers subscribed to support for each of these databases.)
- We operate in 100% transparency. The number of customer implementations of each new database is outlined at the bottom of this page.
- ‘Support’ means both support between PaperCut and database vendor versions, and technical assistance where required.
If you have any questions regarding support for an alternate database, please Contact Us
Current status for other databases:
- Oracle: Complete. Now an official database option as of April 2008 after 5 implementations through 2006 and 2007.
- MySQL: Complete. Now an official database option as of April 2009 after 5 implementations through 2008 and 2009.
- IBM DB2: No implementations to date, only informal requests.
keywords: oracle, mysql, my sql, postgresql, database support, policy, rdms