Table of Contents
This section describes the process of running PaperCut NG on an external relational database, and describes why an organization 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 to run PaperCut NG on an external database system. However there are some good reasons to run PaperCut NG on an external RDBMS, including:
Your organization has existing database infrastructure and would like to consolidate all applications on the same database platform.
Your organization has an existing database maintenance and backup procedure and would like PaperCut NG to take advantage of this.
People would like to use 3rd party reporting and analysis tools (like Crystal Reports) 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 Software Pty Ltd supports the following two external databases out-of-the-box:
Microsoft SQL Server 2000 (or later)
Microsoft SQL Express 2005 (free from Microsoft)
PostgreSQL 7.1+ (the free open source database).
These databases were chosen to cater for the majority of our customers. Most customers have existing SQL Server licenses so can take advantage of this support. PostgreSQL was chosen as the second alternative RDBMS because it is free, open-source and supported on all common platforms.
PaperCut NG also supports the following databases, but because they are less common with our customers, supporting these databases will incur an additional fee. Contact PaperCut Software Pty Ltd for details.
Oracle 8i, 9i, 10g
DB2 7.1, 7.2, 8.1
Sybase 12.5
MySQL 4.1+
SAP DB 7.3
Informix
Ingres
FrontBase
Mckoi SQL
Firebird 1.5+
© Copyright 1999-2006. PaperCut Software Pty Ltd. All rights reserved.