Content Manager database server prerequisites
The Content Manager requires an Oracle or Microsoft SQL Server database. This topic lists the required and supported software for the Content Manager database. Note that The Content Manager database server runs on any operating system that supports the specific DBMS you choose to use. Refer to your database vendor documentation to learn which operating systems are supported.
Recommended prerequisites
- Oracle Server 19c (19.3) (Enterprise Edition)
- Microsoft SQL Server 2019 (Standard Edition or Enterprise Edition)
- Microsoft Azure SQL Database
- AWS RDS-MSSQL 2019
If your implementation uses MSDTC, then you cannot use the Cloud database servers, that is, Azure or AWS RDS-MSSQL.
Supported Microsoft SQL Server databases
Content Manager supports the following Microsoft SQL Server databases.
- SQL Server 2019 (Standard Edition or Enterprise Edition)
- SQL Server 2017 (Standard Edition or Enterprise Edition)
Supported Oracle databases
Content Manager supports the following Oracle databases.
- Oracle Database 19c (19.3) (Enterprise Edition)
- Oracle 18c (18.3) (Enterprise Edition)
Supported Cloud-based databases
Content Manager supports the following Cloud-based databases.
Supported:
- Microsoft Azure SQL Database
- AWS RDS-MSSQL 2019
| Setup item | Type |
|---|---|
| Service tier | General Purpose |
| Compute tier | Provisioned compute |
| Hardware | Intel computer (or cloud equivalent) |
| Database | Single database |
| Backups | Automated backups |
- AWS RDS-MSSQL 2017
Cloud hosting
- Amazon RDS (Relational Database Services) (for Microsoft SQL Server)
- Microsoft Azure
.NET
To install the Content Manager database on a Windows machine, Microsoft .NET Framework 4.8 or higher must be installed on that machine.
PowerShell database script prerequisites
- PowerShell
- You require Microsoft Windows PowerShell 5.1. You can download Microsoft Windows Management Framework 5.1, which includes Microsoft Windows PowerShell 5.1, from this location: http://aka.ms/wmf5download
- Operating system
- You require an operating system that supports both the required PowerShell software and any software for the database you intend to install. As a general rule, ensure that the latest (security) updates are installed on your operating system.
- Database client software
-
For Oracle databases, you require both of the following:
- Oracle Services for Microsoft Transaction Server (ORAMTS)
- Oracle Data Provider for .NET (ODP.NET)
- Environment variables
-
For Oracle databases where you have defined a Net Service Name for each database in a tnsnames.ora file, you must also have defined a
TNS_ADMINenvironment variable. Set it to the directory where tnsnames.ora resides. - Microsoft .NET Framework
-
You require a .NET Framework version. The one to use depends on your Windows Server operating system version:
- If you run Microsoft Windows Server 2022, you can use Microsoft .NET Framework 4.8.1. You can download Microsoft .NET Framework 4.8.1 from the following location: https://dotnet.microsoft.com/en-us/download/dotnet-framework/net481
- If you run Microsoft Windows Server 2019 x64, you must use Microsoft .NET Framework 4.8. You can download Microsoft .NET Framework 4.8 from the following location: https://dotnet.microsoft.com/en-us/download/dotnet-framework/net48
- Security
- You need to be logged in as a user with sufficient security clearance. For example, to run a script that installs a database, you must be logged in as a user with rights to create that database.