RDBMS - Database Server Software
The RDBMS must be selected based on criteria relating to the bases themselves. The parameters considered for the selection of the RDBMS type should not include Soft1.
SoftOne equally recommends the two predominant RDBMS brands, without any feature of the applications and services favoring either option.
RDBMS (Online mode)
|RDBMS (Offline mode)||Microsoft SQL Server SQL Express 2017 & 2019||Microsoft SQL Express 2012 & 2014|
In case of Microsoft SQL Server, the required Collation Parameter of the base should be SQL_LATIN1_General_CP1253_CI_AI.
In case of Oracle, the required Collation parameter should be EL8MSWIN1253.
|1036||1252||French_100_CI_AS (Sql Server 2008+)||FRENCH||FRA|
Database Server Hardware
The specifications for the database server (should be) specified by the RDBMS manufacturer. Strictly as an indication:
|Disk||NVMe / SSD / SAS / SCS I||SATA III +|
- The above notes with regard to the DataBase Server processor are limited to Intel/AMD systems because during the installation the DataBase Server is usually selected to identify with the Application Server. However, if you choose non-intel-based systems, they will be used exclusively for a Database Server, not for Application. Thus, the specifications of a system are exclusively defined by the RDBMS manufacturer and not by SoftOne.
- The required database server memory is directly related to the size of the database, the active number of users and other characteristics of the installation.
Application Server Hardware
In certain installations, it may be recommended to use more than one application servers.
Desktop (standalone / single user) installations
The specifications for Clients are applied as described below (you should prefer the specifications listed under the column "Recommended".
Windows 7 / 8 / 8.1 / 10+, 64- bit
|Windows 7 / 8 / 8.1 / 10+, 32-bit|
FullHD 1920 * 1050 (ideal)
Wide screen 16:9
Client Connectivity Tools
Client Connectivity Tools (by the RDBMS manufacturer) will be required in the following cases:
- For machines - clients operating additionally as application servers connected directly to the Database Server
- For machines in which the application runs in standalone mode
Client Connectivity Tools will not be required in clients' machines (usually remote) which do not operate (additionally) as Application Servers but communicate with an Application Server on a separate machine (possibly the same as the one with the DataBase Server)
Note: The client tools of the database must be installed on the other computers as well, except server computers, in accordance with the database manufacturer's instructions. In the case of a remote terminal, it is not required to install the client tools of the database because the client-server application model will be used.
- Microsoft Internet Explorer 7 or later version
- Crystal Report Runtime tools for printing forms or open reports that utilize designs that use this tool. Crystal Reports runtime tools are not included in the standard Soft1 installation but are available to download from Soft1 common support area.
Optional business applications & tools
- Microsoft Office Word & Excel Applications (for exploiting the application's combination possibilities in relation to MS Office).
- E-mail application (for cooperation with the relevant application automation).
- Microsoft Script Engine in case you intend to perform customizations designed with Script Engines.
Networks & Telecommunications
An Internet connection is recommended in order to utilize SoftOne Services.
SQL Server Express Limitations
Microsoft SQL Server Express is a powerful and reliable free data management system for small-scale Soft1 installations, with no more than 5 users (web users included too).
Here are some of the most important differences of the SQL Express compared to SQ Standard Edition:
|SQL Standard||SQL Express|
|Maximum Database Size||524 PB||10 GB (1)|
|Compute Capacity||4 sockets or 24 cores||1 socket or 4 cores (2)|
|Maximum Memory||128 GB||1.4 GB (3)|
- SQL Express is limited to a 10 GB database. Splitting data over multiple DBs and then cross-link them by using certain applications will lead to more than 10 GB of data on the server. Be aware though, that your system's performance will be harmed severely if this cannot be achieved. If your data keep growing you are going to hit the 10GB limit resulting in the system's failure and possible data loss. To avoid this, you will need to upgrade your SQL Server.
- SQL Express allows for lesser of 1 socket or 4 cores. This way, your system's computing power is not fully used and this may result in critical problems in case of adding more data or users to your database. On the other hand, SQL Server Standard allows for 4 sockets or 24 cores.
- SQL Express allows for using 1.4 GB of RAM (per instance). On the other hand, SQL Server Standard reaches 128 GB.