Requirements
Machine Learning Extensions enhance the functionality of dab AnalyticSuite with in-database machine learning analytics directly running on your SQL Server. For this feature they use the SQL Server Machine Learning Services, which is a component that needs to be installed additionally in the SQL Server instance.
Adding Machine Learning Services to an existing SQL Server Instance
This process is documented for the following by dab AnalyticSuite supported SQL Server Versions. Besides that also refer to the dab Nexus system requirements.
Version | Documentation |
SQL Server 2017 | |
SQL Server 2019 | |
SQL Server 2022 |
To provision the required R packages one of the following methods can be used, however the first one is heavily recommended.
Using a prepackaged R runtime
To simplify the installation process, we provide pre-built versions of R that can be downloaded from the customer portal. This is the recommended way to avoid package deployment issues and the only way to ensure proper functionality.
- Download: Download the R Runtime as a ZIP from the customer portal (you can find the version in the ZIP name, use this name in the folder at point 2)
- Create a folder where you want to install the runtime: the folder must be created by yourself (name e.g.: %ProgramFiles%\R\R-4.x.x) - replace R-4.x.x with the version from the ZIP name. The folder must be in a location that can be accessed by the SQL Server service account
- Unzip the files: Extract the files from the AnalyticSuite R runtime environment archive to the folder created in step 2
- Open command line as administrator (CMD): change to the created folder and then to the following directory (replace <PATH> with the directory path to the folder just created)
cd <PATH>\R\R-4.x.x\library\RevoScaleR\rxLibs\x64- Execute the following command on the command line in this folder:
.\RegisterRext.exe /configure /rhome:“<PATH>” /instance:"<MSSQLSERVER>”- Replace <PATH> with the directory path to the folder you created: e.g. %ProgramFiles%\R\R-4.x.x
- Replace <MSSQLSERVER> with the name of your instance
Installing the R runtime manually
Starting from SQL Server 2022 you can also setup a supported R installation from version 4.2 onwards, by installing the following packages using the R command for package installation:
- dplyr
- data.table
- stringdist
- isotree
- dbscan
- stringr
- caret
- jsonlite
- ranger
- e1071
- qlcMatrix
- tidyverse
- arules
- mltools
- stopwords
