Deployment on an external database (RDBMS)
This section describes the process of running PaperCut NG/MF on an external relational database, and describes why you would choose to do this. By default, PaperCut NG/MF uses an internal database product known as Apache Derby. This database engine was donated to Apache by IBM and was previously known as IBM Cloudscape.
The internal PaperCut NG/MF database is stable, scalable, self-maintaining, and provides very good performance. For this reason, most organizations do not need an external database system. However, you might consider running PaperCut NG/MF on an external RDBMSA Relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Most commercial RDBMS's use the Structured Query Language (SQL) to access the database, although SQL was invented after the development of the relational model and is not necessary for its use. if:
Your organization has existing database infrastructure and wants to consolidate all applications on the same database platform.
Your organization has an existing database maintenance and backup procedure and wants PaperCut NG/MF to take advantage of this.
People want to use 3rd party reporting and analysis tools (like Crystal Reports or Microsoft Access) to view and analyze the PaperCut NG/MF database.
Your organization is very large and requires the performance benefits of a dedicated RDBMS. This also allows the database to reside on a separate server to PaperCut NG/MF, which improves the system scalability.
PaperCut NG/MF supports the following external databases out-of-the-box:
Microsoft SQLStructured Query Language (SQL) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). Server 2008 R2/2012/2014/2016/2017 or later (64-bit)
Microsoft SQL Server Express 2008 R2/2012/2014/2016/2017 or later
PostgreSQL 7.1+ (a free open source database)
MySQL 5.5+ (a free open source database)
Oracle 9.2+ (including the free Oracle Express Edition).
These databases were chosen to cater for the majority of customers.
For more information on supported databases, see the External Database Support Policy.