ATTENTION
▪SoftExpert recommends using SQL Server Databases. ▪SoftExpert is not responsible for the database management. ▪From version 2.1.9 onwards, Oracle 12 will no longer be supported by SoftExpert Suite. Click here to view the official reference page. ▪SQL Server 2012 is being invalidated due to the end of its support to the system in July of 2022. ▪PostgreSQL 10 is being invalidated due to the end of its support to the system in November of 2022. ▪Oracle 18 is being invalidated due to the end of its support to the system in June of 2021. |
DBMS certified to execute SoftExpert Suite:
Database server
|
SoftExpert Suite
|
DBMS
|
Version
|
2.2.0
|
Oracle
|
11g
|
|
Oracle
|
11g R2
|
|
Oracle
|
12c
|
|
Oracle
|
12c R2
|
|
Oracle
|
18c
|
|
Oracle
|
19c
|
|
Oracle
|
21c
|
|
SQL Server(3)
|
2012 Enterprise, BI, Standard, Web, Express(1)
|
|
SQL Server(3)
|
2014 Enterprise, BI, Standard, Web, Express(1)
|
|
SQL Server(3)
|
2016 Enterprise, BI, Standard, Web, Express(1)
|
|
SQL Server(3)
|
2017 Enterprise, BI, Standard, Web, Express(1)
|
|
SQL Server(3)
|
2019 Enterprise, BI, Standard, Web, Express(1)
|
|
PostgreSQL(2)
|
9.4
|
|
PostgreSQL(2)
|
9.6
|
|
PostgreSQL(2)
|
10.3
|
|
PostgreSQL(2)
|
11
|
|
PostgreSQL(2)
|
12
|
|
PostgreSQL
|
13
|
|
PostgreSQL
|
14
|
|
1 - SQL Server Express Edition may be used provided some requirements are met. See further details in "SQL Server Express Edition Restrictions" below.
2 - Files larger than 30 MB must not be stored in the database; the controlled directory option must be used.
3 - The language of the user who will connect to the database must be "English".
|
▪SoftExpert Suite makes available the data source functionality, which allows the connection with other databases. Because of the evolution of the tool, the supported DBMSs, such as PostgreSQL, SQL Server, and Oracle, will be compatible in the data source only for the supported versions noted above. ▪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. |
▪The connection to the DBMSs via ODBC in the data source functionality is not supported by SoftExpert Suite. |
SQL Server Express Edition Restrictions
If the requirements below are not respected, the application performance may be harmed:
▪The number of simultaneous users in the solution must be inferior to 15. ▪No other application may use the same database server.
Requirements to use SQL Server Express:
SQL Server Express
|
2012, 2014, and 2016
|
Database size
|
10 GB
|
RAM
|
1 GB
|
CPU
|
1 CPU or 4 Cores
|
Recommended versions of Oracle Client
SoftExpert recommends the use of 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
|
ATTENTION
If SoftExpert Suite is installed on a Windows server, it will be mandatory to install the 32-bit Oracle Client and the 64-bit Oracle Client. If the 32-bit Client is installed first and the 64-bit Client is installed next, then it will be only necessary to check the order of the parameters of the environment variables, because the configuration is performed automatically. Otherwise, the configuration of the PATH variable should contain, as its first parameter, the installation path of the 64-bit Oracle and then the installation path of the 32-bit Oracle.
|
|
