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 International Pty Ltd supports the following two external databases out-of-the-box:
Microsoft SQL Server 2000/2005/2008
Microsoft SQL Express 2005/2008 (free from Microsoft)
PostgreSQL 7.1+ (the free open source database).
Oracle 9.2+ (requires an optional support module. Please contact PaperCut Software International Pty Ltd for details).
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.
© Copyright 1999-2008. PaperCut Software International Pty Ltd. All rights reserved.