ImageMaster requires two datasources with database connections. These are being associated with “imadb” (which is used for common document management purposes) and “imaauditdb” (which is used for audit trails). Both datasources must be configured even if the audit trail feature is not intended to be used or licensed. Each datasource configuration is reflected by the same set of parameters in the configuration file. For example, the username to access the datasources is reflected by the following parameters:
-
imaDbUsername=
-
imaAuditDbUsername=
It is possible to use two different ImageMaster 9 databases to separate audit trails from the default document management database (also see Best practices for audit trails).
-
In case of the database type “Microsoft SQL Server”, if you intend to use and obtain a license for the audit trail feature, you must set up two separate databases (one as the default and the other one as the audit trail database).
-
For other database types, in a simple scenario or if you do not intend to use the audit trail feature, the same database can be used for both of these datasources. In this case the same values can be used for both sets of the configuration parameters.
Adjust imaDBMaxPoolSize to avoid connection errors
In the datasources section consider to adjust the database maximum pool size imaDbMaxPoolSize. For details see Troubleshooting – no managed connections available.
Other database topics are covered in the previous topic Database installation.