订阅

UiPath Automation Suite

UiPath Automation Suite 指南

配置 Microsoft SQL Server

Databases


Automation Suite 中的每个产品都需要有自己的具有相应规范的 SQL 数据库。

默认情况下,安装程序会在安装过程中为您创建所有数据库。您必须为安装程序提供必要的权限才能在 SQL Server 中执行此操作。

或者,您也可以选择创建自己的数据库。请参考下表,了解您需要使用的名称。

下表列出了数据库名称及其相应的格式。

Product / serviceDefault database nameConnection string format
Shared Platform CapabilitiesAutomationSuite_PlatformADO.NET
OrchestratorAutomationSuite_OrchestratorADO.NET
Action CenterAutomationSuite_OrchestratorADO.NET
Automation Suite RobotsAutomationSuite_OrchestratorADO.NET
Automation HubAutomationSuite_Automation_HubADO.NET
Data ServiceAutomationSuite_DataServiceADO.NET
InsightsAutomationSuite_InsightsADO.NET
Test ManagerAutomationSuite_Test_ManagerADO.NET
Task MiningAutomationSuite_Task_MiningADO.NET
AI CenterAutomationSuite_AICenterJDBC
Document UnderstandingAutomationSuite_DU_DatamanagerODBC
Process MiningAutomationSuite_ProcessMining_Metadata
AutomationSuite_ProcessMining_Warehouse1
AutomationSuite_Airflow2
ADO.NET
PYODBC

1 AutomationSuite_ProcessMining_Warehouse uses both ADO.NET and PYODBC formats.
2 AutomationSuite_Airflow uses PYODBC connection string format. AutomationSuite_Airflow must have READ_COMMITTED_SNAPSHOT enabled when creating databases manually. The connection to the AutomationSuite_Airflow database can not begin with a { character.

🚧

重要

If you manually set the connection strings in the configuration file, you can escape SQL, JDBC, or ODBC passwords as follows:

  • for SQL: add ' at the beginning and end of the password, and double any other '.
  • for JDBC/ODBC: add { at the beginning of the password and } at the end, and double any other }.

📘

备注:

您可以在弹性池中使用数据库,以获得更高的成本效益。


对于 Apps,您不能使用自己的 MongoDB。

 

权限


如果您希望安装程序在提供的 SQL Server 上创建数据库,请确保至少向用于连接到数据库的 SQL 帐户授予 dbcreator 角色。

如果您希望为所有产品创建自己的数据库,则应向 SQL 帐户授予所有 Automation Suite 数据库的 db_owner 角色。如果安全限制不允许使用 db_owner,则 SQL 帐户应在所有数据库上具有以下角色和权限:

  • db_ddladmin
  • db_datawriter
  • db_datareader
  • 对 dbo 架构的 EXECUTE 权限

 

全文搜索的 SQL 要求


Document Understanding 要求 SQL Server 具有 SQL Server 数据库引擎的全文搜索组件,默认情况下并不总是安装该组件。

如果您在安装 SQL Server 时没有选择全文搜索,请在配置 Document Understanding 之前再次运行 SQL Server 安装程序以进行添加。

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.

 

Insights 的 SQL 要求


Insights 要求使用支持列存储索引和 .json 函数的 SQL Server 2019。

For Azure SQL, ensure the database is S3 service objective or above.

Make sure the compatibility level for Insights database is set to 130 or higher. In most cases, the default settings meet this requirement. For more info, refer to View or Change the Compatibility level of a Database - SQL Server.

安装将验证这两个条件,并在未达到最低要求时向您发出警示。

 

SQL requirements for Data Service


Data Service requires SQL Server version 2016 or higher.
The collation sequence is the same as the default one: Latin1_General_CI_AS.

If you create your own database using SQL Server version 2019 or higher, make sure to grant the following Data Service permissions to your users:

GRANT ALTER ANY SENSITIVITY CLASSIFICATION TO {userName};

GRANT VIEW ANY SENSITIVITY CLASSIFICATION TO {userName};

 

SQL requirements for Process Mining


Process Mining on Automation Suite requires a separate Microsoft SQL Server for the AutomationSuite_ProcessMining_Warehouse for data storage for Process Mining process apps. Below is an overview of hardware requirements and recommendations for setting up a Microsoft SQL Server database machine for AutomationSuite_ProcessMining_Warehouse.

To calculate the hardware requirements, you need to have an indication of:

  • the number of (million) events in your process.
  • the number of case and event fields in your output data. For example, in TemplateOne this would be 30.

📘

备注:

In a development environment, for performance reasons, it is recommended to work on a small development dataset with a limited number of records.

You can use the Capacity calculator to determine the hardware requirements for setting up a dedicated Microsoft SQL Server machine for Process Mining. When you add Process Mining to the Product section, the minimum requirements for 1 Dedicated SQL Server are displayed.

See also Hardware requirements.

 

SQL requirements for HA


For a high-availability configuration of your SQL Server, select an Always On availability group. For more info, refer to Overview of Always On availability groups.

Updated 15 days ago


配置 Microsoft SQL Server


建议的编辑仅限用于 API 参考页面

您只能建议对 Markdown 正文内容进行编辑,而不能建议对 API 规范进行编辑。