V11 prerequisites

This document provides information on version V11 of Sage X3. An overview of the pre-requisites can be found in the Pre-requisites Overview document.

The Sage X3 version V11 platform includes several components. Some of them are linked to the Versions 7 and above platforms, and some are required to support the version 6 technology used by the "Classic" mode.

Management console

This component allows you to configure the different servers used in a SAFE X3 solution and to link them together. The pre-requisites are described in Console Pre-requisites.

Minimal SAFE X3 Management Console versions

For SQL server 2014, you can use the X3 Console CFG.236 delivered on the X3 V11 GA installation medium. It is recommended to use CFG.239 for the initial Sage X3 Solution configuration, or to at least update to CFG.239 after the initial configuration.

For SQL server 2016, you must use the latest X3 Console version (CFG.239 or later) to configure the solution. If you don't:

• The ODBC source creation for the main X3 runtime and additional runtimes will be incorrect and cause later issues when exporting folders (sequence values not exported).
• The folder import function will not properly create the sequence values in the SQL database. As a result, folders imported with the X3 Console CFG.236 on SQL Server 2016 will behave erratically on functions using database sequences.

SQL Server utility (for SQL server 2016)

The X3 Console and the X3 supervisor use the OSQL.exe SQL Server utility to:

• Check and retrieve the SQL Server instance characteristics during configuration through the X3 console.
• Create the SQL Server database in the SQL Server instance (when database creation is performed through the X3 Console).
• Create SQL Server users and schemas when importing a folder through the X3 Console, or when creating a new folder in the X3 Supervisor.
• Export sequence values when exporting folder data, and import sequence values when importing folder data.
• Perform various database verifications or management procedures in the X3 Supervisor.

The "Management tools - complete" SQL Server component handles the installation of OSQL.exe. This component is installed by a separate SQL Server Management Studio (SSMS) package.
The SSMS installation package is not delivered on the SQL Server 2016 installation medium but a download link for this package is provided in the setup function.

If the SAFE X3 management console cannot find OSQL.exe, it rejects the installation environment, or it can use a SQL Server environment which may not be the correct one in the case of systems with multiple SQL Server environments.

For this reason, you have to make sure that OSQL.exe is located on all machines where you install and configure an X3 Runtime component (Main, Additional or Test). If you are using the default installation directory tree, you should find OSQL.exe in %ProgramFiles(x86)%\Microsoft SQL Server\140\Tools\Binn.

For some languages, OSQL.exe is not installed by SQL Server Management Studio (SSMS) 17.1 or 17.2. In this case:

1. Uninstall SQL Server Management Studio 17.x.
2. Install SQL Server Management Studio 16.5.3 (the latest 16.x version).
3. If you want the latest SSMS components, update SSMS 16.5.3 to SSMS 17.x.
   All SSMS downloads can be downloaded here. If necessary, change the locale in the URL.

Clients

• Browsers Pre-requisites
• SAFE X3 Studio Pre-requisites

Application and data server

The application server used by Sage X3 can be installed on a combination of Windows or Linux servers, with Oracle or SQL server databases:

• Windows Oracle 12C SE, EE Pre-requisites
• Windows SQL Server 2014 SE,EE, BI Pre-requisites
• Windows SQL Server 2016 SE,EE, BI Pre-requisites
• Linux Oracle 12C SE, EE Pre-requisites
• Additional Process Server on Windows Pre-requisites
• Additional Process Server on Linux Pre-requisites

"Syracuse" web server

The "Syracuse" web server is based on node.js. It is used to connect to the Sage X3 servers and manage the administration and collaboration data with a nosql MongoDB database.

• MongoDB on Windows Pre-requisites
• MongoDB on Linux Pre-requisites
• Elasticsearch on Windows Pre-requisites
• Elasticsearch on Linux Pre-requisites
• "Syracuse" web Server on Windows Pre-requisites
• "Syracuse" web Server on Linux Pre-requisites

Print server

The pre-requisites are described in Print Server on Windows Pre-requisites.

Documentation server

• Documentation Server on Windows Pre-requisites
• Documentation Server on Linux Pre-requisites

Production Scheduler option

Note: This feature is only available on-premise. If you are using the Cloud solution, this document is not relevant.

Java server

• Java Server on Windows Pre-requisites
• Java Server on Linux Pre-requisites

Webservice and ADC server

• Webservice and ADC Server on Windows Pre-requisites
• Webservice and ADC Server on Linux Pre-requisites

Equipment for radio frequency

The pre-requisites are described in Equipment for radio frequency Pre-requisites

Business Intelligence server

Crystal Reports

Sage X3 uses Crystal Reports as the print engine. The table below shows the version of the Crystal Reports engine used:

Note: To use Crystal Reports Designer 2016, the Print Server version must be ≥ 2.18.