Welcome to ecoprintQ

Already a Partner?

You may log in to our resource center using your username and partner password.

Not a Partner Yet?

Please enter your information to "Apply" and complete the Form to submit your application.

Login

Partner Application




Welcome to ecoprintQ

Already a Client?

You may log in to our resource center using your username and client password.

Not a Client Yet?

Please contact us for more information.

Login

PaperCut Features:

3rd Party Database Support

Why use an external RDBMS?

The internal PaperCut database is stable, scalable, self-maintaining and provides very good performance. For this reason most organizations do not need to run PaperCut on an external database system. However there are some good reasons to run PaperCut on an external RDBMS, including:

Supported database servers:

Database Schema Diagrams

PaperCut NG and PaperCut MF share a common database schema. Organizations running PaperCut on an external database system such as Microsoft SQL Server, PostgreSQL, MySQL or Oracle may find the following schema diagrams useful when designing custom SQL queries and reports. If you need assistance or advice writing an SQL query please contact support.

By default PaperCut stores its data in an internal database format that is not accessible for external reporting. To access the database for reporting, PaperCut must be running on an external database. Instructions for moving to an external database can be found in the manual here: http://www.papercut.com/products/ng/manual/ch-ext-db.html

Where possible we strongly recommend read-only data access. Any modifications should be done either via the PaperCut interface, or via the XML-Web Services API. Direct database manipulation outside PaperCut 'may' lead to data inconsistencies - for example, transactions logs not matching account balances.

PaperCut Database Schema Revision-22 (PDF) Updated: 24th Apr 2010
PaperCut Database Schema Revision-27 (PDF) Updated 13th Sept. 2011 - Version: 11.4 (Build 14550)

Database administrators or query developers may also find the SQL database creation scripts useful. These present the schema in standard SQL create statements. The scripts are located in sub directories of: [app-dir]/server/lib/sql

If you have any questions about the DB Schema, or data access in general, please contact our support team.