Software Downloads

Go to https://software.datical.com to download files. See details for the release below.

Customer Notices for Upgrades

In recent releases Liquibase Enterprise and Liquibase Business has introduced newer versions of third party utilities to improve performance and maintain security

Starting with the 6.10 release, Liquibase Enterprise will run in the OpenJDK runtime instead of the Oracle Java runtime
Starting with the 7.6 release, Liquibase Enterprise will run Oracle Instant Client 12.2

Please use the full install process for the desktop client GUI when upgrading from Liquibase Enterprise or Business 7.5 or earlier to Liquibase Enterprise or Business 7.8 (NOT an upgrade/update process):

If you are running version 7.5 or lower, please use the full install process for the desktop client GUI with 7.8 (NOT an upgrade/update process).
If you are running version 7.6 or higher, you can use whichever process you prefer for the desktop client GUI with 7.8 (full install or upgrade/update).

Documentation for v7.9

Documentation for the base release is available in the following forms:

Confluence space for Liquibase Enterprise/Datical DB - Datical Product Documentation Home
PDFs for Liquibase Enterprise on software.datical.com
Confluence space for Liquibase Business - https://datical-cs.atlassian.net/wiki/spaces/LBP
Deployment Monitoring Console (DMC) Documentation Site

Liquibase Enterprise & Business Clients (Datical DB)

Item	Path	File
Software	`COMMON/Datical_DB_Software/Datical_DB_7.9.XXXX`	Choose the Linux or Windows installation file for your system.
Liquibase Enterprise Documentation	`COMMON/Datical_Documentation/Datical_DB_Documentation`	`datical_db_docs_v7.9.pdf`
Composite Installation Repository	`COMMON/Datical_DB_Software/Datical_DB_7.9.XXXX`	`DaticalDbCompositeRepo-7.9.XXXX.zip`

Liquibase Deployment Monitoring Console (DMC)

With the 7.0 release Liquibase included a new, lightweight web-based Deployment Monitoring Console (DMC) that provides status and reporting information for all of your Liquibase Business & Enterprise projects through a browser. The new DMC is a simpler replacement for Datical Service that is much easier to install, manage and use.

Getting started with the Deployment Monitoring Console

To get started with DMC check out the following documentation resources:

Deployment Monitoring Console Software and Documentation

Liquibase Enterprise & Business Clients (Datical DB) and DMC Compatability

Each DMC release only works with certain releases of Liquibase Enterprise & Business Clients (Datical DB). Consult the Datical DB and Deployment Monitoring Console Compatibility Matrix to ensure compatibility.

Item	Path	File
Software	COMMON/Datical_DMC_Software/Datical_DMC_7.7.197	`datical-service-unix-7_7_197-master.sh`
DMC Documentation	`Online @ dmc.datical.com`	`<N/A>`

Deployment Monitoring Console Update Instructions

To upgrade from version 6.17 or earlier of Datical Service, consult the DMC Upgrade Guide

The process to update the Deployment Monitoring Console from version 7.0 or later to the latest version is very similar to the installation process. Consult the instructions below.

Expand for DMC update instructions

Navigate to software.datical.com, download and copy the datical-service-unix-7_7_197-master.sh file to your existing DMC server
Run the installer with the following command and enter your existing OS user as the admin user and admin group:
```
/home/datical> sudo bash /datical-service-unix-7_7_197-master.sh
```
When prompted for an install location, enter the directory of the previous DMC installation
The installer will update your installation and restart effected DMC services. You can begin using the new version of the DMC immediately.

New Features

Support for Azure SQL DB

Liquibase Business & Enterprise have extended full support to Microsoft’s DBaaS offering Azure SQL Database. Users of Azure SQL Database can deliver high quality database updates faster and safer using Liquibase’s CICD workflow that includes:

Deploy Packager
Customizable Rules Validation
Detailed Status & Reporting

To get started, consult the documentation: Azure SQL Database Setup

Note: Microsoft’s Azure SQL Managed Instance will be supported in a future release.

Configurable Pattern Matching for Label Assignment in Source Code Control Commit Messages

By default, comma separated string values that are surrounded by square brackets in source code control commit messages will be added as labels to changesets produced by the corresponding scripts. Users can now override the use of square brackets with a different pattern provided as a regular expression in the commitMsgLabelRegexp property in their deployPackager.properties file for a given project. For more information see Using the Required deployPackager.properties File

Enable Override for the `NLS_LANG` Environment Variable for Oracle Projects

The NLS_LANG environment variable is used by SQL*Plus & Oracle databases to ensure that script contents are correctly interpreted during execution and that data values are stored appropriately in the database. The NLS_LANG environment variable can now be set on a project by project basis so that users no longer have to set those environment variables outside of their Liquibase Enterprise operations. For more information on setting this project property see Writing SQL Scripts for Datical DB

Recent Notable Changes

(Enterprise & Business 7.6) DATA_DML Package Method Creates Changesets With Oracle SQL Parser Disabled by Default

Using Oracle SQL Parser for large DML scripts can result in performance issues during Forecast and Deploy operations. Because these scripts should only include data modifications and Oracle SQL Parser is designed to provide insight into DDL operations, Oracle SQL Parser provides little to no value to DML scripts. Starting with version 7.6, Oracle SQL Parser will be disabled for scripts Packaged using the DATA_DML package method. If you wish to re-enable Oracle SQL Parser for scripts Packaged using the DATA_DML package method, you may do so by setting disableSqlParser=false in the metadata.properties for that directory or sub-directory.

For more information consult the documentation: Using the metadata.properties file

Issues Addressed

Liquibase Business & Enterprise Issues

Issue ID	Description
DAT-5776	GUI: "Execute with SQLPlus" with Forecast DML doesn't forecast scripts in Resources/sql
DAT-5502	Create "Execute with EDB*Plus" Option in Change Set Wizard
DAT-5340	GUI: ChangelogSync no longer refreshes dbDef status
DAT-5299	Datical install shows application requires a Java Runtime Environment 1.7.0
DAT-5228	UTF-8-BOM file results in Packager error "Unable to detect character encoding for script"
DAT-5178	Ability to specify commit label format eg. WI 999999 instead of [999999]
DAT-5160	Enable setting/resetting NLS_LANG environment variable for each deployment
DAT-4809	Warning message says resync (should be "force sync" button and "forceSync" command)
DAT-4606	Strip out or ignore non-recognized characters (\xa0) from scripts

Deployment Monitoring Console (DMC) Issues

There are no DMC updates for Liquibase Business & Enterprise release 7.9.

Known Issues & Planned Deprecation of Features

Oracle Accelerator JDBC Driver

Because of a change in deployment trends and continued improvement of the performance of Datical DB, the Oracle Accelerator JDBC Driver will be removed from our driver repository and no longer supported no later than 19 Feb 2021 .

Known Issues with Oracle Accelerator

Issue ID	Description
DAT-4808	Packaging with manifest is failing with timeout if oracle accelerator is enabled
DAT-4375	GUI :: Datical Accelerator connection issue

Documentation Spaces for Older Releases

See Customer Success Resources in the Releases with Doc Spaces section for a list of spaces available for older releases (prior to 6.7).

Datical v7.9 - Release Notes