Connecting External Modules to Foresight Analytics Platform

Integration with Python

Integration with the Python language enables the user to extend functionalities of Foresight Analytics Platform in the Modeling and ForecastingTime Series AnalysisReports tools. The Python functions are applied in the uniform formula editor.

NOTE. Integration with Python from 3.5 to 3.8 is supported. The bitness of Python Foresight Analytics Platform must match

Python integration steps differs depending on operating system in use:

For Python integration on Windows OS:

  1. Load Python distribution file.

  2. Install Python on the same computer where the Foresight Analytics Platform desktop application is installed. If Python is supposed to be used in the web application, install Python on the computer where BI server is located.

  3. Select the Add Python 3.5 to PATH checkbox in the Python installer to add a path to the folder with installed Python in the Path system variable.

The integration of Foresight Analytics Platform with Python will be executed. All executed scripts must be in the Foresight Analytics Platform installation folder.

To determine additional folder with scripts:

For Python integration on Linux OS prebuild Python source files.

Python Build from Source Files on Linux OS

See below an example of Python source files build of 3.6.9 version on Astra Linux CE OS.

Execute the following operations:

  1. Download archive containing source files of Python 3.6.9:

wget https://www.python.org/ftp/python/3.6.9/Python-3.6.9.tgz

  1. Unpack file form archive:

tar xvf Python-3.6.9.tgz

cd Python-3.6.9

  1. Add configure to the file delivered with Python sources, parameters --enable-shared to generate dynamic library used by platform and --prefix that specifies Python installation folder:

./configure --enable-shared --prefix=/opt/python

  1. Compile Python source code, using altinstall:

sudo make altinstall

NOTE. The altinstall command is used to prevent Python binary file replacement which default path is S/usr/bin/python, where S is the Python installation folder path.

Compilation result must be the following:

Collecting setuptools

Collecting pip

Installing collected packages: setuptools, pip

Successfully installed pip-18.1 setuptools-40.6.2

Integration with Python on Linux OS

See below the example of Python 3.6.9 integration on Astra Linux CE OS. Make sure that Python source files build is ready.

For Python integration on Astra Linux CE OS:

  1. Check that source files are correctly build and new Python version is installed.

If default version was not rewritten in the system, check current Python version using the following command:

python3.6 --version

  1. Execute of the operations if the command was not found:

    • Add path to the Python installation folder in the Path system variable:

echo export PATH=$PATH:/opt/python/bin >> ~/.bashrc

source ~/.bashrc

echo export LD_LIBRARY_PATH="/opt/python/lib:$LD_LIBRARY_PATH" >> ~/.bashrc

source ~/.bashrc

On the first Python use, the platform will look for the library from the list:

libpython3.8m.so, libpython3.7m.so, libpython3.6m.so, libpython3.5m.so

The platform will use the first found library before the restart. To restart the platform, restart services using the command:

sudo service foresight-httpd2.4-fp9.2 restart

  1. If several Python versions have been installed, execute one of the operations to use the specific library version:

    • Create a symbolic link to the required library:

ln -s /opt/python/lib/libpython3.6m.so /opt/foresight/fp9.2-biserver/bin/

"PythonLib"="libpython3.6m.so"

 Save settings to the file with the *.reg extension to the folder /opt/foresight/fp9.2-biserver/bin.

NOTE. The registry key HKEY_CURRENT_USER can be replaced with HKEY_LOCAL_MACHINE if the path to the Python library is specified for all users and not only for the current user.

 

Integration with R

Connection of static package R allows to extend Foresight Analytics Platform in the Modeling and ForecastingTime Series Analysis tools and in the uniform formula editor.

To connect R statistical package:

  1. Install the R package on the local computer and application server, if theTask Scheduler tool is supposed to be used to start modeling problems calculation.

    1. Load R installer.

    2. Load RServe. On using Windows OS, use the RServe binary files.

    3. Install R.

NOTE. For details about R package installation, see the R documentation.

After the installation add the path to the S\bin folder to the Path system variable, where S is the path with installed R package.

    1. Install RServe.

NOTE. For details about Rserve package installation, see the Rserve documentation.

On using Windows Os unpack the RServe binary files to any folder.

Copy the Rserve.exe, Rserve_d.exe, Rserve.dll files from the R folder K\Rserve\libs\i386\ to the S\bin\i386 folder, where K is the folder with unpacked RServe binary files and S is the R installation folder.

NOTE. It is not allowed to install RServe to Windows OS using the R interface because the required files will not be copied to the R installation folder.

    1. Start R.

    2. Select the Packages > Install Package(s) main menu item and install the required R packages. If these packages have already been downloaded to the workstation, they can be installed by selecting the Packages > Install Packages from Local Zip-Files main menu item. Detailed information about the packages required for R method calculation, is given in the Which Foresight Analytics Platform Methods can be Calculated Using R? section.

  1. In Foresight Analytics Platform specify the path where R package is installed, or server where R package is deployed.

NOTE. This step is necessary if R is installed on the workstation different from the workstation, where Foresight Analytics Platform is installed. If the R package is installed on the same workstation where Foresight Analytics Platform, path to the R directory will be already specified.

    1. Select the Tools > Parameters main menu item:

The Parameters dialog box opens.

    1. Go to the External Modules tab and specify the folder, where the R Package is installed. For example:

So, the integration of Foresight Analytics Platform with R package will be performed.

See also:

Which Foresight  Analytics Platform Methods can be Calculated Using R?