Close menu

SQL/R A.04.00 Installation

This document covers the installation of SQL/R A.04.00 and/or update from a previous SQL/R release.

Supported platforms

Linux
SQL/R is available as RPM or DEB packages for the AMD64/EM64T (x86_64) architecture. It supports both 64-bit and 32-bit applications on a 64-bit operating system.

A build for the 64-bit aarch64 (arm64) architecture is available in the deb repository.

Support for the 32-bit x86 (386) and IA64 (Itanium) architecture were discontinued.

HP-UX
SQL/R is available for HP 9000 and HP Integrity servers:

  • Itanium based systems: HP-UX 11iv2 (11.23) or later is required.
  • PA-RISC based systems: HP-UX 11iv1 (11.11) or later is required.

Windows
The SQL/R service is available for 64-bit (x64) Windows and supports both 64-bit and 32-bit applications.

On 32-bit Windows, only the 32-bit SQL/R ODBC drivers can be installed. On 64-bit Windows, both the 32-bit and the 64-bit SQL/R ODBC drivers are installed.

Required minimum Windows version:

  • Windows 7 (July 2016 update rollup, KB3172605)
  • Server: Windows Server 2008 Service Pack 2


Installation directory

Starting with SQL/R A.04.00, multiple SQLR versions may be installed and used in parallel. Each major version is installed into a separate directory while minor updates will update an existing version.

The installation procedure retains the configuration of a previous SQL/R release. Modified configuration files are not deleted.

HP-UX and Linux
The SQL/R A.04.00 software is installed in the /opt/sqlr/4.0 directory, configuration files are in /etc/opt/sqlr/4.0.

When updating from a previous SQL/R version, any configuration files need to be copied manually. A symlink may also be used as configuration files are fully upwards compatible.

Please note: Previous SQL/R versions created a symlink /opt/sqlr to point to /opt/sqlr2. This symlink is removed during the installation.

Windows
By default, SQL/R A.04.00 is installed in the "Program Files (x86)\Marxmeier\SQLR\4.0" directory.

The Windows installation program has the option to migrate the previous configuration files and/or remove the previous SQL/R version.


License keys

SQLR A.04.00 requires a license key version A.04.00 or above. A previous license key for an older version does no longer work.

Please use the online license web form to obtain a license key at: license.marxmeier.com.

Alternatively, please contact the Marxmeier team at info@marxmeier.com to request a license key.

Please refer to the SQL/R license key documentation for detailed information.


Obtaining SQL/R

The SQL/R A.04.00 release is available for download from the marxmeier.com web site: http://www.marxmeier.com/download/sqlr/A0400/.
For Linux platforms we also offer RPM and DEB package repositories: http://www.marxmeier.com/download/repo/.

Please check the SQL/R web site for any updates and recommended patches.


Installing SQL/R

SQL/R installation follows the conventions of the respective platform. For a detailed description, please refer to the following platform specific installation instructions.

HP-UX
The HP-UX installation instructions provide information on supported HP-UX releases, required HP-UX patches and system prerequisites.

Linux
Linux installation instructions provide information on supported Linux releases, system prerequisites and installation along with distribution specific notes.

SQL/R systemd support on Linux provides information on systemd use with SQL/R to manage server processes.

Windows
Windows installation instructions provide information on supported Windows versions, system prerequisites and installation along with platform specific notes.


Configuring SQL/R

The A.04.00 SQL/R configuration document provides detailed information on configuration directory and file names, config templates, and config settings.