Deployment on an external database (RDBMS)
This section describes the process of running PaperCut NG on an external relational database, and describes why you would choose to do this. By default, PaperCut NG 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 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 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 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 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, which improves the system scalability.
PaperCut NG 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 2000/2005/2008/2012/2014 (either 32 or 64-bit)
Microsoft SQL Express 2005/2008/2012/2014 (free from Microsoft)
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.
Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.