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
Database server	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


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 and 7.9 Red Hat Enterprise Linux 7.7 and 7.9	Amazon Web Services Relational Database Service (RDS)	Installed and configured. Only option for Express installations. Enable protocols for Named Pipes and TCP/IP.
Oracle Server database	Oracle 19c	Standard Enterprise	Windows Server 2012 R2 or later Linux CentOS 7.7 and 7.9 Red Hat Enterprise Linux 7.7 and 7.9	Amazon Web Services Relational Database Service (RDS)	Installed and configured with max_string_size parameter set to EXTENDED. Supported only on non-container Database. Available only through an On-Premises custom installation.

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.
Transparent Data Encryption (TDE) is a function of Microsoft SQL Server database. Additional configurations are not required on the Control Room as the TDE supportability is managed by Microsoft. For more information, see Transparent data encryption (TDE) and Transparent data encryption for SQL Database.

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`, and `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`

For Oracle Server database information, see Installing Control Room using custom mode for Oracle installation.

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.