Subscribe

UiPath AI Center

UiPath AI Center

Configuring MS SQL Server

General SQL Server requirements

The installation requires an external SQL server as a prerequisite.

📘

Note:

AI Center can use the same SQL Server as Orchestrator for metadata storage.

🚧

Important!

Make sure that the SQL server can be accessed from each cluster VM.

We support versions 2016, 2017, and 2019 for Enterprise and Standard for MS SQL.
The minimum requirements for the server are:
8 Cores CPU
32 GiB RAM
246 GiB SSD

🚧

Important!

We do not support the following characters in the SQL username and password: ; # @ ?.

By default, we support the option for the installer to create all the databases for you in the installation process. You must provide the necessary permissions for the installer to do so in your SQL server.
Alternatively, you also have the option to create your own databases. Please refer to the following table for the default names. Note that if you do not use the default names, you will need to provide the connection string the cluster_config.json file.
The following table lists out the database names and their corresponding format.

Product / service

Default database name

Connection string format

AI Center

AutomationSuite_AICenter

JDBC

Document Understanding

AutomationSuite_DU_Datamanager

ODBC

📘

Note:

You could use the databases in an elastic pool for better cost-effectiveness.

 

SQL Requirement for Full-Text Search


Document Understanding requires the SQL Server to have the Full-Text Search component of the SQL Server Database Engine, which is not always installed by default.

If you did not select Full-Text Search when you installed SQL Server, run SQL Server Setup again to add it before configuring Document Understanding.

For more info, check this guide on how to add/install features on SQL server. You can also check here all the components that can be added to the SQL Server, which includes also Full-Text Search.

 

Updated 14 days ago

Configuring MS SQL Server


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.