Database requirements
- Updated: 2024/08/23
Database requirements
View the list of supported databases, database server type, version, hardware, and operating system requirements, and database backup and recovery requirements.
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 |
Database server version and operating system requirements
Database type | Database version | Database edition | Supported Operating system | Supported platforms | Configuration requirement |
---|---|---|---|---|---|
Microsoft SQL Server database |
|
|
|
|
Installed and configured. Only option for Express installations. Enable protocols for Named Pipes and TCP/IP. |
Oracle Server database | Oracle 19c |
|
|
|
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 for PaaS database on
standalone deployment.Note: Whether you use Amazon RDS for SQL Server or Azure SQL, ensure that you configure a single dedicated database for the Control Room.Note: 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 in usernames and passwords. Do not use semicolons ( ; ) in the database password. |
Linux example: SQL Database server Login ID: SQL Database password: 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:
|
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
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.