The SQL start guides are included here as a courtesy. It is your responsibility to find the proper installation procedures and documentation from your chosen database vendor. The entire responsibility for installation, care, and maintenance of the database server lies with the customer. We do not provide any kind of support for the database server.
MySQL 5.6x or 5.7x (If using MySQL, the MySQL Connector/J (JDBC 5.1.21 or higher driver) must be provided for the Retain Server and / or Reporting and Monitoring Server.)
Oracle 10/11g/12c
MS SQL Server 2008 R2, 2012, 2014, 2016
PostgreSQL 9
MariaDB
Retain Technical Support cannot support your Database Management System (DBMS) for several reasons including:
Database corruption issues are caused by bugs in the database system itself or by issues in the underlying subsystem.
Retain can be configured to use one of several database systems and there are too many combinations for our staff to become expert in all of them.
Legally, we cannot provide support for the DBMS.
This guide is provided purely as a courtesy and will detail a very basic installation and database creation for Retain. This guide is provided with no warranty and no SQL database support is offered.
The database setup on all platforms proceeds as follows:
Download the SQL DBMS of your choice
Install it to the server of your choice, this may the Retain server itself, or on a dedicated database server
Log in and create a database for Retain to use
Create a user with rights for Retain
Configure Retain to connect to the database server and database with the user specified.
WARNING:NFS shares should not be utilized in any database system. NFS locking is insufficient for database requirements and will result in corruption.