Datical DB runs on the following platforms and software.

Hardware Requirements

Software Requirements

Operating System

Software

Internet Access

You normally need internet access from the hosts where you install Datical DB. If you access the internet through a proxy server you need to configure your browser and Datical DB to use it. 

If you do not have internet access from the hosts where you want to install Datical DB, you can download files to use for installation and updates. Move them to where those hosts have network access to it. 

Database Requirements

The following databases are supported. 

DatabaseVersionsNotes
IBM DB2
IBM DB2 LUW
  • 11.1
  • 11.5 
Support for 11.5 was added in release 7.12 
DB2 z/OS
  • 12.1.5
Support for 12.1.5 was added in the 8.2 release
Microsoft SQL Server
Microsoft SQL Server
  • 2014
  • 2016
  • 2017
  • 2019
  • 2022

JDBC driver supports TLS 1.0, 1.1, and 1.2

(Support for 2017 & 2019 was added in 7.9 release)

(Support for 2012 was dropped in 8.5 release)

(Support for 2022 was added in 8.5 release)

Azure SQL DatabaseLatest Compatibility LevelAs of the 7.9 Release
Azure SQL Managed InstanceLatest Compatibility LevelAs of the 7.10 Release
Oracle
Oracle
  • 19c
  • 21c

Oracle on Amazon RDS
  • 19c version
    • 19.0.0.0
  • 21c version
    • 21.0.0.0

Oracle on Amazon RDS has some different behaviors than on-prem Oracle. The permissions required for the Datical user are slightly different and the backup configuration is different.

Postgres
EDB Postgres Advanced Server
  • 12
  • 13
  • 14
  • 15

Support for 13 was added in the 8.2 release

Support for 14 and 15 was added in the 8.5 release

PostgreSQL Community
  • 12
  • 13
  • 14
  • 15

Support for 12 & 13 was added in the 7.15 release
Support for 14 was added in the 8.2 release

Support for 15 was added in the 8.5 release

PostgreSQL on Amazon RDS
  • 12
  • 13
  • 14
  • 15

Support for 12 & 13 was added in the 7.17 release

Support for 14 was added in the 8.2 release

Support for 15 was added in the 8.5 release

PostgreSQL on Amazon Aurora
  • 12
  • 13
  • 14
  • 15

Support for 12 & 13 was added in 7.17 release

Support for 14 and 15 was added in the 8.5 release

PostgreSQL on Azure Database
(single server)
  • 11
Support for 11 was added in the 8.2 release


Database Setup

For a general overview of the schema or databases required for a release pipeline, see Overview of the Database Components Used by Liquibase Enterprise

You typically need to create the following objects:

For instructions on setting up Datical DB to work with your database, see the section for your database type in Configuring Databases for Liquibase Enterprise Release Pipelines.

You typically need to do the following tasks: