Database
- From SoftExpert Suite version 2.2.3, installations and updates will no longer be supported for traditional environments; support will be provided only for Full Docker installations.
- SoftExpert recommends using SQL Server databases.
- SoftExpert is not responsible for managing databases.
- As of version 2.1.9, SoftExpert Suite will no longer support Oracle 12. Click here to see the official reference page.
- SQL Server 2012 will no longer be accepted, due to the end of its support to the system, in July of 2022.
- PostgreSQL 10 will no longer be accepted, due to the end of its support to the system, in November of 2022.
- Oracle 18 will no longer be accepted, due to the end of its support to the system, in June of 2021.
- Starting in version 2.2.3 of SoftExpert Suite, SQL Server 2014 will no longer be supported. SQL Server versions 2016 and 2017 will only be accepted for updates of existing installations, but cannot be used in new installations of versions later than 2.2.3.
- From the next version of SoftExpert Suite, SQL Server 2016 and PostgreSQL 12 will no longer be supported.
DBMSs validated to run SoftExpert Suite:
| DBMS | Version | 2.1.9 | 2.2.0 |
|---|---|---|---|
| Oracle | 11g | ||
| Oracle | 11g R2 | ||
| Oracle | 12c | ||
| Oracle | 12c R2 | ||
| Oracle | 18c | ||
| Oracle | 19c | ||
| Oracle | 21c | ||
| SQL Server(³) | 2012 Enterprise, BI, Standard, Web, Express(¹) | ||
| SQL Server(³) | 2014 Enterprise, BI, Standard, Web, Express(¹) | ||
| SQL Server(³ ⁴) | 2016 Enterprise, BI, Standard, Web, Express(¹) | ||
| SQL Server(³ ⁴) | 2017 Enterprise, BI, Standard, Web, Express(¹) | ||
| SQL Server(³) | 2019 Enterprise, BI, Standard, Web, Express(¹) | ||
| SQL Server(³) | 2022 Enterprise, BI, Standard, Web, Express(¹) | ||
| PostgreSQL(²) | 9.4 | ||
| PostgreSQL(²) | 9.6 | ||
| PostgreSQL(²) | 10.3 | ||
| PostgreSQL(²) | 11 | ||
| PostgreSQL(²) | 12 | ||
| PostgreSQL | 13 | ||
| PostgreSQL | 14 |
- ¹ - SQL Server Express Edition may be used, provided that some requirements are met. See further details in "SQL Server Express Edition restrictions" below.
- ² - Files larger than 30 MB must not be stored in the database; the controlled directory option must be used.
- ³ - The language of the user who will connect to the database must be "English".
- ⁴ - Can only be used in updates of version 2.2.3. It will not be compatible with new installations as of version 2.2.3 (including the latter).
- SoftExpert Suite provides the data source feature, which allows for connecting to other databases. Due to the evolution of the tool, supported DBMSs, such as PostgreSQL, SQL Server, and Oracle, will be compatible, in the data source, only with the proper supported versions.
- If the database version is 'SQL Server 2019', the database must have, at least, patch 15.04138 (CU11), according to the patch list at: https://sqlserverupdates.com/sql-server-2019-updates/. We highly recommend keeping database fix patches always up-to-date, as they may contain engine bug fixes.
- The DEFAULT_SCHEMA of the application user must necessarily be the SQL Server "dbo" standard; otherwise, you will face issues while equalizing the database.
Connection to the DBMSs via ODBC for the data source feature is not supported by SoftExpert Suite.
SQL Server Express Edition restrictions
If the requirements below are not complied with, the application's performance may be compromised:
- The number of simultaneous users in the solution must be lower than 15.
- No other application may use the same database server.
Requirements for using SQL Server Express:
| SQL Server Express | 2012, 2014 and 2016 |
|---|---|
| Database size | 10 GB |
| RAM | 1 GB |
| CPU | 1 CPU or 4 Cores |
Oracle Client recommended versions
SoftExpert recommends using the Oracle Client version on the application server, as shown in the table below:
| Server | Client |
|---|---|
| 18.X | 18.X |
| 18.X | 19.X |
| 19.X | 18.X |
| 19.X | 19.X |
If SoftExpert Suite is installed on a Windows server, installing the 32-bit Oracle Client and 64-bit Oracle Client will be mandatory. If the 32-bit Client is installed first and the 64-bit Client is installed next, simply check the order of the parameters of the environment variables, as the configuration is set automatically. Otherwise, the configuration of the PATH variable must contain, as its first parameter, the installation path of the 64-bit Oracle, and then the installation path of the 32-bit Oracle.