Databases
enaio® requires a relational database instance to store and manage index data and documents. We highly recommend providing enaio® with an exclusive database to ensure performance. Access by third-party programs to the data structures and data managed by enaio®, particularly extending the database to include other database objects (tables, views, etc.) and manipulating existing database objects (tables, indexes, etc.) is not permitted.
The system prerequisites for the individual manufacturers must be observed for operation of the relevant database system.
A database user with the 'db_owner' role is required.
The following databases are supported:
DBMS | Version |
Operating system DB server |
ODBC driver |
---|---|---|---|
Microsoft SQL Server
|
2014 (32- and 64-bit) |
Windows 2012 64-bit |
6.02.9200.16384 (Microsoft SQL Server) 2014.120.2000.08 (Microsoft SQL Native Client 11.0) SQL Server (default driver of the operating system) |
2016 (32- and 64-bit) |
Windows 2016 64-bit |
2015.130.811.168 (MS ODBC Driver 13 for SQL Server) 10.00.14393.00 – SQL Server SQL Server (default driver of the operating system) |
|
2017 (32- and 64-bit) |
Windows 2016 64-bit |
MS ODBC Driver for SQL Server – 17.4.2.1 (32- and 64-bit) SQL Server (default driver of the operating system) |
|
2019 (32- and 64-bit) |
Windows 2019 64-bit |
MS ODBC Driver for SQL Server – 17.5.2.1 (32- and 64-bit) SQL Server (default driver of the operating system) |
|
If you are using Microsoft SQL Server in a Unicode installation, you must use the sort order 'Latin1_General_100_CI_AS_WS' for the database; for an Ansi installation, you must use 'Latin1_General_CI_AS'. |
|||
Oracle DB Server |
12c R2 |
|
12.2.0.1.0 (Oracle) – 32-bit |
19c (32- and 64-bit) |
|
19.3 (Oracle) – 32- and 64-bit |
|
For enaio® server 64-bit and Oracle databases with native Oracle ODBC driver, the following registry entry must be added to the DataBase key: String: AlternativeODBC / value: 1 • Unicode character sets are not supported for Oracle databases. If Unicode character sets are used, we cannot guarantee proper functionality of the system. For example, WEMSWIN1252 or WE8ISO8859P15 can be used as character sets. |
enaio® requires a high-performance network connection for the database. The database memory should be dimensioned in such a way that all database indexes can be stored there. At least 4 GB of memory and two exclusive processor cores are recommended.
As a general guideline, it takes about 1 GB of memory per one million saved objects in order to have rapid access to the indexes.
The settings for configuration and installation of the respective virtualization software must be observed when virtualizing the database.