2018.2

Database considerations (ODBC)
Note
On 64-bit operating systems, the ODBC Data Sources created by the Data Source
(ODBC) icon in the Administrative Tools will not appear here, as PReS Suite is 32-bit
and cannot access the 64-bit data sources. In order to create an ODBC connection visible
by PReS, you will need to access the 32-bit version of the ODBC manager, available in
C:\Windows\SysWOW64\odbcad32.exe .
The following considerations should be kept in mind while working with ODBC Databases in
PReS Suite.
l
All databases
l
User Rights: During normal operation, Read/Write to tables should be sufficient.
However, during the initial setup, the Create/Drop tables rights is necessary.
l Minimum 100MB of database size is required as a minimum, but the space
requirement depends on the implementation. The more active documents in the
database, the more space is used - note that this progression is rather linear.
l Regular database maintenance is required, such as database compacting, is
required by a system administrator.
l It is recommended to create an IT process that backs up the database regularly.
l The recommended ideal setup is a dedicated SQL Server PC, accessed by PReS
Workflow through an ODBC connection on the local network.
l
Microsoft Access
l Database file (mdb) must be local to the PReS Workflow computer. It cannot be
located on a network drive or another server.
l Total database size is limited to 4GB of data.
l Total size of a single table is 2GB.
l May be unstable in large implementations.
l
MySQL
l Database can be in any location, but performance will depend on the speed of the
connection between PReS and the MySQL server.
Page 710