Enterprise 11 database requirements
- Última actualización2022/08/09
Enterprise 11 database requirements
For Oracle Database, one instance of the database with two separate schemas of the same database are required. For Microsoft SQL Server, two databases on the same instance of the database server are required. View the list of supported databases, database server type, version, hardware, and operating system requirements, and database backup and recovery requirements.
Automation Anywhere databases
Automation Anywhere installation creates databases to store bot data and metadata for the analytics dashboards.
- Database for Control Room
- Databases for Bot Insight and Bot Insight metadata
For all Custom installations: As of Version 11.3.4, have a user, with the minimum database permissions, create the databases before you install. See Enterprise 11 credential requirements for the database permissions required.
Database for component | Default database name |
---|---|
Control Room |
CRDB-NEW
|
Bot Insight |
BotInsight
|
Bot Insight metadata |
BIVisualization
|
CRDB-NEW
and
BotInsight
database names. The name provided for the
BIVizualization
database during installation will be used as a
prefix for -Scheduler
database. Therefore, do not change the suffix
part in -Scheduler
database. The BIVizualization
and the BIVisualization-scheduler
databases will be created during
the Control Room installation.Starting from Automation Anywhere Control Room release 11.3.5, the
BIVisualization-keyset
and
BIVisualization-upload
databases are integrated with the
Bot Insight services.
-
BIVisualization
-
BIVisualization-scheduler
-
BIVisualization-keyset
-
BIVisualization-upload
Database server hardware requirements
Component server | Processor | RAM | Storage | Network |
---|---|---|---|---|
Microsoft SQL Server database | 4-core Intel Xeon Processor | 8 GB | 500 GB | 1 GbE |
PostgreSQL Server database | 2-core Intel Xeon Processor | 4 GB | 10 GB | 1 GbE |
Oracle Server database(1) | 8-core Intel Xeon Processor | 32 GB | 500 GB | 1 GbE |
- Note 1
- For Oracle databases, do not use containers or pluggable databases.
Database server version and operating system requirements
One of either a Microsoft SQL Server database or Oracle Database is required.
Database type | Database version | Database Edition | Installed database OS | Configuration requirement |
---|---|---|---|---|
Microsoft SQL Server database |
2012 2016 2014 SPI 2014 SP3 2017 2019 For Microsoft Azure installations, use version 2014, 12.0.2000.8 (RTM) or later |
Standard, Enterprise and Express |
Windows Server 2008 R2 Standard or later | Installed and configured. Only option for Express installations Enable protocols for Named Pipes and TCP/IP. |
Oracle Database |
19.3.0.0.0 (1) 18.0.0.0.ru-2019-07.rur-2019-07.r1 12.1.0.2.v13 |
Standard and Enterprise |
Server 2016 Datacenter | Installed and configured. Only allowed with Custom Installations and for non-container database. When you install Control Room with Oracle Database ,PostgreSQL Server is required to support Bot Insight metadata databases. Install JDBC driver on Control Room server.Create users for Automation Anywhere to access the database. |
PostgreSQL Server database | 9.5.19 | - | Windows Server 2008 R2 Standard or later, Red Hat Enterprise Linux, or Ubuntu LTS |
Optionally installed with Control Room. Supports metadata related to analytics dashboards only. Configure PostgreSQL Server as PaaS and enable SSL.For Microsoft Azure installations, disable SSL. |
- 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 Anywhere Enterprise testing and proof of concept (POC) purposes.
- (1): Oracle Database 19.3.0.0.0 that is hosted on a Linux server is also supported.
- When you access the Operations Manager dashboard ( ), no data is displayed. A warning message is displayed, which you can close.
Database backup and recovery requirements and schedules
Database action | Requirement |
---|---|
Backup database process |
|
Backup maintenance schedule |
|
Backup installation and configuration files | Files are listed in Automation Anywhere configuration and properties files. This includes:
|
Configure Microsoft SQL Server 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. See Enterprise 11: Configure database type and server. The following table summarizes the required information.
Microsoft SQL Server database | |
---|---|
Required information | Description |
Database (SQL Server) authentication | Provide credentials for a Microsoft SQL Server user who has permission to connect to the database. |
Database names | Ensure the database names for Control Room and
Bot Insight are the same with Microsoft Azure installations. Database names cannot be blank, have spaces, or include a % (percent character). Restrict the names to alphanumeric, period (.), dash (-), and underscore (_). |
Database port | Default: 1433 Dynamic ports are not supported. |
Secure connection (optional) and certificate | Provide a CA certificate. Ensure the certificate host name and database connection are the same. See Enterprise 11: Import HTTPS and CA certificates. |
Service credentials | Provide Local system account user or Domain user account. This becomes the assigned user for the created databases and tables. The preferred method is to use the Domain user account. |
Windows authentication | User-provided (or default) used to connect to the Microsoft SQL Server, test database exists,
create database if not present, and set
db_owner to the service account user. |
Oracle database | |
---|---|
Required information | Description |
Bot Insight database instance name | Created when database was created. |
Bot Insight database instance credentials |
Username and password. |
Database port | Default 1521. |
Database server | Provide Oracle Database server host name details, including IP address and user credentials. |
Control Room database instance name | Created when database was created. |
Control Room database user credentials |
Username and password. |
Secure connection (optional) and certificate | Provide a CA certificate. Ensure the certificate host name and database connection are the same. See Enterprise 11: Import HTTPS and CA certificates. |
Database user condition | Database required permission | Notes |
---|---|---|
Custom,Version 11.3.4 or later, Microsoft SQL Server database | Can have the minimum database permissions:
datareader ,
datawriter and
ddladmin . |
Microsoft SQL Server database must be created before Control Room installation. |
Custom, Version 11.3.4 or later, Oracle Database | Can have the minimum database permissions:
GRANT CONNECT ,
RESOURCE , CREATE
TABLE , CREATE
VIEW
|
Oracle Database database must be created before Control Room installation. |
Custom, older than Version 11.3.4 | Database Owner (DBO) permissions. | Databases created during Control Room installation. |