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

SQL/R is available as an RPM or DEB package for the AMD64/EM64T (x86_64) architecture. It supports both 64-bit and 32-bit applications.
Experimental support for the 64-bit arm (aarch64) architecture was added. Support for the 32-bit x86 (386) and IA64 (Itanium) architecture was discontinued.

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.

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 version, any configuration files need to be copied manually. A symlink may also be used as configuration files are fully compaptible.

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

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

SQL/R A.04.00 requires a license key version A.04.00 or above. For a new SQL/R installation or when upgrading from a previous SQL/R version a new license key must be obtained to use the SQL/R server components.

Please refer to SQL/R A.04.00 License Key documentation for additional details.

Obtaining SQL/R

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

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.

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

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

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.