Read and Review Automation Anywhere Documentation

Automation 360

Close Contents


Open Contents

Database requirements

  • Updated: 2022/04/19
    • Automation 360 v.x
    • Install
    • RPA Workspace

Database requirements

View the list of supported databases, database server type, version, hardware, and operating system requirements, and database backup and recovery requirements.

Automation Anywhere installation creates a database to store bot data and metadata for the analytics dashboards.
Note: Automation Anywhere does not provide any monitoring functions for database activities, such as disk space usage, memory, or other alert mechanisms related to databases. There are commercial tools available from database vendors and other third-party independent software vendors (ISV) who provide such tools.

For latest updates, see Microsoft SQL Server Hardware and Software requirements.

Database server hardware requirements

Component server Processor RAM Storage Network
Microsoft SQL Server database

4-core Intel Xeon Processor with 2.5 GHz plus speed

8 GB 500 GB 1 GbE
Note: If you are hosting the Control Room databases along with other application databases, ensure that the hardware resources are increased proportionately.

Database server version and operating system requirements

Microsoft SQL Server database is required.

Database type Database version Database edition Installed OS Supported platforms Configuration requirement
Microsoft SQL Server database
  • 2019
  • 2017
  • 2016
  • 2014
  • Enterprise
  • Express
  • Standard
  • Developer (for 2019)
  • Windows Server 2008 R2 Standard or later
  • Linux CentOS 7.7, 7.9, and 8.3
  • Red Hat Enterprise Linux 7.7, 7.9, and 8.3
Amazon Web Services Relational Database Service (RDS)

Installed and configured.

Only option for Express installations.

Enable protocols for Named Pipes and TCP/IP.

  • All database versions support all certified operating systems.
  • We have certified Amazon RDS for SQL Server and Azure SQL single database for PaaS deployment.

    Note that for Azure SQL, CPU or memory requirements are not applicable because it is a scalable and high performance Cloud database built on similar lines with SQL Server and certified for PaaS deployment in Automation 360.

  • We recommend hosting the databases on separate hosts to take into account failover scenarios.
  • We recommend Enterprise or Standard editions of Microsoft SQL Server database for production use and to ensure business continuity with HA and DR deployments.

    You can configure the Express edition of Microsoft SQL Server for Automation 360 testing and proof of concept (POC) purposes based on considerations such as limit on data size, SQL agent unavailability, and DR capabilities.

    For more information about scale limits, see Microsoft SQL Server Express edition scale limits.

Required database information for Automation Anywhere installation

When you install Automation Anywhere, you are prompted to provide information specific to the database type you are using. The following table summarizes the required information.

Microsoft SQL Server database
Required information Description
Database (SQL Server) authentication
Note: Linux installations use this authentication method

Provide credentials for a Microsoft SQL Server user who has permission to connect to the database.

Use only supported characters for the authentication user name and password. See Supported special characters. Do not use semicolons ( ; ) in the database password.

Linux example:

SQL Database server Login ID: sa

SQL Database password: Automation123

sa user authentication is mandatory.

Database names

Database names cannot be blank, have spaces, or include a percent ( % ). Restrict the names to alphanumeric, period ( . ), hyphen ( - ), and underscore ( _ ).

Default name: Automation360-Database

Database port Default: 1433

Connection to this port is mandatory.

Secure connection (optional) and certificate Provide a CA certificate. Ensure the certificate host name and database connection are the same.
Service credentials

Provide the user with db_datareader, db_datawriter, or db_ddladmin permissions to create databases during installation.

The preferred method is to use the Domain user account.

Windows authentication

The Windows credentials of the user logged in to the device to connect to the database server.

Database collation Use the default database collation: SQL_Latin1_General_CP1_CI_AS
Before installing Automation 360, ensure that you have configured additional firewall settings, verified the connection to the default port and an SQL query with SA user works as expected.
Send Feedback